model-writtenrun 8808 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Mahadevan Ramachandran reported that EXPLAIN could emit a "Subplans Removed" property directly inside the JSON Plans array, producing invalid JSON, after spotting the problem in the code #1.
- Daniel Gustafsson reproduced the problem using partition-pruning queries and proposed wrapping the property in its own Plan group #2; Hamid Akhtar then tested the patch and verified corrected JSON, XML, and YAML output without changing text output #3.
- Tom Lane replaced that approach with a parent-node property and required a zero value in non-text formats to keep their schema consistent; he also supplied experimental auto_explain validation code, explicitly unsuitable for production because of its overhead #4.
- Daniel Gustafsson raised concerns about backpatching the resulting text-field reordering #5, and Tom Lane considered using different fixes on stable branches but favored consistent, valid structured output #6.
- hubert depesz lubaczewski reported that Pg::Explain needed an easily achievable adjustment for the new JSON output #7; Daniel Gustafsson leaned toward backpatching #8, and Tom Lane proposed proceeding absent objections #9.
- Tom Lane extended the experimental validator to detect duplicate keys through jsonb_in, found no additional problems in his testing, and posted it for archival use rather than commitment #10.
- The production fix from #4 landed unchanged as 7d91b604d9, with backpatches to PostgreSQL 11 and 12; Tom Lane confirmed completion in #11, leaving only the intentionally uncommittable validation experiments out.