Skip to content

Flaky fuzz tests for filtered outer SortMergeJoin #12359

Closed
@korowa

Description

@korowa

Describe the bug

After replacing the filter for join fuzz tests with the selective one (that doesn't return 100% of input rows), it turned out that following tests may periodically fail for HashJoin vs SortMergeJoin cases:

  • test_left_join_1k_filtered
  • test_right_join_1k_filtered
  • test_full_join_1k_filtered

To Reproduce

To reproduce this one should add JoinTestType::HjSmj to mentioned above test cases and run them (likely a couple of times)

Expected behavior

SMJ and HJ should return equal resultsets for these test cases

Additional context

No response

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions