Skip to content

workload/tpch: add a couple of missed values for fixtures generation#156002

Merged
craig[bot] merged 1 commit intocockroachdb:masterfrom
yuzefovich:tpch-fix-fixtures
Oct 24, 2025
Merged

workload/tpch: add a couple of missed values for fixtures generation#156002
craig[bot] merged 1 commit intocockroachdb:masterfrom
yuzefovich:tpch-fix-fixtures

Conversation

@yuzefovich
Copy link
Copy Markdown
Member

When we added the fixtures generation of TPCH spec, we forgot a couple of values - one for "priorities" and one for "containers". This commit fixes that omission. In particular, missing priority value made us return 4 rows instead of 5 for Q4, and the expectation has been adjusted accordingly.

Note that this omission was exposed via a roachtest that uses correctly generated fixtures of SF 100.

Fixes: #155834.

Release note: None

@yuzefovich yuzefovich requested review from a team and DrewKimball October 23, 2025 19:20
@yuzefovich yuzefovich requested a review from a team as a code owner October 23, 2025 19:20
@yuzefovich yuzefovich requested review from golgeek and srosenberg and removed request for a team October 23, 2025 19:20
@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.

:lgtm: Wow, nice job finding that!

@DrewKimball reviewed 2 of 2 files at r1, all commit messages.
Reviewable status: :shipit: complete! 1 of 0 LGTMs obtained (waiting on @yuzefovich)

@yuzefovich
Copy link
Copy Markdown
Member Author

TFTR and for the nudge to look into this!

For posterity, I also updated the backup we use in sqlsmith/tpch with freshly regenerated fixture with seed=1.

bors r+

@yuzefovich
Copy link
Copy Markdown
Member Author

bors r+

craig bot pushed a commit that referenced this pull request Oct 23, 2025
155783: sql: several preliminary changes to making tests work with secondary tenants r=yuzefovich a=yuzefovich

This PR contains several commits which audit tests in `pkg/sql` directory to ensure the right JobRegistry, codec, LeaseManager, and PGUrl are used. Almost all were pretty mechanical changes. Note that no new tests are enabled with secondary tenants yet - this will be done separately.

Epic: CRDB-48945


156002: workload/tpch: add a couple of missed values for fixtures generation r=yuzefovich a=yuzefovich

When we added the fixtures generation of TPCH spec, we forgot a couple of values - one for "priorities" and one for "containers". This commit fixes that omission. In particular, missing priority value made us return 4 rows instead of 5 for Q4, and the expectation has been adjusted accordingly.

Note that this omission was exposed via a roachtest that uses correctly generated fixtures of SF 100.

Fixes: #155834.

Release note: None

156008: Revert "publish-artifacts: change GCS latest key prefix for Workload … r=rail a=williamchoe3

Original PR: #155789

Reverting to split into 2 commits for easier backport

Co-authored-by: Yahor Yuzefovich <yahor@cockroachlabs.com>
Co-authored-by: William Choe <williamchoe3@gmail.com>
@craig
Copy link
Copy Markdown
Contributor

craig bot commented Oct 23, 2025

Build failed (retrying...):

@yuzefovich
Copy link
Copy Markdown
Member Author

Oops, one test needs an update.

bors r-

@craig
Copy link
Copy Markdown
Contributor

craig bot commented Oct 23, 2025

Canceled.

When we added the fixtures generation of TPCH spec, we forgot a couple
of values - one for "priorities" and one for "containers". This commit
fixes that omission. In particular, missing priority value made us
return 4 rows instead of 5 for Q4, and the expectation has been adjusted
accordingly.

Note that this omission was exposed via a roachtest that uses correctly
generated fixtures of SF 100.

Release note: None
@yuzefovich
Copy link
Copy Markdown
Member Author

bors r+

craig bot pushed a commit that referenced this pull request Oct 23, 2025
155988: sqlccl: ignore known bug in TestExplainGist r=yuzefovich a=yuzefovich

See: #125620
Informs: #155948

Release note: None



156002: workload/tpch: add a couple of missed values for fixtures generation r=yuzefovich a=yuzefovich

When we added the fixtures generation of TPCH spec, we forgot a couple of values - one for "priorities" and one for "containers". This commit fixes that omission. In particular, missing priority value made us return 4 rows instead of 5 for Q4, and the expectation has been adjusted accordingly.

Note that this omission was exposed via a roachtest that uses correctly generated fixtures of SF 100.

Fixes: #155834.

Release note: None

Co-authored-by: Yahor Yuzefovich <yahor@cockroachlabs.com>
@craig
Copy link
Copy Markdown
Contributor

craig bot commented Oct 24, 2025

Build failed (retrying...):

@craig
Copy link
Copy Markdown
Contributor

craig bot commented Oct 24, 2025

@craig craig bot merged commit 6a044fb into cockroachdb:master Oct 24, 2025
22 of 24 checks passed
@yuzefovich yuzefovich deleted the tpch-fix-fixtures branch October 24, 2025 06:42
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Projects

None yet

Development

Successfully merging this pull request may close these issues.

roachtest: import-cancellation failed

3 participants