-
Notifications
You must be signed in to change notification settings - Fork 4.1k
sql/schemachanger: support ALTER TABLE ... ALTER COLUMN ... [ADD | SET] ... IDENTITY in declarative schema changer #142918
Copy link
Copy link
Closed
Labels
A-schema-changer-implRelated to the implementation of the new schema changerRelated to the implementation of the new schema changerC-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)E-starterMight be suitable for a starter project for new employees or team members.Might be suitable for a starter project for new employees or team members.T-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Description
This tracks support for statements such as ALTER TABLE t ALTER COLUMN c ADD GENERATED ALWAYS AS IDENTITY (sequence_options) and ALTER TABLE t ALTER COLUMN c SET GENERATED ALWAYS AS IDENTITY in the declarative schema changer.
Support for ADD COLUMN ... IDENTITY was added in #139135. This change will have some similar parts, but for modifying an existing column.
Jira issue: CRDB-48584
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
A-schema-changer-implRelated to the implementation of the new schema changerRelated to the implementation of the new schema changerC-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)E-starterMight be suitable for a starter project for new employees or team members.Might be suitable for a starter project for new employees or team members.T-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)SQL Foundations Team (formerly SQL Schema + SQL Sessions)