-
Notifications
You must be signed in to change notification settings - Fork 4.1k
sql/schemachanger: support trivial ALTER COLUMN ... SET TYPE in declarative schema changer #126143
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)T-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Description
The ALTER COLUMN ... TYPE command should be implemented in the declarative schema changer. This issue is used to track the work for trivial changes. Trivial changes are data type changes that don't require a backfill or a shadow column. Only update to the type in the descriptor is needed. One example of a trivial change is to alter the type from a SMALLINT to a BIGINT, or CHAR(10) to a CHAR(20).
We should make sure to avoid as many of the known limitations tracked in CRDB-25314 as we can.
Epic: CRDB-25314
Jira issue: CRDB-39782
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)T-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)SQL Foundations Team (formerly SQL Schema + SQL Sessions)