cockroachdb / cockroachdb/cockroach
workload: add SET IDENTITY and editing sequence options to random schema workload
Open
A-random-schema-change-workload
A-testing
C-enhancement
O-premortem
T-sql-foundations
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
We recently added support in the declarative schema changer for `ALTER TABLE ... ADD GENERATED ... AS IDENTITY` and changing the identity options with `ALTER COLUMN ... [RESTART | SET [CACHE | CYCLE | ... ]`
To enhance our testing coverage of these kinds of statements, let's add all of that syntax to the random schema workload. For each statement type, add an operation to the workload here: https://github.com/cockroachdb/cockroach/blob/dc72c30c6ce44ca0b5711a4ef62d77a1d39decf3/pkg/workload/schemachange/optype.go#L215
Jira issue: CRDB-58013
Epic CRDB-60873
Contributor guide
Assessment
This issue has not been assessed yet.