Skip to content

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

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

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

Conversation

@rytaft
Copy link
Copy Markdown
Collaborator

@rytaft rytaft commented Oct 3, 2022

The use of decimal columns was making costfuzz and unoptimized-query-oracle tests flaky. This commit disables generation of decimal columns as a temporary mitigation for these flakes.

Fixes #88547

Release note: None

@rytaft rytaft requested review from mgartner and msirek October 3, 2022 15:56
@rytaft rytaft requested a review from a team as a code owner October 3, 2022 15:56
@cockroach-teamcity
Copy link
Copy Markdown
Member

This change is Reviewable

Copy link
Copy Markdown
Collaborator

@michae2 michae2 left a comment

Choose a reason for hiding this comment

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

Thanks!

Does this also handle decimal columns in CREATE TABLE statements? It looks like the various randTables functions in setup.go are calling into randgen.RandCreateTables which doesn't seem to use these type-generating functions?

Could you also add DisableDecimals as an option to smith here? Thank you!

Reviewed 4 of 4 files at r1, all commit messages.
Reviewable status: :shipit: complete! 0 of 0 LGTMs obtained (waiting on @mgartner and @msirek)

The use of decimal columns was making costfuzz and unoptimized-query-oracle
tests flaky. This commit disables generation of decimal columns as a temporary
mitigation for these flakes.

Fixes cockroachdb#88547

Release note: None
@rytaft
Copy link
Copy Markdown
Collaborator Author

rytaft commented Oct 3, 2022

TFTR!

Does this also handle decimal columns in CREATE TABLE statements? It looks like the various randTables functions in setup.go are calling into randgen.RandCreateTables which doesn't seem to use these type-generating functions?

No, I don't think this changes anything about the CREATE TABLE statements, but I think that's ok, since the non-determinism seems mostly related to the output.

Could you also add DisableDecimals as an option to smith here? Thank you!

Done.

Copy link
Copy Markdown
Collaborator

@michae2 michae2 left a comment

Choose a reason for hiding this comment

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

:lgtm:

Reviewed 1 of 1 files at r2, all commit messages.
Reviewable status: :shipit: complete! 1 of 0 LGTMs obtained (waiting on @mgartner and @msirek)

@rytaft
Copy link
Copy Markdown
Collaborator Author

rytaft commented Oct 3, 2022

TFTR!

bors r+

@craig
Copy link
Copy Markdown
Contributor

craig bot commented Oct 3, 2022

Build succeeded:

@rytaft
Copy link
Copy Markdown
Collaborator Author

rytaft commented Oct 5, 2022

blathers backport 22.2.0

rytaft added a commit to rytaft/cockroach that referenced this pull request Oct 5, 2022
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
craig bot pushed a commit that referenced this pull request Oct 6, 2022
89449: roachtest: disable decimal columns in costfuzz and unoptimized tests r=rytaft a=rytaft

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

Co-authored-by: Rebecca Taft <becca@cockroachlabs.com>
blathers-crl bot pushed a commit that referenced this pull request Oct 6, 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
blathers-crl bot pushed a commit that referenced this pull request Oct 6, 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
rytaft added a commit that referenced this pull request Oct 7, 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
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: disable usage of decimals in costfuzz and unoptimized query oracle

3 participants