Skip to content

sql: Delete invalid TestDropColumnAfterMutations test#107489

Merged
craig[bot] merged 1 commit intocockroachdb:masterfrom
rimadeodhar:fix_drop_column
Jul 27, 2023
Merged

sql: Delete invalid TestDropColumnAfterMutations test#107489
craig[bot] merged 1 commit intocockroachdb:masterfrom
rimadeodhar:fix_drop_column

Conversation

@rimadeodhar
Copy link
Copy Markdown
Collaborator

This test checks the functionality for the following sequence of events:

  1. A txn adds a constraint to a column on a table.
  2. A separate txn drops the column.

However, this interaction between the two txns has been made explicit by the PR #92289. Since this PR, step (2) will fail if the constraint in step (1) is in the process of being added. As a result, the elaborate set up and sequence of events being tested in TestDropColumnAfterMutations is no longer necessary.

Release note: none
Epic: none
Fixes: #76843

This test checks the functionality for the following sequence
of events:
1. A txn adds a constraint to a column on a table.
2. A separate txn drops the column.

However, this interaction between the two txns has been
made explicit by the PR cockroachdb#92289.
Since this PR, step (2) will fail if the constraint in step (1)
is in the process of being added. As a result, the elaborate
set up and sequence of events being tested in TestDropColumnAfterMutations
is no longer necessary.

Release note: none
Epic: none
Fixes: cockroachdb#76843
@rimadeodhar rimadeodhar requested a review from postamar July 24, 2023 19:15
@cockroach-teamcity
Copy link
Copy Markdown
Member

This change is Reviewable

@rimadeodhar rimadeodhar marked this pull request as ready for review July 24, 2023 19:15
@rimadeodhar rimadeodhar requested a review from a team as a code owner July 24, 2023 19:15
@rimadeodhar rimadeodhar added the backport-23.1.x PAST MAINTENANCE SUPPORT: 23.1 patch releases via ER request only label Jul 24, 2023
Copy link
Copy Markdown

@postamar postamar left a comment

Choose a reason for hiding this comment

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

Nice! Good riddance.

@rafiss
Copy link
Copy Markdown
Collaborator

rafiss commented Jul 27, 2023

thanks for investigating this! i'll go ahead and merge this to close out the linked issue

bors r+

@rimadeodhar
Copy link
Copy Markdown
Collaborator Author

Thanks for kicking off the merge! Sorry, I didn't realize this had been approved since Monday.

@craig craig bot merged commit 68e43c8 into cockroachdb:master Jul 27, 2023
@craig
Copy link
Copy Markdown
Contributor

craig bot commented Jul 27, 2023

Build succeeded:

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

backport-23.1.x PAST MAINTENANCE SUPPORT: 23.1 patch releases via ER request only

Projects

None yet

Development

Successfully merging this pull request may close these issues.

sql: TestDropColumnAfterMutations failed

4 participants