Dec 2022

1 commit
Allow window functions to adjust their frameOptions
22 Dec 2022David Rowleymaster16beta1REL_19_STABLE16beta1REL_18_STABLE16beta1REL_17_STABLE16beta1REL_16_STABLE16beta1Also in: Default framing option RANGE adds cost for no gain to some window functions
LLM analysis, 100% suremodified before commitlight changesfrom patchset #130 of 3 reviewers saw the final version

Compared with #13, the commit preserves the implementation, edits comments in src/backend/utils/adt/windowfuncs.c, bumps src/include/catalog/catversion.h, and adds window regression SQL and expected output. David Rowley confirms adding tests and pushing the result in #14.

  • Vik Fearingsaw an earlier versiontrailerVik justified unconditional frame replacement in #2 and demonstrated redundant WindowAgg passes in #12, prompting substantive deduplication changes in #13; his thanks in #15 came after commitment.
  • Erwin Brandstettersaw an earlier versiontrailerErwin supplied cross-database evidence supporting the frame-semantics analysis in #3, before additional function support and deduplication were implemented.
  • Zhihong Yusaw an earlier versiontrailerZhihong proposed factoring repeated frame-option flags in #5 and accepted the existing arrangement in #10, before additional function support and deduplication were implemented.

Credits across 1 commit

Author
David RowleyLLM1
Reviewer
Erwin Brandstetter1
Vik Fearing1
Zhihong Yu1
Committer
David Rowley1

N LLM means N of the credits come from LLM analysis, not from commit trailers.