[jira] [Created] (CALCITE-6501) Assertion Error in JoinUnifyRule Due to Type Mismatch

["kate (Jira)" <ji...@apache.org>]

kate created CALCITE-6501:
-----------------------------

             Summary: Assertion Error in JoinUnifyRule Due to Type Mismatch
                 Key: CALCITE-6501
                 URL: https://issues.apache.org/jira/browse/CALCITE-6501
             Project: Calcite
          Issue Type: Bug
          Components: core
            Reporter: kate


In some cases, there is an assertion failure during the unifyRule rewriting process due to a type mismatch. If we can't rewrite it, we'd better return null instead of assert.

example：
{code:java}
@Test
public void testJoinOnCalcToJoin3011()
{
  String mv = ""
      + "select \"emps\".\"empid\", \"emps\".\"deptno\", \"depts\".\"deptno\" from\n"
      + "\"emps\" right join \"depts\"\n"
      + "on \"emps\".\"deptno\" = \"depts\".\"deptno\"";
  String query = ""
      + "select \"A\".\"empid\", \"A\".\"a\", \"A\".\"deptno\", \"depts\".\"deptno\" from\n"
      + " (select \"empid\", \"deptno\", \"deptno\" \"a\" from \"emps\") A"
      + " right join \"depts\"\n"
      + "on \"A\".\"deptno\" = \"depts\".\"deptno\"";
  sql(mv, query).noMat();
} {code}
Trace:
{code:java}
type mismatch:type1:JavaType(int) NOT NULLtype2:JavaType(class java.lang.Integer)java.lang.AssertionError: type mismatch:type1:JavaType(int) NOT NULLtype2:JavaType(class java.lang.Integer) at org.apache.calcite.util.Litmus.lambda$static$0(Litmus.java:31) at org.apache.calcite.plan.RelOptUtil.eq(RelOptUtil.java:2204) at org.apache.calcite.rex.RexProgramBuilder$RegisterInputShuttle.visitInputRef(RexProgramBuilder.java:949) at org.apache.calcite.rex.RexProgramBuilder$RegisterInputShuttle.visitInputRef(RexProgramBuilder.java:927) at org.apache.calcite.rex.RexInputRef.accept(RexInputRef.java:125) at org.apache.calcite.rex.RexProgramBuilder.registerInput(RexProgramBuilder.java:303) at org.apache.calcite.rex.RexProgramBuilder.addProject(RexProgramBuilder.java:213) at org.apache.calcite.rex.RexProgram.create(RexProgram.java:235) at org.apache.calcite.rex.RexProgram.create(RexProgram.java:204) at org.apache.calcite.plan.SubstitutionVisitor$JoinOnLeftCalcToJoinUnifyRule.apply(SubstitutionVisitor.java:1265) at org.apache.calcite.plan.SubstitutionVisitor.go(SubstitutionVisitor.java:589) at org.apache.calcite.plan.SubstitutionVisitor.go(SubstitutionVisitor.java:523) at org.apache.calcite.test.MaterializedViewSubstitutionVisitorTest$1.optimize(MaterializedViewSubstitutionVisitorTest.java:88) at org.apache.calcite.test.MaterializedViewTester.checkNoMaterialize(MaterializedViewTester.java:94) at org.apache.calcite.test.MaterializedViewFixture.noMat(MaterializedViewFixture.java:60) at {code}
 

 

 
 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)