[jira] [Created] (CALCITE-6834) In query that applies COALESCE to nullable SUM, EnumerableProjectToCalcRule throws AssertionError

[Julian Hyde (Jira)]

Julian Hyde created CALCITE-6834:
------------------------------------

             Summary: In query that applies COALESCE to nullable SUM, 
EnumerableProjectToCalcRule throws AssertionError
                 Key: CALCITE-6834
                 URL: https://issues.apache.org/jira/browse/CALCITE-6834
             Project: Calcite
          Issue Type: Bug
            Reporter: Julian Hyde


In a query that applies COALESCE to nullable SUM, EnumerableProjectToCalcRule 
throws AssertionError. Query:
{code}
{code}
Stack trace:
{code}
java.lang.AssertionError: Cannot add expression of different type to set:
set type is RecordType(INTEGER NOT NULL $f0) NOT NULL
expression type is RecordType(SMALLINT NOT NULL $f0) NOT NULL
set is 
rel#5531:EnumerableProject.ENUMERABLE.[](input=HepRelVertex#5530,inputs=0)
expression is EnumerableCalc(expr#0=[{inputs}], $f0=[$t0])
  EnumerableAggregate(group=[{}], agg#0=[$SUM0($3)])
    EnumerableTableScan(table=[[scott, EMP]])
Type mismatch:
rowtype of original rel: RecordType(INTEGER NOT NULL $f0) NOT NULL
rowtype of new rel: RecordType(SMALLINT NOT NULL $f0) NOT NULL
Difference:
$f0: INTEGER NOT NULL -> SMALLINT NOT NULL

        at 
org.apache.calcite.plan.RelOptUtil.verifyTypeEquivalence(RelOptUtil.java:433)
        at 
org.apache.calcite.plan.hep.HepRuleCall.transformTo(HepRuleCall.java:58)
        at 
org.apache.calcite.plan.RelOptRuleCall.transformTo(RelOptRuleCall.java:273)
        at 
org.apache.calcite.plan.RelOptRuleCall.transformTo(RelOptRuleCall.java:288)
        at 
org.apache.calcite.adapter.enumerable.EnumerableProjectToCalcRule.onMatch(EnumerableProjectToCalcRule.java:54)
        at 
org.apache.calcite.plan.AbstractRelOptPlanner.fireRule(AbstractRelOptPlanner.java:350)
        at org.apache.calcite.plan.hep.HepPlanner.applyRule(HepPlanner.java:556)
{code}

Here is a patch to reproduce:
{noformat}
diff --git a/core/src/test/resources/sql/agg.iq 
b/core/src/test/resources/sql/agg.iq
index 7322b84da..26b2a4b5c 100644
--- a/core/src/test/resources/sql/agg.iq
+++ b/core/src/test/resources/sql/agg.iq
@@ -723,6 +723,17 @@ group by deptno;
 
 !use scott
 
+select coalesce(sum(mgr), 0) as m
+from emp;
++--------+
+|    M   |
++--------+
+| 100611 |
++--------+
+(1 row)
+
+!ok
+
 # GROUPING in SELECT clause of CUBE query
{noformat}




--
This message was sent by Atlassian Jira
(v8.20.10#820010)