You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Water Cut Off (Jira)" <ji...@apache.org> on 2019/08/20 11:00:09 UTC

[jira] [Closed] (CALCITE-3266) Type mismatch when test sql “select distinct deptno from dept”

     [ 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)