Nov 2025

1 commit
Don't allow CTEs to determine semantic levels of aggregates.
18 Nov 2025Tom Lanemaster19beta1REL_19_STABLE19beta1REL_18_STABLE18.2REL_17_STABLE17.8REL_16_STABLE16.12REL_15_STABLE15.16REL_14_STABLE14.21
LLM analysis, 99% surelanded as postedfrom patchset #140 of 1 reviewer saw the final version

The parser changes and regression SQL match #14; differences in src/test/regress/expected/with.out reflect the base version's EXPLAIN notation, using numbered InitPlans instead of expr labels. Tom Lane explicitly confirmed pushing the second patch #15.

  • Richard Guosaw an earlier versionLLM analysis, 100% sureRichard tested the first patch and demonstrated inconsistent results between equivalent CTE and subquery formulations #11 #13, prompting the substantial redesign in #14.

Credits across 1 commit

Author
Tom Lane1
Reported by
Kamil Monicz1
Committer
Tom Lane1