workload: Add DRT operation for ALTER COLUMN TYPE #141712
Labels
C-enhancement
Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)
T-sql-foundations
SQL Foundations Team (formerly SQL Schema + SQL Sessions)
We want to add a new DRT operation to stress-test ALTER COLUMN TYPE. The key requirement for this operation is to avoid modifying existing column types, as that could disrupt ongoing queries. Instead, we will select a column from a table, clone it using ADD COLUMN, and then alter the type of the cloned column. By using an existing column as a reference, we ensure the cloned column contains meaningful data rather than just a single default value.
Steps for the operation:
INTX -> INTY
TEXT -> VARCHAR(N)
VARCHAR(N) -> TEXT
Jira issue: CRDB-47971
The text was updated successfully, but these errors were encountered: