[ https://issues.apache.org/jira/browse/CALCITE-3266?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Water Cut Off closed CALCITE-3266. ---------------------------------- Resolution: Not A Bug > Type mismatch when test sql “select distinct deptno from dept” > -------------------------------------------------------------- > > Key: CALCITE-3266 > URL: https://issues.apache.org/jira/browse/CALCITE-3266 > Project: Calcite > Issue Type: Bug > Reporter: Water Cut Off > Priority: Major > Attachments: image-2019-08-19-20-53-57-276.png, > image-2019-08-19-20-54-21-347.png > > > h2. *Hi, I don't understand why this happens like this, can someone tell me > how to solve this and why,thanks a lot.* > > Exception in thread "main" java.lang.AssertionError: Type mismatch:Exception > in thread "main" {color:#FF0000}java.lang.AssertionError: Type > mismatch:rowtype of new rel:RecordType(INTEGER NOT NULL DEPTNO, BOOLEAN NOT > NULL i$DEPTNO) NOT NULLrowtype of set:RecordType(INTEGER NOT NULL DEPTNO) NOT > NULL{color} at org.apache.calcite.util.Litmus$1.fail(Litmus.java:31) at > org.apache.calcite.plan.RelOptUtil.equal(RelOptUtil.java:1858) at > org.apache.calcite.plan.volcano.RelSubset.add(RelSubset.java:284) at > org.apache.calcite.plan.volcano.RelSet.add(RelSet.java:148) at > org.apache.calcite.plan.volcano.VolcanoPlanner.addRelToSet(VolcanoPlanner.java:1837) > at > org.apache.calcite.plan.volcano.VolcanoPlanner.registerImpl(VolcanoPlanner.java:1783) > at > org.apache.calcite.plan.volcano.VolcanoPlanner.register(VolcanoPlanner.java:850) > at > org.apache.calcite.plan.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:872) > at > org.apache.calcite.plan.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:1958) > at > org.apache.calcite.plan.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:126) > at > org.apache.calcite.plan.RelOptRuleCall.transformTo(RelOptRuleCall.java:234) > at > org.apache.calcite.rel.convert.ConverterRule.onMatch(ConverterRule.java:141) > at > org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:205) > at > org.apache.calcite.plan.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:637) > at calcite.CalciteTest.sqlToRelNode(CalciteTest.java:103) at > calcite.CalciteTest.main(CalciteTest.java:53) -- This message was sent by Atlassian Jira (v8.3.2#803003)