Skip to content

sqlsmith: add DEFAULT expressions to newly added columns#99312

Merged
craig[bot] merged 1 commit intocockroachdb:masterfrom
mgartner:default-column-expr
Mar 31, 2023
Merged

sqlsmith: add DEFAULT expressions to newly added columns#99312
craig[bot] merged 1 commit intocockroachdb:masterfrom
mgartner:default-column-expr

Conversation

@mgartner
Copy link
Copy Markdown
Contributor

@mgartner mgartner commented Mar 22, 2023

Sqlsmith now builds ALTER TABLE .. ADD COLUMN .. DEFAULT statements
with default expressions that have different types than the column type.
This is allowed if the default expression type can be assignment-casted
to the column's type.

Fixes #98133

Release note: None

@mgartner mgartner requested a review from rharding6373 March 22, 2023 22:52
@mgartner mgartner requested a review from a team as a code owner March 22, 2023 22:52
@cockroach-teamcity
Copy link
Copy Markdown
Member

This change is Reviewable

@mgartner mgartner force-pushed the default-column-expr branch from d425c87 to 34dfb73 Compare March 22, 2023 22:54
Copy link
Copy Markdown
Collaborator

@rharding6373 rharding6373 left a comment

Choose a reason for hiding this comment

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

:lgtm: Nice!

Reviewable status: :shipit: complete! 1 of 0 LGTMs obtained

@mgartner
Copy link
Copy Markdown
Contributor Author

TFTR!

bors r+

@craig
Copy link
Copy Markdown
Contributor

craig bot commented Mar 23, 2023

Build failed:

@mgartner
Copy link
Copy Markdown
Contributor Author

Looks like a flake.

bors r+

@mgartner
Copy link
Copy Markdown
Contributor Author

bors r+

@craig
Copy link
Copy Markdown
Contributor

craig bot commented Mar 28, 2023

Build failed (retrying...):

@craig
Copy link
Copy Markdown
Contributor

craig bot commented Mar 28, 2023

Build failed (retrying...):

@craig
Copy link
Copy Markdown
Contributor

craig bot commented Mar 28, 2023

Build failed (retrying...):

@craig
Copy link
Copy Markdown
Contributor

craig bot commented Mar 29, 2023

Build failed (retrying...):

@craig
Copy link
Copy Markdown
Contributor

craig bot commented Mar 29, 2023

This PR was included in a batch that successfully built, but then failed to merge into master. It will not be retried.

Additional information:

{"message":"Required status check \"Bazel Essential CI (Cockroach)\" is pending.","documentation_url":"https://docs.github.com/articles/about-protected-branches"}

Sqlsmith now builds `ALTER TABLE .. ADD COLUMN .. DEFAULT` statements
with default expressions that have different types than the column type.
This is allowed if the default expression type can be assignment-casted
to the column's type.

Fixes cockroachdb#98133

Release note: None
@mgartner mgartner force-pushed the default-column-expr branch from 34dfb73 to b966677 Compare March 31, 2023 13:00
@mgartner
Copy link
Copy Markdown
Contributor Author

bors r+

@craig craig bot merged commit dcac33e into cockroachdb:master Mar 31, 2023
@craig
Copy link
Copy Markdown
Contributor

craig bot commented Mar 31, 2023

Build succeeded:

@mgartner mgartner deleted the default-column-expr branch March 31, 2023 15:53
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.

sqlsmith/randgen: generate DEFAULT expressions that don't match the column's type

3 participants