pgsql: Build column mapping for grouping sets in all required cases.

Started by Andres Freundalmost 11 years ago1 messagescomitters

andres@anarazel.de

almost 11 years ago

Build column mapping for grouping sets in all required cases.

The previous coding frequently failed to fail because for one it's
unusual to have rollup clauses with one column, and for another
sometimes the wrong mapping didn't cause obvious problems.

Author: Jeevan Chalke
Reviewed-By: Andrew Gierth
Discussion: CAM2+6=W=9=hQOipH0HAPbkun3Z3TFWij_EiHue0_6UX=oR=1kw@mail.gmail.com
Backpatch: 9.5, where grouping sets were introduced

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/144666f65b500fef864bca318f6245b03c0f457c

Modified Files
--------------
src/backend/optimizer/plan/planner.c | 9 ++-------
src/test/regress/expected/groupingsets.out | 23 +++++++++++++++++++++++
src/test/regress/sql/groupingsets.sql | 4 ++++
3 files changed, 29 insertions(+), 7 deletions(-)

--
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers