Recognize GROUPING() as a aggregate expression. Previously GROUPING() was not recognized as a aggregate expression, erroneously allowing the planner to move it from HAVING to WHERE.
Author: Jeevan Chalke Reviewed-By: Andrew Gierth Discussion: CAM2+6=wg9omg5rfomaybwejxmptaapvvp5pcemre6bfpcwr...@mail.gmail.com Backpatch: 9.5, where grouping sets were introduced Branch ------ REL9_5_STABLE Details ------- http://git.postgresql.org/pg/commitdiff/3500d1cc78f61927e05c0e73158b87ff24f81c09 Modified Files -------------- src/backend/optimizer/util/clauses.c | 7 +++- src/test/regress/expected/groupingsets.out | 62 ++++++++++++++++++++++++++++ src/test/regress/sql/groupingsets.sql | 17 ++++++++ 3 files changed, 85 insertions(+), 1 deletion(-) -- Sent via pgsql-committers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
