cockroachdb / cockroachdb/cockroach

schemachanger:`ALTER PARTITION ... OF INDEX idx@*`

Open
#130,842 0 comments 0 reactions 0 assignees View on GitHub
C-enhancement T-sql-foundations
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.