Roman Kondakov created CALCITE-5670: ---------------------------------------
Summary: Assertion error in SemiJoinJoinTransposeRule Key: CALCITE-5670 URL: https://issues.apache.org/jira/browse/CALCITE-5670 Project: Calcite Issue Type: Bug Affects Versions: 1.34.0 Reporter: Roman Kondakov Assignee: Roman Kondakov Fix For: 1.35.0 The following test will raise the assertion error: {code:java} @Test void testPushSemiJoinPastJoinRuleNotHappensJoinKeysDifferentOrigin() { // tests the case where the semijoin is pushed to the right final String sql = "select e.ename from emp e, dept d, bonus b\n" + "where e.deptno = d.deptno and e.ename = b.ename and d.name = b.job"; sql(sql) .withRule(CoreRules.FILTER_INTO_JOIN, CoreRules.JOIN_ADD_REDUNDANT_SEMI_JOIN, CoreRules.SEMI_JOIN_JOIN_TRANSPOSE) .check(); } {code} {noformat} java.lang.AssertionError at org.apache.calcite.rel.rules.SemiJoinJoinTransposeRule.onMatch(SemiJoinJoinTransposeRule.java:112) at org.apache.calcite.plan.AbstractRelOptPlanner.fireRule(AbstractRelOptPlanner.java:337) at org.apache.calcite.plan.hep.HepPlanner.applyRule(HepPlanner.java:556) at org.apache.calcite.plan.hep.HepPlanner.applyRules(HepPlanner.java:420) at org.apache.calcite.plan.hep.HepPlanner.executeRuleInstance(HepPlanner.java:243) at org.apache.calcite.plan.hep.HepInstruction$RuleInstance$State.execute(HepInstruction.java:178) at org.apache.calcite.plan.hep.HepPlanner.lambda$executeProgram$0(HepPlanner.java:211) at com.google.common.collect.ImmutableList.forEach(ImmutableList.java:422) at org.apache.calcite.plan.hep.HepPlanner.executeProgram(HepPlanner.java:210) at org.apache.calcite.plan.hep.HepProgram$State.execute(HepProgram.java:118) at org.apache.calcite.plan.hep.HepPlanner.executeProgram(HepPlanner.java:205) at org.apache.calcite.plan.hep.HepPlanner.findBestExp(HepPlanner.java:191) at org.apache.calcite.test.RelOptFixture.checkPlanning(RelOptFixture.java:379) at org.apache.calcite.test.RelOptFixture.check(RelOptFixture.java:330) at org.apache.calcite.test.RelOptFixture.check(RelOptFixture.java:314) at org.apache.calcite.test.RelOptRulesTest.testPushSemiJoinPastJoinRuleNotHappensJoinKeysDifferentOrigin(RelOptRulesTest.java:2650) {noformat} The problem here is that the case when top-most Semi-Join has join keys from both tables of the bottom Join is considered impossible, though it happens in practice. -- This message was sent by Atlassian Jira (v8.20.10#820010)