Skip to content

execbuilder: de-flake a recently introduced test#97775

Merged
craig[bot] merged 1 commit intocockroachdb:masterfrom
yuzefovich:deflake-system-table-stats
Feb 28, 2023
Merged

execbuilder: de-flake a recently introduced test#97775
craig[bot] merged 1 commit intocockroachdb:masterfrom
yuzefovich:deflake-system-table-stats

Conversation

@yuzefovich
Copy link
Copy Markdown
Member

I'm not able to reproduce the flake under stress, but for some reason it appears that the stats on a system table are collected even though we disable the auto stats collection. Those stats rarely show a different estimated row count, so this commit skips that line from the output of the EXPLAIN. This is acceptable given the goal of the test is ensuring that a secondary index is used for the scan.

Fixes: #97771.

Release note: None

I'm not able to reproduce the flake under stress, but for some reason it
appears that the stats on a system table are collected even though we
disable the auto stats collection. Those stats rarely show a different
`estimated row count`, so this commit skips that line from the output of
the EXPLAIN. This is acceptable given the goal of the test is ensuring
that a secondary index is used for the scan.

Release note: None
@yuzefovich yuzefovich requested review from a team, michae2 and msirek February 28, 2023 02:10
@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.

:lgtm:

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

@yuzefovich
Copy link
Copy Markdown
Member Author

TFTR!

bors r+

@craig
Copy link
Copy Markdown
Contributor

craig bot commented Feb 28, 2023

Build succeeded:

@craig craig bot merged commit b0e5507 into cockroachdb:master Feb 28, 2023
@yuzefovich yuzefovich deleted the deflake-system-table-stats branch February 28, 2023 06:11
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.

pkg/sql/opt/exec/execbuilder/tests/local/local_test: TestExecBuild_explain_analyze failed

3 participants