Xiang Gu

sql/catalog/tabledesc: fixed a bug in `maybeAddConstraintIDs`

5

Previously, when we RunPostDeserializationChanges, one of the step is to fill in constraint IDs if they are not already set, which is done in function `maybeAddConstraintIDs`. That function however is...

sql/schemachanger: Enable adding/dropping path of check constraint

1

Previously, we emit unimplemented operations on the adding and dropping path of check constraint and constraint name. This PR enables this feature as it will unblock certain DDL statement in...

Hi, thank you for sharing your code here. I found your code very helpful to me to learn something about FER. But there are two things I think you can...

tests: new roachtest for job backward compatibility in new schema changer

1

Backport 2/2 commits from #86950. /cc @cockroachdb/release --- Commit 1: Moved a few functions so that we can reuse them in the next commit. Commit 2: We added a roachtest...

rule: changed two dep rules

1

Commit 1: changed two existing dep rules slightly as to not cause any functional changes, but it's necessary for the next commit. Commit 2: added a dep rule between the...

schemachanger: dropping a column with a constraint fails concurrent DML

1

If a column is referenced in a constraint (e.g. check, unique-without-index), then dropping that column (which requires dropping of the constraint as well) currently fails concurrent DML stmts. A simple...

Xiang Gu (Xiang-Gu) commented: There are some caveats when restoring into a cluster with different regions, especially when the backup is taken with primary region set to the old region....