[jira] [Updated] (CALCITE-2105) AggregateJoinTransposeRule fails when process aggregate without group keys

["Drew Foulks (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CALCITE-2105?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Drew Foulks updated CALCITE-2105:
---------------------------------
    Reporter: Jing Zhang  (was: Jing Zhang)

> AggregateJoinTransposeRule fails when process aggregate without group keys
> --------------------------------------------------------------------------
>
>                 Key: CALCITE-2105
>                 URL: https://issues.apache.org/jira/browse/CALCITE-2105
>             Project: Calcite
>          Issue Type: Bug
>            Reporter: Jing Zhang
>            Assignee: Julian Hyde
>            Priority: Major
>             Fix For: 1.16.0
>
>
> {code}
> select sum(sal) from (select * from sales.emp where empno = 10) as e join sales.dept as d on e.job = d.name
> {code}
> AggregateJoinTransposeRule will broken when process the above sql, thrown exception is 
> {code}
> java.lang.AssertionError: type mismatch:
> aggCall type:
> INTEGER
> inferred type:
> INTEGER NOT NULL
> 	at org.apache.calcite.util.Litmus$1.fail(Litmus.java:31)
> 	at org.apache.calcite.plan.RelOptUtil.eq(RelOptUtil.java:1838)
> 	at org.apache.calcite.rel.core.Aggregate.typeMatchesInferred(Aggregate.java:428)
> 	at org.apache.calcite.rel.core.Aggregate.<init>(Aggregate.java:161)
> 	at org.apache.calcite.rel.logical.LogicalAggregate.<init>(LogicalAggregate.java:65)
> 	at org.apache.calcite.rel.logical.LogicalAggregate.create_(LogicalAggregate.java:110)
> 	at org.apache.calcite.rel.logical.LogicalAggregate.create(LogicalAggregate.java:100)
> 	at org.apache.calcite.rel.core.RelFactories$AggregateFactoryImpl.createAggregate(RelFactories.java:213)
> 	at org.apache.calcite.tools.RelBuilder.aggregate(RelBuilder.java:1267)
> 	at org.apache.calcite.tools.RelBuilder.aggregate(RelBuilder.java:1825)
> 	at org.apache.calcite.rel.rules.AggregateJoinTransposeRule.onMatch(AggregateJoinTransposeRule.java:260)
> {code}



--
This message was sent by Atlassian Jira
(v8.20.1#820001)