first_value/last_value/nth_value return NULL with EXCLUDE TIES when the current row is outside its f

Edit
ID 7412
Title first_value/last_value/nth_value return NULL with EXCLUDE TIES when the current row is outside its f
CI (CFBot) Summary
Stats (from CFBot) Patch version: v3, Patch count: 1, First patch: +72−11, All patches: +72−11
Tags Bugfix
Created 2026-10-08 10:50:14
Last modified 2026-10-08 10:50:14 (54 minutes ago)
Latest email 2026-10-07 00:53:52 (yesterday)
Status
PG20-3 (2026-11-01 – 2026-11-30): Needs review
Target version
Authors Andrey Rachitskiy (a.rachitskiy)
Reviewers Become reviewer
Committer
Links
Emails
BUG #19732: first_value/last_value/nth_value return NULL with EXCLUDE TIES when the current row is outside its f
First at 2026-09-30 03:34:33 by PG Bug reporting form <noreply at postgresql.org>
Latest at 2026-10-07 00:53:52 by shihao zhong <zhong950419 at gmail.com>
Latest attachment (v3-0001-Fix-first_value-nth_value-and-last_value-with-EXC.patch) at 2026-10-05 11:20:28 from Andrey Rachitskiy <pl0h0yp1 at gmail.com>
    Attachment (v3-0001-Fix-first_value-nth_value-and-last_value-with-EXC.patch) at 2026-10-05 11:20:28 from Andrey Rachitskiy <pl0h0yp1 at gmail.com> (Patch: No)
    Attachment (v2-0001-Fix-first_value-nth_value-and-last_value-with-EXC.patch) at 2026-09-30 14:33:58 from Andrey Rachitskiy <pl0h0yp1 at gmail.com> (Patch: No)
    Attachment (0001-Fix-first_value-nth_value-and-last_value-with-EXCLUD.patch) at 2026-09-30 13:25:32 from Andrey Rachitskiy <pl0h0yp1 at gmail.com> (Patch: No)
History
When Who What
2026-10-08 10:50:14 Andrey Rachitskiy (a.rachitskiy) Attached mail thread 19732-d4eed889e3021ef8@postgresql.org
2026-10-08 10:50:14 Andrey Rachitskiy (a.rachitskiy) Created patch record
Edit