Nov 2026

1 commit
Fix SEARCH/CYCLE when the recursive term has resjunk columns.
20 Nov 2026Tom LanemasterunreleasedREL_19_STABLEunreleasedREL_18_STABLEunreleasedREL_17_STABLEunreleasedREL_16_STABLEunreleasedREL_15_STABLEunreleased
LLM analysis, 100% suremodified before commitmoderate changesfrom patchset #31 of 1 reviewer saw the final version

d27418375d retains the detach/add/renumber approach from #3, but replaces positional targetlist splitting with explicit resjunk checks and an assertion in src/backend/rewrite/rewriteSearchCycle.c. It also expands comments and removes the fourth regression case from with.sql and with.out; Tom Lane confirms the logic rewrite in #4.

  • Tom Lanesaw the final versiontrailerTom Lane reviewed and committed the patch, explaining in #4 that he replaced its column-count assumption with explicit resjunk checks and a validating assertion.

Credits across 1 commit

Author
Nitin Motiani1
Reviewer
Tom Lane1
Reported by
Robins Tharakan1
Committer
Tom Lane1