Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Drop uniqueness-providing constraints with dependent FK constraints #97538

Closed
Xiang-Gu opened this issue Feb 23, 2023 · 0 comments · Fixed by #97579
Closed

Drop uniqueness-providing constraints with dependent FK constraints #97538

Xiang-Gu opened this issue Feb 23, 2023 · 0 comments · Fixed by #97579
Assignees
@Xiang-Gu
Labels
C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)

Comments

@Xiang-Gu
Copy link
Contributor

Xiang-Gu commented Feb 23, 2023 •
edited by cockroach-jira-scripts
Loading

We should adequately support dropping uniqueness-providing constraints (notably Unique and UniqueWithoutIndex)
when it has dependent FK constraints, in both the legacy and declarative schema changer.

Jira issue: CRDB-24745
@Xiang-Gu Xiang-Gu added the C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. label Feb 23, 2023
@Xiang-Gu Xiang-Gu self-assigned this Feb 23, 2023
@blathers-crl blathers-crl bot added the T-sql-schema-deprecated Use T-sql-foundations instead label Feb 23, 2023
@Xiang-Gu Xiang-Gu mentioned this issue Feb 23, 2023
Merged
@craig craig bot closed this as completed in 7a3778b Feb 27, 2023
@exalate-issue-sync exalate-issue-sync bot added T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) and removed T-sql-schema-deprecated Use T-sql-foundations instead labels May 10, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@Xiang-Gu Xiang-Gu

Labels
C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

schemachanger: Support dropping column with referenced constraints Xiang-Gu/cockroach
1 participant
@Xiang-Gu