| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| To: | pgsql-committers(at)postgresql(dot)org |
| Subject: | pgsql: Recognize GROUPING() as a aggregate expression. |
| Date: | 2015-07-26 15:12:37 |
| Message-ID: | E1ZJNbR-0004O5-EI@gemulon.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
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(at)mail(dot)gmail(dot)com
Backpatch: 9.5, where grouping sets were introduced
Branch
------
master
Details
-------
http://git.postgresql.org/pg/commitdiff/e6d8cb77c029b8122607e3d2eb1f3fca36d7b1db
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(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2015-07-26 15:12:40 | pgsql: Allow to push down clauses from HAVING to WHERE when grouping se |
| Previous Message | Heikki Linnakangas | 2015-07-26 07:49:37 | Re: pgsql: Replace our hacked version of ax_pthread.m4 with latest upstream |