model-writtenrun 6140 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Venu Kummari reported that constant-input correlation and regression results differed between serial and partial aggregation because combine-stage correction terms introduced roundoff error #1, then supplied a patch that skipped those terms for known constant inputs and tested partitionwise aggregation #2.
- Tom Lane identified missing Inf/NaN handling and requested clearer explanations #3; Venu's revision forced Sxy to NaN when necessary and expanded regression coverage while retaining the constant-input approach #4.
- Tom supplied a revision that aligned combine-stage overflow handling with float8_regr_accum(), retaining defensive NaN conversions even where they appeared unreachable, and suggested improving direct combine tests to cover overflow #5.
- Venu accepted the overflow revision, corrected inconsistent common-value fields in the existing direct test to preserve coverage of nonconstant inputs, and added finite-overflow and infinite-input cases; the resulting patch passed make check with assertions enabled #6.
- Tom accepted the final patch and announced it pushed #7; ef1b740441 landed from #6 with only comment and commit-message edits, with backpatching through PostgreSQL 19 and no outstanding work identified in the thread.