model-writtenrun 1531 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Marian MULLER REBEYROL reported that grouping sets referencing unnest() output failed with “variable not found in subplan target list” after upgrading to PostgreSQL 18, with a reproducer also failing on development HEAD #1.
- Tom Lane bisected the regression to the change marking expressions nullable by grouping sets #2, and Tender Wang traced the failure to SRF target splitting exposing an argument absent from the subplan output #3.
- Richard Guo submitted a fix that ignores the grouping nulling bit when matching expressions across the grouping boundary, using a private workhorse and public wrappers while adding regression coverage #4.
- Tender Wang agreed with the nulling-bit diagnosis and reported that the patch worked and all regression tests passed #5.
- Richard sought confirmation that the existing API wrapper, new exported function, and private structure changes were safe for backpatching #6; Tender endorsed the wrapper and private structure changes and suggested documenting the structure's private status #7.
- Richard resolved his remaining concern about new exported functions after a Discord discussion and announced the fix had been pushed and backpatched to PostgreSQL 18 #8; 325808cac9 landed the submitted patch with only comment edits and more detailed EXPLAIN regression output.
- Marian confirmed that the fix resolved the actual business use case, leaving the thread with the fix committed and backpatched and no outstanding work identified #9.