cockroachdb / cockroachdb/cockroach
schemachanger:`ALTER PARTITION ... OF INDEX idx@*`
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
We fallback to the legacy schema changer in the case where we try to configure the zone of all partitions with the same name for all indexes
```
To define replication zones for identically named partitions of a table and its secondary indexes, you can use the @* syntax to save several steps:
ALTER PARTITION us_west OF INDEX vehicles@*
CONFIGURE ZONE USING
num_replicas = 5,
constraints = '[+region=us-west1]';
```
Although, having identically named partitions is not something that our code seems to support correctly: https://github.com/cockroachdb/cockroach/issues/128692#issuecomment-2354020459
Jira issue: CRDB-42261
Epic CRDB-31168
Contributor guide
Assessment
This issue has not been assessed yet.