Jul 2021

2 commits
Support for unnest(multirange)
18 Jul 2021Alexander Korotkovmaster15beta1REL_19_STABLE15beta1REL_18_STABLE15beta1REL_17_STABLE15beta1REL_16_STABLE15beta1REL_15_STABLE15beta1REL_14_STABLE14beta3
LLM analysis, 100% surelanded as postedfrom patchset #495 of 5 reviewers saw the final version

The implementation, pg_proc.dat entry, documentation, and regression tests match #49; differences are rebased context and removal of an added blank line. The push to master and PostgreSQL 14 is confirmed in #65.

  • Justin Pryzbysaw the final versiontrailerJustin corrected the unnest catalog typo in #10, tested the combined patch in #12, and reviewed terminology in #22; the retained unnest code subsequently changed only lightly.
  • Jonathan S. Katzsaw the final versiontrailerJonathan reported successful SQL, PL/pgSQL, empty-input, and custom-range tests in #15, #18, and #19, then supported the unnest-only landing in #64.
  • Zhihong Yusaw the final versiontrailerZhihong reviewed terminology and naming in #20, including the unnest function comment, and the retained unnest implementation remained unchanged.
  • Tom Lanesaw the final versiontrailerTom diagnosed the first landing's failures in #33, requested removal of casts in #45, and accepted the unnest-only addition in #62.
  • Alvaro Herrerasaw the final versiontrailerAlvaro proposed retaining only unnest in #34 and argued for shipping that reduced patch despite a required initdb in #61.
Fix small inconsistencies in catalog definition of multirange operators
15 Jul 2021Alexander Korotkovmaster15beta1REL_19_STABLE15beta1REL_18_STABLE15beta1REL_17_STABLE15beta1REL_16_STABLE15beta1REL_15_STABLE15beta1REL_14_STABLE14beta3
LLM analysis, 100% surelanded as postedfrom patchset #503 of 3 reviewers saw the final version

All three pg_operator.dat edits exactly match #50. The commit message explains the agreed decision to omit a catalog-version bump, and #60 confirms the push.

  • Alvaro Herrerasaw the final versionLLM analysis, 100% sureAlvaro recommended committing without a catalog-version bump in #51 and explicitly approved retaining the selectivity-function change in #59.
  • Justin Pryzbysaw the final versionLLM analysis, 92% sureJustin supplied precedents for avoiding a catalog-version bump in #53 and checked whether the proposed landing included the selectivity-function hunk in #57.
  • Tom Lanesaw the final versionLLM analysis, 83% sureTom accepted changing description strings without a catalog-version bump in #54, although his stated assessment did not cover the selectivity-function hunk.

Jun 2021

2 commits
Revert 29854ee8d1 due to buildfarm failures
15 Jun 2021Alexander Korotkovmaster14beta2REL_19_STABLE14beta2REL_18_STABLE14beta2REL_17_STABLE14beta2REL_16_STABLE14beta2REL_15_STABLE14beta2REL_14_STABLE14beta2revert
LLM analysis, 100% surewritten from the discussion, no matching patch0 of 1 reviewer saw the final version

The diff reverses the combined unnest-and-casts landing, including its catalog-version bump, without a matching attached revert patch. Tom requested a revert after dump/upgrade failures in #33 and #35, and Alexander confirmed it in #38.

  • Tom Lanesaw an earlier versionLLM analysis, 98% sureTom reported buildfarm failures in #31, identified dump/upgrade failures and requested reversion in #33, reviewing the earlier combined patch rather than the thread's final catalog-cleanup patchset.
Support for unnest(multirange) and cast multirange as an array of ranges
15 Jun 2021Alexander Korotkovmaster14beta2REL_19_STABLE14beta2REL_18_STABLE14beta2REL_17_STABLE14beta2REL_16_STABLE14beta2REL_15_STABLE14beta2REL_14_STABLE14beta2
LLM analysis, 100% suremodified before commitlight changesfrom patchset #173 of 3 reviewers saw the final version

The combined unnest-and-array-cast changes match #17, with an additional src/include/catalog/catversion.h bump and rebased context. Alexander announced the initial push in #30.

  • Justin Pryzbysaw the final versiontrailerJustin found the catalog typo in #10 and empty-cast crash in #12, then reviewed the corrected patch's terminology in #22.
  • Jonathan S. Katzsaw the final versiontrailerJonathan tested SQL and PL/pgSQL cases in #15, exercised additional and custom-range cases in #18 and #19, and considered the patch ready in #28.
  • Zhihong Yusaw the final versiontrailerZhihong reviewed documentation terminology, variable naming, and the unnest function comment in #20.

Credits across 4 commits

Author
Alexander Korotkov1 LLM3
Reviewer
Jonathan S. Katz2
Justin Pryzby2
Zhihong Yu2
Alvaro Herrera1
Tom Lane1
Reported by
Jonathan S. Katz2
Tom Lane1
Committer
Alexander Korotkov4

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