projects / users / c2main / postgres.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 144666f) | patch
Recognize GROUPING() as a aggregate expression.
authorAndres Freund <andres@anarazel.de>
Sun, 26 Jul 2015 13:34:29 +0000 (15:34 +0200)
committerAndres Freund <andres@anarazel.de>
Sun, 26 Jul 2015 14:50:02 +0000 (16:50 +0200)
commite6d8cb77c029b8122607e3d2eb1f3fca36d7b1db
tree43703fec3d5d2275451a929c347173561ef59002tree
parent144666f65b500fef864bca318f6245b03c0f457ccommit | diff
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=WG9omG5rFOMAYBweJxmpTaapvVp5pCeMrE6BfpCwr4Og@mail.gmail.com
Backpatch: 9.5, where grouping sets were introduced
src/backend/optimizer/util/clauses.c diff | blob | blame | history
src/test/regress/expected/groupingsets.out diff | blob | blame | history
src/test/regress/sql/groupingsets.sql diff | blob | blame | history
Cedric's Stuff