[CALCITE-4113] Support LEFT join in EnumerableMergeJoin

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.26.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Ruben Q L
• Reporter: Ruben Q L
• Created: 08/Jul/20 15:27
• Updated: 06/Oct/20 17:16
• Resolved: 24/Aug/20 09:17

Description

Currently, EnumerableMergeJoin supports INNER, SEMI, and ANTI join.
The goal of this ticket is to support also LEFT join (which should be a combination of INNER join results + ANTI join results with a NULL on the right).
LEFT EnumerableMergeJoin should maintain the order of the left-hand-side of the join.

Issue Links

• is related to: CALCITE-3833 Support SemiJoin in EnumerableMergeJoin
• is related to: CALCITE-3834 Support AntiJoin in EnumerableMergeJoin
• links to: GitHub Pull Request #2107