sql: support crdb_internal.ranges{_no_leases} for secondary tenants#92131
sql: support crdb_internal.ranges{_no_leases} for secondary tenants#92131craig[bot] merged 1 commit intocockroachdb:masterfrom ecwall:multitenant_show_ranges
Conversation
This PR makes crdb_internal.ranges{_no_leases} and SHOW RANGES
work for secondary tenants.
Release note (sql change): crdb_internal.ranges{_no_leases} and
SHOW RANGES statements now work on secondary tenants.
Epic: CRDB-14522
knz
left a comment
There was a problem hiding this comment.
but also get a review from arul.
Reviewed 7 of 7 files at r1, all commit messages.
Reviewable status:complete! 1 of 0 LGTMs obtained (waiting on @arulajmani, @ecwall, @rafiss, @renatolabs, and @srosenberg)
pkg/sql/multitenant_admin_function_test.go line 71 at r1 (raw file):
// TODO(ewall): When moving tenant capability check to KV, // merge test w/ SkipSQLSystemTenantCheck variant into single test case if
nit: remove the extraneous space after //
arulajmani
left a comment
There was a problem hiding this comment.
Are there any logic tests that used SHOW RANGES or the like, that only worked for the system tenant before, but can now be moved such that they run as secondary tenants as well? If so, should we do that either as a separate commit or a new patch entirely?
Reviewed 7 of 7 files at r1, all commit messages.
Reviewable status:complete! 1 of 0 LGTMs obtained (waiting on @ecwall, @rafiss, @renatolabs, and @srosenberg)
pkg/sql/multitenant_admin_function_test.go line 309 at r1 (raw file):
false, /* skipSQLSystemTenantCheck */ ) // TODO(ewall): Retain splits after `TRUNCATE` for secondary tenants.
Let's open an issue about this, if there isn't one? This should be doable now that we've got this RangeIterator, right?
ecwall
left a comment
There was a problem hiding this comment.
There are some TTL tests that are commented out that I have a separate ticket for. I will created #93148 to look into this.
Reviewable status:
complete! 1 of 0 LGTMs obtained (waiting on @arulajmani, @knz, @rafiss, @renatolabs, and @srosenberg)
pkg/sql/multitenant_admin_function_test.go line 71 at r1 (raw file):
Previously, knz (Raphael 'kena' Poss) wrote…
nit: remove the extraneous space after
//
The extra indentation creates a multi-line TODO:
vs
pkg/sql/multitenant_admin_function_test.go line 309 at r1 (raw file):
Previously, arulajmani (Arul Ajmani) wrote…
Let's open an issue about this, if there isn't one? This should be doable now that we've got this
RangeIterator, right?
There is already a ticket: #82944.
I am not sure if that was the only thing blocking it though.
|
bors r=knz,arulajmani |
|
Build succeeded: |


This PR makes crdb_internal.ranges{_no_leases} and SHOW RANGES
work for secondary tenants.
Release note (sql change): crdb_internal.ranges{_no_leases} and
SHOW RANGES statements now work on secondary tenants.
Epic: CRDB-14522