]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Fix to not allow null treatment to non window functions.
authorTatsuo Ishii <ishii@postgresql.org>
Wed, 17 Jun 2026 01:12:07 +0000 (10:12 +0900)
committerTatsuo Ishii <ishii@postgresql.org>
Wed, 17 Jun 2026 01:12:07 +0000 (10:12 +0900)
commit4e5920e6de87dc1ed761d2a898b7786c50c11db2
tree3adbf497fa90dc65af533cc49c9dc71c05d44aa9
parent9285737ac3cf868f623631b087687cab260a9de4
Fix to not allow null treatment to non window functions.

The null treatment clause (RESPECT NULLS/IGNORE NULLS) are only
allowed to window functions per spec. Previously the check was only
applied to aggregates in window clause. Other types of functions were
allowed to use the clause, which was plain wrong.

To fix this, ParseFuncOrColumn() now checks whether other than window
functions are used with the null treatment clause. If so, error out.

Also remove the unnecessary test for "aggregate functions do not
accept RESPECT/IGNORE NULLS" because it is now checked in the
early-stage new check. The window regression test expected file is
changed accordingly.

Reported-by: jian he <jian.universality@gmail.com>
Reviewed-by: jian he <jian.universality@gmail.com>
Author: Tatsuo Ishii <ishii@postgresql.org>
Discussion: https://postgr.es/m/CACJufxFnm%2BAj2Jyhyd58PtW8e1vTZDKimkZE%2BMashCPSDKw56Q%40mail.gmail.com
src/backend/parser/parse_func.c
src/test/regress/expected/window.out