| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | pgsql: Fix STRICT check for strict aggregates with NULL ORDER BY column |
| Date: | 2018-11-03 21:49:13 |
| Message-ID: | E1gJ3n7-0001Ef-Ru@gemulon.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
Fix STRICT check for strict aggregates with NULL ORDER BY columns.
I (Andres) broke this unintentionally in 69c3936a14, by checking
strictness for all input expressions computed for an aggregate, rather
than just the input for the aggregate transition function.
Reported-By: Ondřej Bouda
Bisected-By: Tom Lane
Diagnosed-By: Andrew Gierth
Discussion: https://postgr.es/m/2a505161-2727-2473-7c46-591ed108ac52@email.cz
Backpatch: 11-, like 69c3936a14
Branch
------
REL_11_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/fd59b29c873915064f7af6a33c968c97e0d59166
Modified Files
--------------
src/backend/executor/execExpr.c | 2 +-
src/test/regress/expected/aggregates.out | 15 +++++++++++++++
src/test/regress/sql/aggregates.sql | 7 +++++++
3 files changed, 23 insertions(+), 1 deletion(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2018-11-03 23:08:24 | pgsql: Prevent generating EEOP_AGG_STRICT_INPUT_CHECK operations when n |
| Previous Message | Andres Freund | 2018-11-03 21:49:12 | pgsql: Fix STRICT check for strict aggregates with NULL ORDER BY column |