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)
