Details
-
New Feature
-
Status: Closed
-
Minor
-
Resolution: Fixed
-
None
-
None
-
None
-
None
Description
group by rollup can accumulate rollup data and return it when a group
or a member of a group changes.
For ex:
select a,b,sum(c) from t group by rollup (a,b)
will return an extra row when group 'a' changes or when all groups
are returned. Change is detected from left to right of the specified
groups in the rollup clause. Grouping columns to the right of the
changed group are returned as NULL values.
Rollup grouping is equivalent to:
select a,b,sum(c) from t group by (a,b) union all
select, a, null, sum(c) from t group by (a) union all
select null, null, sum(c) from t;
Attachments
Issue Links
- links to