Ruben Q L created CALCITE-4261: ---------------------------------- Summary: Join with three tables causes IllegalArgumentException in EnumerableBatchNestedLoopJoinRule Key: CALCITE-4261 URL: https://issues.apache.org/jira/browse/CALCITE-4261 Project: Calcite Issue Type: Bug Components: core Affects Versions: 1.25.0 Reporter: Ruben Q L Fix For: 1.26.0
Issue can be reproduced with the following test (to be added in {{EnumerableBatchNestedLoopJoinTest}}): {code} @Test void doubleInnerBatchJoinTestSQL() { tester(false, new JdbcTest.HrSchema()) .query("select e.name, d.name as dept, l.name as location " + "from emps e join depts d on d.deptno <> e.salary " + "join locations l on e.empid <> l.empid and d.deptno = l.empid") .withHook(Hook.PLANNER, (Consumer<RelOptPlanner>) planner -> { planner.removeRule(EnumerableRules.ENUMERABLE_CORRELATE_RULE); planner.addRule(EnumerableRules.ENUMERABLE_BATCH_NESTED_LOOP_JOIN_RULE); }) .explainContains("EnumerableBatchNestedLoopJoin") .returnsUnordered("name=Bill; dept=Sales; location=San Francisco", "name=Eric; dept=Sales; location=San Francisco", "name=Sebastian; dept=Sales; location=San Francisco", "name=Theodore; dept=Sales; location=San Francisco"); } {code} Which causes: {code} Error while executing SQL "explain plan for select e.name, d.name as dept, l.name as location from emps e join depts d on d.deptno <> e.salary join locations l on e.empid <> l.empid and d.deptno = l.empid" ... Caused by: java.lang.RuntimeException: Error while applying rule EnumerableBatchNestedLoopJoinRule, ... Caused by: java.lang.IllegalArgumentException: Field #0: empid JavaType(int) does not exist for expression $cor1801 at com.google.common.base.Preconditions.checkArgument(Preconditions.java:122) ... at org.apache.calcite.adapter.enumerable.EnumerableBatchNestedLoopJoinRule.onMatch(EnumerableBatchNestedLoopJoinRule.java:127) at org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:229) ... {code} -- This message was sent by Atlassian Jira (v8.3.4#803005)