jingzhang created CALCITE-2105:
----------------------------------
Summary: 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: jingzhang
Assignee: Julian Hyde
{quote}select sum(sal)
"
+ "from (select * from sales.emp where empno = 10) as e\n"
+ "join sales.dept as d on e.job = d.name"
{quote}
AggregateJoinTransposeRule will broken when process the above sql, thrown
exception is
{quote}
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)
{quote}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
