Skip to content

roachtest: disable decimal columns in costfuzz and unoptimized tests#89449

Merged
craig[bot] merged 1 commit intocockroachdb:masterfrom
rytaft:disable-decimals-again
Oct 6, 2022
Merged

roachtest: disable decimal columns in costfuzz and unoptimized tests#89449
craig[bot] merged 1 commit intocockroachdb:masterfrom
rytaft:disable-decimals-again

Conversation

@rytaft
Copy link
Copy Markdown
Collaborator

@rytaft rytaft commented Oct 5, 2022

This commit fixes an oversight from #89200 which failed to disable decimals in one case that was making costfuzz and unoptimized-query-oracle tests flaky.

Fixes #89303

Release note: None

This commit fixes an oversight from cockroachdb#89200 which failed to disable
decimals in one case that was making costfuzz and unoptimized-query-oracle
tests flaky.

Fixes cockroachdb#89303

Release note: None
@rytaft rytaft requested review from DrewKimball and mgartner October 5, 2022 22:17
@rytaft rytaft requested a review from a team as a code owner October 5, 2022 22:17
@cockroach-teamcity
Copy link
Copy Markdown
Member

This change is Reviewable

Copy link
Copy Markdown
Collaborator

@DrewKimball DrewKimball left a comment

Choose a reason for hiding this comment

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

Thanks for fixing this! :lgtm:

Reviewable status: :shipit: complete! 1 of 0 LGTMs obtained (waiting on @mgartner)

Copy link
Copy Markdown
Contributor

@msirek msirek 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! 1 of 0 LGTMs obtained (waiting on @mgartner and @rytaft)


pkg/internal/sqlsmith/type.go line 48 at r1 (raw file):

	case types.DecimalFamily:
		if s.disableDecimals {
			typ = s.randType()

The calls to RandColumnType in makeAlterColumnType and makeAddColumn probably need modification as well.
There is also randColumnTableDef in randgen.

Copy link
Copy Markdown
Collaborator Author

@rytaft rytaft left a comment

Choose a reason for hiding this comment

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

TFTRs!

I’m going to go ahead and merge this to hopefully avoid more flakes tonight

bors r+

Reviewable status: :shipit: complete! 1 of 0 LGTMs obtained (waiting on @mgartner and @msirek)


pkg/internal/sqlsmith/type.go line 48 at r1 (raw file):

Previously, msirek (Mark Sirek) wrote…

The calls to RandColumnType in makeAlterColumnType and makeAddColumn probably need modification as well.
There is also randColumnTableDef in randgen.

I’m not actually worried about the DDL— I think it’s ok if the table columns are decimal as long as they don’t get returned in the query

@craig
Copy link
Copy Markdown
Contributor

craig bot commented Oct 6, 2022

Build succeeded:

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.

roachtest: unoptimized-query-oracle/disable-rules=all failed

4 participants