Support RightMark join for SortMergeJoin #16226
Description
Is your feature request related to a problem or challenge?
Mentioned as a TODO statement here: #16083.
Describe the solution you'd like
Support RightMark joins for SortMergeJoin with proper unit tests.
Describe alternatives you've considered
No response
Additional context
No response