git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit

Recognize GROUPING() as a aggregate expression.

author Andres Freund <andres@anarazel.de>

2015年7月26日 13:34:29 +0000 (15:34 +0200)

committer Andres Freund <andres@anarazel.de>

2015年7月26日 14:50:02 +0000 (16:50 +0200)

commit e6d8cb77c029b8122607e3d2eb1f3fca36d7b1db

tree 43703fec3d5d2275451a929c347173561ef59002 tree

parent 144666f65b500fef864bca318f6245b03c0f457c commit | 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

This is the main PostgreSQL git repository.

RSS Atom