[CALCITE-3171] SemiJoin on conditions push down throws IndexOutOfBoundsException

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.19.0
• Fix Version/s: 1.21.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Danny Chen
• Reporter: godfrey he
• Created: 03/Jul/19 07:39
• Updated: 10/Sep/19 21:36
• Resolved: 08/Jul/19 12:58

Description

the following code in RelOptUtil#pushDownJoinConditions only does not consider SEMI/ANTI join

    if (!extraLeftExprs.isEmpty() || !extraRightExprs.isEmpty()) {
      Mappings.TargetMapping mapping =
          Mappings.createShiftMapping(
              leftCount + extraLeftExprs.size()
                  + rightCount + extraRightExprs.size(),
              0, 0, leftCount,
              leftCount, leftCount + extraLeftExprs.size(), rightCount);
      relBuilder.project(relBuilder.fields(mapping.inverse()));
    }

Issue Links

• links to: GitHub Pull Request #1304