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

git projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 0951942) | patch
Calculate agglevelsup correctly when Aggref contains a CTE.
2025年9月17日 20:32:57 +0000 (16:32 -0400)
2025年9月17日 20:32:57 +0000 (16:32 -0400)
commit b0cc0a71e0a0a760f54c72edb8cd000e4555442b
Calculate agglevelsup correctly when Aggref contains a CTE.

If an aggregate function call contains a sub-select that has
an RTE referencing a CTE outside the aggregate, we must treat
that reference like a Var referencing the CTE's query level
for purposes of determining the aggregate's level. Otherwise
we might reach the nonsensical conclusion that the aggregate
should be evaluated at some query level higher than the CTE,
ending in a planner error or a broken plan tree that causes
executor failures.

Bug: #19055
Reported-by: BugForge <dllggyx@outlook.com>
Author: Tom Lane <tgl@sss.pgh.pa.us>
Discussion: https://postgr.es/m/19055-6970cfa8556a394d@postgresql.org
Backpatch-through: 13
src/backend/parser/parse_agg.c diff | blob | blame | history
src/test/regress/expected/with.out diff | blob | blame | history
src/test/regress/sql/with.sql diff | blob | blame | history
This is the main PostgreSQL git repository.
RSS Atom

AltStyle によって変換されたページ (->オリジナル) /