github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/delegate/show_all_cluster_settings.go (about)

     1  // Copyright 2019 The Cockroach Authors.
     2  //
     3  // Use of this software is governed by the Business Source License
     4  // included in the file licenses/BSL.txt.
     5  //
     6  // As of the Change Date specified in that file, in accordance with
     7  // the Business Source License, use of this software will be governed
     8  // by the Apache License, Version 2.0, included in the file
     9  // licenses/APL.txt.
    10  
    11  package delegate
    12  
    13  import "github.com/cockroachdb/cockroach/pkg/sql/sem/tree"
    14  
    15  func (d *delegator) delegateShowClusterSettingList(
    16  	stmt *tree.ShowClusterSettingList,
    17  ) (tree.Statement, error) {
    18  	if err := d.catalog.RequireAdminRole(d.ctx, "SHOW CLUSTER SETTINGS"); err != nil {
    19  		return nil, err
    20  	}
    21  	if stmt.All {
    22  		return parse(
    23  			`SELECT variable, value, type AS setting_type, public, description
    24         FROM   crdb_internal.cluster_settings`,
    25  		)
    26  	}
    27  	return parse(
    28  		`SELECT variable, value, type AS setting_type, description
    29       FROM   crdb_internal.cluster_settings
    30       WHERE  public IS TRUE`,
    31  	)
    32  }