Horton

Fix STRICT check for strict aggregates with NULL ORDER BY columns.

Andres Freund <andres@anarazel.de>

View on postgr.es
Commit: 4c640f4f38d5d68cbe33ddfabbdc56eea8f1e173
Author: Andres Freund <andres@anarazel.de>
Date: 2018-11-03T21:48:42Z
Releases: 12.0 
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

Files

PathChange+/−
src/backend/executor/execExpr.c modified +1 −1
src/test/regress/expected/aggregates.out modified +15 −0
src/test/regress/sql/aggregates.sql modified +7 −0

Discussion