[CALCITE-4664] When group by is same as sub-query, grouping sets are missing

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Component/s: core
• Assignee: Unassigned
• Reporter: Jiajun Xie
• Created: 24/Jun/21 00:21
• Updated: 30/Jun/21 07:38
• Resolved: 24/Jun/21 01:48

Description

For example:

SELECT
t.ID, t.NAME, count(t.AGE) T_AGE
FROM
(SELECT u.ID, u.NAME, u.AGE
FROM USERS u
GROUP BY u.ID, u.NAME, u.AGE
) t
GROUP BY t.ID, t.NAME, t.AGE
GROUPING SETS(
(t.ID, t.NAME),
(t.ID, t.NAME, t.AGE)
)

will be

SELECT u.ID, u.NAME, u.AGE
FROM USERS u
GROUP BY u.ID, u.NAME, u.AGE

groupings set is missing
 

Issue Links

• duplicates: CALCITE-4665 Allow Aggregate.groupSet to contain columns not in any of the groupSets