Apr 2023

1 commit
Support "Right Anti Join" plan shapes.
5 Apr 2023Tom Lanemaster16beta1REL_19_STABLE16beta1REL_18_STABLE16beta1REL_17_STABLE16beta1REL_16_STABLE16beta1
LLM analysis, 99% suremodified before commitlight changesfrom patchset #232 of 4 reviewers saw the final version

The commit retains the executor, costing, reversed-path generation, and partition_join.out changes from #23, with additional comment edits in prepjointree.c and pathnodes.h. The joinpath.c restriction is relocated to accommodate upstream Parallel Hash Full Join support, consistent with Tom Lane's description of comment polishing and rebasing #24.

  • Emre Hasegelisaw an earlier versionLLM analysis, 100% sureTested the initial patch, reported failing tests, and discussed costing and planning overhead #5, before the execution fix and merge-join extension.
  • Ronan Dunklausaw an earlier versionLLM analysis, 100% sureDiagnosed the duplicate-handling bug with a reproducer #7, accepted the correction and requested test updates #9 #10, before merge-join support was added.
  • Alvaro Herrerasaw the final versionLLM analysis, 94% sureBenchmarked patched and unpatched plans and investigated costing through comparison with ordinary right joins #18 #20, after which only rebasing and comment edits followed.
  • Tom Lanesaw the final versioncommittercommitted the patch

Credits across 1 commit

Author
Richard GuoLLM1
Reviewer
Tom Lanecommitter1
Committer
Tom Lane1

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