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.

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

sql: sequence owner's ColumnDescriptor not updated after owned sequence is dropped #48249

Closed
RichardJCai opened this issue Apr 30, 2020 · 1 comment
Labels
A-schema-descriptors Relating to SQL table/db descriptor handling. C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.

Comments

@RichardJCai
Copy link
Contributor

Repro, have to inspect ColumnDescriptor of the column that owns the seq after the drop seq as no query shows this.

CREATE TABLE t(x INT);
CREATE SEQUENCE seq OWNED BY t.x;
DROP SEQUENCE seq;

# Need to manually inspect ColumnDescriptor for t.x after, one way is to drop the column and print the descriptor's OwnedSequenceIDs. The list will still contain the seq's ID.
@RichardJCai RichardJCai added C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. A-sql-execution Relating to SQL execution. labels Apr 30, 2020
@RichardJCai RichardJCai added A-schema-descriptors Relating to SQL table/db descriptor handling. and removed A-sql-execution Relating to SQL execution. labels Apr 30, 2020
@RichardJCai
Copy link
Contributor Author

Closing since #50649 encapsulates this issue.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
A-schema-descriptors Relating to SQL table/db descriptor handling. C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.
Projects
None yet
Development

No branches or pull requests

1 participant