model-writtenrun 7418 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Bas Poot reported a PostgreSQL 13 JSONB query failure whose occurrence depended on column selection, ordering, and row count, and supplied a reproducible example in #1.
- Dmitry Dolgov reproduced the failure and traced it to mismatched target-list and tuple-column ordering in #2 and #3; he subsequently found that disabling GatherMerge projection capability avoided the failure, but questioned whether that was an appropriate fix in #4.
- After the issue remained reproducible in May, Justin Pryzby identified it as an older bug affecting stable branches, and Dmitry moved its tracking entry accordingly in #5, #7, and #8.
- Tom Lane identified stacked ProjectionPaths as the cause of an invalid Sort output layout in #10; after a narrower fix exposed other occurrences during regression testing, he posted a general fix that strips an existing ProjectionPath in create_projection_path.
- Tom added a compact select_parallel regression test and clarified the implementation comment in #11, explaining that the test reproduced the failure only from PostgreSQL 13 onward although older branches likely shared the underlying defect.
- Dmitry expressed agreement in #12, but supplied no specific code findings or patch-testing results sufficient for a suggested reviewer credit.
- Tom committed #11 as 6ee41a301e with one additional defensive assertion and backported the fix through PostgreSQL 11, omitting the ineffective regression test on versions 11 and 12; his closing message #13 confirmed completion and explained that his search for a reproducer on those older branches was unsuccessful.