Skip to content

sql: test ON UPDATE's interaction with backfills over row#75846

Merged
craig[bot] merged 1 commit intocockroachdb:masterfrom
ZhouXing19:onupdate-backfill
Feb 3, 2022
Merged

sql: test ON UPDATE's interaction with backfills over row#75846
craig[bot] merged 1 commit intocockroachdb:masterfrom
ZhouXing19:onupdate-backfill

Conversation

@ZhouXing19
Copy link
Copy Markdown
Collaborator

Fixes #69058

Release Note: none

@ZhouXing19 ZhouXing19 requested a review from a team February 2, 2022 04:57
@cockroach-teamcity
Copy link
Copy Markdown
Member

This change is Reviewable

ALTER TYPE test_enum DROP VALUE 'y'

# Interaction with backfills over row
subtest SimpleUsage
Copy link
Copy Markdown
Contributor

Choose a reason for hiding this comment

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

maybe subtest test_on_update_backfill

statement error pq: could not remove enum value "y" as it is being used in an ON UPDATE expression of "test_array_enum"
ALTER TYPE test_enum DROP VALUE 'y'

# Interaction with backfills over row
Copy link
Copy Markdown
Contributor

Choose a reason for hiding this comment

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

let's make the comment "Tests adding new columns will not trigger the ON UPDATE clause."

Copy link
Copy Markdown
Collaborator Author

Choose a reason for hiding this comment

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

Thanks! Done.

@blathers-crl blathers-crl bot requested a review from otan February 2, 2022 15:21
@ZhouXing19
Copy link
Copy Markdown
Collaborator Author

Thanks!
bors r=otan

@craig
Copy link
Copy Markdown
Contributor

craig bot commented Feb 2, 2022

Build failed (retrying...):

@craig
Copy link
Copy Markdown
Contributor

craig bot commented Feb 3, 2022

Build failed (retrying...):

@craig
Copy link
Copy Markdown
Contributor

craig bot commented Feb 3, 2022

Build failed (retrying...):

@craig
Copy link
Copy Markdown
Contributor

craig bot commented Feb 3, 2022

Build succeeded:

@craig craig bot merged commit f20c1a8 into cockroachdb:master Feb 3, 2022
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.

sql: test ON UPDATE interactions

3 participants