SortMergeJoin: Add fuzz tests for SMJ when the JoinFilter is set

[comphead]

Is your feature request related to a problem or challenge?

SMJ now is in experimental state, and the test coverage can be improved. Because of poor test coverage it was found multiple bugs manually, with tests it would be much easier

Describe the solution you'd like

I would like to expand fuzz test coverage for SMJ in join_fuzz.rs to support scenarios when the JoinFilter is set.

datafusion/datafusion/core/tests/fuzz_cases/join_fuzz.rs

Line 179 in 8bedecc

None,

Currently JoinFilter is hardcoded as None for SMJ and would be great to start work for adding filter test cases

Describe alternatives you've considered

No response

Additional context

No response

[edmondop]

@comphead would you please have a look at #10728? While hashjoin and sortmergejoin produce the same result when adding a filter, NestedLoopJoin doesn't, but I can't figure out what error I made in combining the two filters

[comphead]

@edmondop I'd suggest to make one step a time. join filter can be tricky, my vision we should be starting with HJ and SMJ for now. Leave NLJ for later

[edmondop]

Ok I will proceed to remove the join filter on the nested loop !

[comphead]

Appreciate if you could file the issue cc'ing me with NLJ wrong behavior details

[edmondop]

@comphead I filed this #10787, I have only added one test case with filtering at the moment, do you think we need to add one test case with filtering for each of the existing test cases?

[comphead]

RightJoin and LeftAnti join will addressed in separate PRs