model-writtenrun 8506 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Rushabh Lathia proposed ORDER BY ALL with shared ASC/DESC and NULLS modifiers in #1, using a parser marker expanded across all non-junk output columns and retaining flags to reproduce the syntax in view definitions.
- Kirill Reshke questioned SQL-standard compatibility in #2, which Rushabh acknowledged in #3; Peter Eisentraut clarified in #4 that the SQL working group had declined to standardize ORDER BY ALL, removing concern about a conflicting standardized interpretation.
- After several months, Peter supported pursuing the feature in #5 but requested a combined patch, tests in existing regression files, corrected PL/pgSQL expected output, and proper handling of aggregate, window and WITHIN GROUP uses that currently produced internal errors or crashes.
- Rushabh addressed that review in #7, consolidating code, documentation and tests, simplifying marker detection, and choosing explicit rejection inside aggregates and windows because those contexts have no equivalent of the query output list.
- Zsolt Parragi questioned the shared grammar production and retained Query flag in #8, reporting an unrestorable empty-select-list WITH TIES view, unsafe deparsing after operator-class changes, missing error positions, and an inaccurate comment suggesting explicitly selected system columns were excluded.
- Rushabh's revision in #9 removed the Query flag and special deparsing in favor of explicit sort lists, addressing the operator-class concern, and fixed error positions with additional regression tests; he retained the shared grammar to provide clearer misuse errors while remaining open to a separate query-level production.
- The thread ends with the patch still under review in #9, with no linked commit and the empty-select-list WITH TIES behavior explicitly unresolved between preserving enough information for deparsing and rejecting the combination; the disputed system-column comment also remains in the attached patch.