Faizan Qazi

opt: FoldAssignmentCast ignores transaction errors

9

**Describe the problem** Please describe the issue you observed, and any steps we can take to reproduce it: Currently, if a transaction error is hit inside `FoldAssignmentCast` when calling `PerformAssignmentCast`...

roachtest: add mixed version testing for the schema changer corpuses

2

Previously, we had no automated tests for validating mixed version compatibility. This new roachtest validates elements generated on the previous release against the current. It validates elements generated in a...

sql: reduce job times for randomized syntax change tests

1

Fixes: #86366, #87569 Previously, the exponential back off time for randomized syntax change tests was 20 seconds, which was inappropriate for some randomized tests, since transaction retry errors could lead...

catalog/lease: add metrics for tracking long lease waits

1

Previously, we had no way of knowing if WaitForOneVersion, WaitForNoVersion, or CheckTwoVersionInvariant, which wait for leases to expire are stuck. This becomes more problematic as we added migration to session-based...

release-23.1: catalog/lease: optimize lease count query

3

Previously, the query to count leases would end up scanning the entire system.leases table because of the addition of crdb_region as the first column on 23.1. This meant that scans...

release-23.2: catalog/lease: optimize lease count query

3

Previously, the query to count leases would end up scanning the entire system.leases table because of the addition of crdb_region as the first column on 23.1. This meant that scans...

sql: set survive zone on regional by row system tables

4

Now that the region liveness work has been work we can finally enable it on multi-region clusters. To help aid in this this patch will do the following: 1. All...

sql: collation using pg_catalog.default does not work

2

Currently CRDB does not support the builtin collation pg_catalog.default, which makes it incompatible with PostgresSQL. For example we support the following: ``` select 'a' < ('foo' COLLATE default); ``` but...

release-23.2.6-rc: catalog: add descriptor repair to remove missing roles

2

Backport 1/1 commits from #122557. /cc @cockroachdb/release --- Previously, we had a bug that could lead to descriptors having privileages to roles that no longer exist. This could lead to...

release-23.2.6-rc: sql: drop user/role did not detect usage by types

2

Backport 1/1 commits from #124611. /cc @cockroachdb/release --- Previously, it was possible to drop a user / role in use by a type because the detection logic only checked ownership....