Oct 2021

1 commit
Fix EXPLAIN of SEARCH BREADTH FIRST queries some more.
11 Oct 2021Tom Lanemaster15beta1REL_19_STABLE15beta1REL_18_STABLE15beta1REL_17_STABLE15beta1REL_16_STABLE15beta1REL_15_STABLE15beta1REL_14_STABLE14.1
LLM analysis, 100% surewritten from the discussion, no matching patch1 of 1 reviewer saw the final version

Markus Winand reported a regression in non-verbose EXPLAIN #13, and Tom Lane acknowledged the oversight #16. The commit fixes it by assigning dpns->ancestors before calling set_deparse_plan in src/backend/utils/adt/ruleutils.c; neither attachment contains this correction.

  • Markus Winandsaw the final versionLLM analysis, 94% sureMarkus supplied a reproducer showing that the landed version of #7 broke non-verbose EXPLAIN and isolated the introducing commit before the follow-up fix #13 #15.

Sep 2021

1 commit
Fix EXPLAIN to handle SEARCH BREADTH FIRST queries.
16 Sep 2021Tom Lanemaster15beta1REL_19_STABLE15beta1REL_18_STABLE15beta1REL_17_STABLE15beta1REL_16_STABLE15beta1REL_15_STABLE15beta1REL_14_STABLE14rc1
LLM analysis, 100% suremodified before commitlight changesfrom patchset #71 of 1 reviewer saw the final version

The ruleutils.c changes exactly match #7. The commit additionally supplies EXPLAIN regression cases for depth-first search, breadth-first search, and CYCLE in src/test/regress/sql/with.sql and its expected output.

  • Andrew Dunstansaw the final versionLLM analysis, 100% sureAndrew called the replacement patch a nice simple fix before it was committed #8, and only regression tests were added afterward.

Credits across 2 commits

Author
Tom LaneLLM1
Committer
Tom Lane2

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