Improve robustness of CORR() and related aggregates

Edit
ID 6278
Title Improve robustness of CORR() and related aggregates
CI (CFBot) Summary
Stats (from CFBot) Patch version: v1, Patch count: 1, First patch: +235−73, All patches: +235−73
Topic Bug Fixes
Tags
Created 2025-12-03 22:56:13
Last modified 2025-12-03 22:56:13 (49 minutes ago)
Latest email 2025-12-03 22:52:31 (53 minutes ago)
Status
PG19-4 (2026-01-01 – 2026-01-31): Needs review
Target version
Authors Tom Lane (tgl)
Reviewers Become reviewer
Committer
Links
Emails
BUG #19340: Wrong result from CORR() function
First at 2025-12-02 07:57:35 by PG Bug reporting form <noreply at postgresql.org>
Latest at 2025-12-03 22:52:31 by Tom Lane <tgl at sss.pgh.pa.us>
Latest attachment (v1-detect-constant-input-exactly.patch) at 2025-12-03 22:52:31 from Tom Lane <tgl at sss.pgh.pa.us>
    Attachment (v1-detect-constant-input-exactly.patch) at 2025-12-03 22:52:31 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (wip-detect-constant-input-exactly-2.patch) at 2025-12-03 00:17:32 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (wip-detect-constant-input-exactly.patch) at 2025-12-02 20:26:43 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
History
When Who What
2025-12-03 22:56:13 Tom Lane (tgl) Attached mail thread 19340-6fb9f6637f562092@postgresql.org
2025-12-03 22:56:13 Tom Lane (tgl) Created patch record
Edit