Mihai Budiu created CALCITE-6332:
------------------------------------
Summary: Optimization
CoreRules.AGGREGATE_EXPAND_DISTINCT_AGGREGATES_TO_JOIN produces incorrect
results for aggregates with groupSets
Key: CALCITE-6332
URL: https://issues.apache.org/jira/browse/CALCITE-6332
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.36.0
Reporter: Mihai Budiu
The optimization rule does not seem to consider the groupSets at all.
The following two queries produce the same resulting plan:
{code:sql}
select count(distinct deptno) as cd, count(*) as c
from emp
group by cube(deptno)
{code}
{code:sql}
select count(distinct deptno) as cd, count(*) as c
from emp
group by deptno
{code}
(Notice that one query has a cube, while the other one doesn't)
The produced plan is:
{code}
LogicalProject(CD=[$1], C=[$2]), id = 196
LogicalAggregate(group=[{0}], CD=[COUNT($0)], C=[$SUM0($1)]), id = 201
LogicalAggregate(group=[{0}], C=[COUNT()]), id = 198
LogicalProject(DEPTNO=[$8]), id = 192
LogicalTableScan(table=[[schema, EMP]]), id = 163
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
