[
https://issues.apache.org/jira/browse/CALCITE-2047?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Hyde updated CALCITE-2047:
---------------------------------
Summary: AggregateReduceFunctionsRule throws "Type mismatch" AssertionError
(was: java.lang.AssertionError: Type mismatch)
> AggregateReduceFunctionsRule throws "Type mismatch" AssertionError
> ------------------------------------------------------------------
>
> Key: CALCITE-2047
> URL: https://issues.apache.org/jira/browse/CALCITE-2047
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.13.0
> Reporter: HULING
> Assignee: Julian Hyde
>
> SQL :
> select sum(ss_list_price) SM ,count(ss_list_price) NT,count(distinct
> ss_list_price) DNT
> from store_sales
> The type of 'salary' is double
> An exception occurs when the following rules are used:
> AggregateExpandDistinctAggregatesRule.JOIN
> AggregateReduceFunctionsRule.INSTANCE
>
> java.lang.AssertionError: Type mismatch:
> rowtype of new rel:
> RecordType(BIGINT SM, BIGINT NOT NULL NT, BIGINT NOT NULL DNT) NOT NULL
> rowtype of set:
> RecordType(DOUBLE SM, BIGINT NOT NULL NT, BIGINT NOT NULL DNT) NOT NULL
> at org.apache.calcite.util.Litmus$1.fail(Litmus.java:31)
> at org.apache.calcite.plan.RelOptUtil.equal(RelOptUtil.java:1873)
> at org.apache.calcite.plan.volcano.RelSubset.add(RelSubset.java:271)
> at org.apache.calcite.plan.volcano.RelSet.add(RelSet.java:85)
> at
> org.apache.calcite.plan.volcano.VolcanoPlanner.addRelToSet(VolcanoPlanner.java:1645)
> at
> org.apache.calcite.plan.volcano.VolcanoPlanner.registerImpl(VolcanoPlanner.java:1591)
> at
> org.apache.calcite.plan.volcano.VolcanoPlanner.register(VolcanoPlanner.java:863)
> at
> org.apache.calcite.plan.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:883)
> at
> org.apache.calcite.plan.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:1767)
> at
> org.apache.calcite.plan.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:135)
> at
> org.apache.calcite.plan.RelOptRuleCall.transformTo(RelOptRuleCall.java:234)
> at
> org.apache.calcite.rel.rules.AggregateReduceFunctionsRule.reduceAggs(AggregateReduceFunctionsRule.java:181)
> at
> org.apache.calcite.rel.rules.AggregateReduceFunctionsRule.onMatch(AggregateReduceFunctionsRule.java:110)
> at
> org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:212)
> at
> org.apache.calcite.plan.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:650)
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
