Closed
Description
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