[CALCITE-3285] EnumerableMergeJoin should support non-equi join conditions

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.23.0
• Labels: pull-request-available
• Assignee: Ruben Q L
• Reporter: Haisheng Yuan
• Created: 22/Aug/19 23:24
• Updated: 24/May/20 12:00
• Resolved: 19/Mar/20 17:10

Description

Calcite should be able to generate EnumerableMergeJoin with non-equi join conditions, as long as there are equi-join conditions.

Issue Links

• blocks: CALCITE-3833 Support SemiJoin in EnumerableMergeJoin
• blocks: CALCITE-3834 Support AntiJoin in EnumerableMergeJoin
• is related to: CALCITE-2973 Allow theta joins that have equi conditions to be executed using a hash join algorithm
• is related to: CALCITE-3284 Enumerable hash semijoin / antijoin support non-equi join conditions
• relates to: CALCITE-3667 EnumerableMergeJoin should not use take-while enumerator
• links to: GitHub Pull Request #1576
• links to: GitHub Pull Request #1788