cockroachdb / cockroachdb/cockroach

ALTER INDEX to allow for STORING Clause

Open
#98,777 0 comments 2 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

**Is your feature request related to a problem? Please describe.**

Currently, when I need to add one additional column to `STORING` clause an entire new index must be created and the old one removed.

**Describe the solution you'd like**

Support syntax like: `ALTER INDEX ... STORING( )` to include a different set of columns.

**Additional context**

It would also be great if we had a `STORING` *all* clause to include all columns in the table. As described here... https://github.com/cockroachdb/cockroach/issues/79105

Also, to have this automatically add columns when an `ALTER TABLE ADD COLUMN` command is run.

related: https://github.com/cockroachdb/cockroach/issues/111380

Jira issue: CRDB-25514

Epic CRDB-60817

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.