Skip to content

sql: add issue link to ALTER TABLE DROP COLUMN with sql_safe_updates#55248

Merged
craig[bot] merged 1 commit intocockroachdb:masterfrom
ajwerner:ajwerner/add-issue-link-for-drop-column
Oct 20, 2020
Merged

sql: add issue link to ALTER TABLE DROP COLUMN with sql_safe_updates#55248
craig[bot] merged 1 commit intocockroachdb:masterfrom
ajwerner:ajwerner/add-issue-link-for-drop-column

Conversation

@ajwerner
Copy link
Copy Markdown
Contributor

@ajwerner ajwerner commented Oct 6, 2020

Explicit transactions with drop column are very dangerous. Inform the user.

Touches #51863.

Release note (sql change): Added a note to inform users with an issue link
when attempting potentially hazardous DROP COLUMN operations when
sql_safe_updates is enabled.

@ajwerner ajwerner requested a review from thoszhang October 6, 2020 13:35
@cockroach-teamcity
Copy link
Copy Markdown
Member

This change is Reviewable

Copy link
Copy Markdown

@thoszhang thoszhang left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Reviewable status: :shipit: complete! 0 of 0 LGTMs obtained (waiting on @ajwerner and @lucy-zhang)


pkg/sql/alter_table.go, line 341 at r1 (raw file):

					err = errors.WithIssueLink(err, issuelink.IssueLink{
						IssueURL: "https://github.com/cockroachdb/cockroach/issues/46541",
						Detail: "when used in an explicit combined with other schema " +

You left out transaction


pkg/sql/alter_table.go, line 343 at r1 (raw file):

						Detail: "when used in an explicit combined with other schema " +
							"changes to the same table, DROP COLUMN can result in data " +
							"loss if the other schema change fails or is canceled",

if one of the other schema changes...?

@ajwerner ajwerner force-pushed the ajwerner/add-issue-link-for-drop-column branch from 5bfd19d to ceff786 Compare October 12, 2020 15:35
Explicit transactions with drop column are very dangerous. Inform the user.

Touches cockroachdb#51863.

Release note (sql change): Added a note to inform users with an issue link
when attempting potentially hazardous DROP COLUMN operations when
sql_safe_updates is enabled.
@ajwerner ajwerner force-pushed the ajwerner/add-issue-link-for-drop-column branch from ceff786 to c029cc4 Compare October 13, 2020 12:31
@ajwerner
Copy link
Copy Markdown
Contributor Author

bors r=lucy-zhang

@craig
Copy link
Copy Markdown
Contributor

craig bot commented Oct 20, 2020

Build succeeded:

@craig craig bot merged commit 65bf9e6 into cockroachdb:master Oct 20, 2020
@rafiss rafiss added this to the 20.2 milestone Apr 22, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

4 participants