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

Reply via email to