model-writtenrun 7251 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Alvaro Herrera reported a sqlsmith-generated MERGE query failing with “variable not found in subplan target list” in #1; Tom Lane reproduced it on development and PostgreSQL 15, ruling out the SQL/JSON patch under test in #2.
- Tom reduced the query in #3 and traced the failure to a partitioned target with no remaining partitions: its dummy scan lacked the ctid needed by the parent join, as explained in #4.
- Tom supplied #5, making distribute_row_identity_vars() rebuild the relation's target list; 326a33a289 landed that fix with regression tests, while its commit explanation ruled out a PostgreSQL 14 backpatch because the failure required MERGE.
- After the MERGE fix had landed, Alvaro confirmed that it resolved his other target-list failures and reported three additional errors in #6; that confirmation came too late to qualify as a pre-commit review.
- Tom reproduced the PartitionPruneInfo mismatch, could not reproduce the parallel-worker InitPlan failure, and attributed the operator-related error to intentionally broken regression-test operator-class state in #7; the thread records no subsequent resolution of the latter two reports.
- Amit Langote supplied the independent pruning fix in #8, transferring pruning entries individually while assigning their global indexes, and also questioned whether the entire indexing infrastructure remained necessary after its motivating project changed direction.
- Alvaro queued Amit's patch for CI in #9 and committed it as 589bb81649, changing only the helper's name, argument order, and explanatory comment.
- Alvaro returned to the removal proposal in #10, explaining that reverting the infrastructure and its fixup required only minor formatting-conflict cleanup and another catalog-version bump, preferably before beta.
- The discussion produced 5472743d9e, which restored pruning information to plan nodes and removed the now-unnecessary infrastructure together with its fixup; Alvaro announced completion in #11, and Amit acknowledged it in #12, leaving the MERGE fix landed and the pruning changes reverted.