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: v3, Patch count: 1, First patch: +247−66, All patches: +247−66
Topic Bug Fixes
Tags
Created 2025-12-03 22:56:13
Last modified 2025-12-06 23:32:39 (5 days ago)
Latest email 2025-12-06 22:53:38 (5 days ago)
Status
PG19-4 (2026-01-01 – 2026-01-31): Committed
Target version
Authors Tom Lane (tgl)
Reviewers Become reviewer
Committer Tom Lane (tgl)
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-06 23:32:12 by Tom Lane <tgl at sss.pgh.pa.us>
Latest attachment (v3-0001-Handle-constant-inputs-to-corr-and-related-aggreg.patch) at 2025-12-06 18:18:43 from Tom Lane <tgl at sss.pgh.pa.us>
    Attachment (v3-0001-Handle-constant-inputs-to-corr-and-related-aggreg.patch) at 2025-12-06 18:18:43 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (v2-detect-constant-input-exactly.patch) at 2025-12-05 22:17:33 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    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-06 23:32:39 Tom Lane (tgl) Closed in commitfest PG19-4 with status: Committed
2025-12-06 23:32:39 Tom Lane (tgl) Changed committer to tgl
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