cockroachdb / cockroachdb/docs

sql/schemachanger: implement ALTER TABLE ... ADD PRIMARY KEY

Open
#14,851 0 comments 0 reactions 1 assignee Claimed by @rmloveland View on GitHub
C-product-change
Dominant language
HTML
Stars
212
Forks
476
Avg merge
40m
Merged PRs (30d)
3

Description

Exalate commented:

Related PR: https://github.com/cockroachdb/cockroach/pull/86195
Commit: https://github.com/cockroachdb/cockroach/commit/f9ac069d688826f41c83d89768551cd5ffb60c14

---

Release note (sql change): When running `ALTER TABLE ... ADD PRIMARY KEY`
or `ALTER TABLE ... ADD CONSTRAINT ... PRIMARY KEY` in a single-statement,
implicit transaction, when no primary key had been added to the table, the
old `rowid` column which had been automatically created as the table's
`PRIMARY KEY` will now be dropped.

Jira Issue: DOC-5381

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.