cockroachdb / cockroachdb/cockroach
sql: adjust the syntax of `SHOW SETTINGS FOR TENANT` to emphasize that it reports only _overrides_ and not the actual configuration
Open
A-multitenancy
A-sql-syntax
C-enhancement
T-db-server
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
**Problem**
The output of `SHOW SETTINGS FOR TENANT` reports only the overrides (set from the system tenant). It does not report the actual configuration effected on the tenants -- where, if no override is set, the value is taken from the tenant's keyspace and invisible to the `SHOW SETTINGS FOR TENANT` execution.
**Expected solution**
Maybe `SHOW SETTING OVERRIDES FOR TENANT` instead.
Jira issue: CRDB-28559
Epic: CRDB-26691
Contributor guide
Assessment
This issue has not been assessed yet.