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

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v4, Patch count: 1, First patch: +93−11, All patches: +93−11

Tags

Bugfix

Created

2026-10-08 10:50:14

Last modified

2026-10-28 05:48:38 (19 hours ago)

Latest email

2026-10-28 05:48:23 (19 hours ago)

Status

PG20-3 (2026-11-01 – 2026-11-30): Ready for Committer

Target version

Authors

Andrey Rachitskiy (a.rachitskiy)

Reviewers

Henson Choi (assam258.gmail.com) 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-28 05:48:23 by Henson Choi <assam258 at gmail.com>
Latest attachment (v4-0001-Fix-first_value-nth_value-and-last_value-with-EXC.patch) at 2026-10-12 15:18:52 from Andrey Rachitskiy <pl0h0yp1 at gmail.com>
    Attachment (v4-0001-Fix-first_value-nth_value-and-last_value-with-EXC.patch) at 2026-10-12 15:18:52 from Andrey Rachitskiy <pl0h0yp1 at gmail.com> (Patch: No)
    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-28 05:52:58	Henson Choi (assam258.gmail.com)	Added assam258.gmail.com as reviewer
2026-10-28 05:48:38	Henson Choi (assam258.gmail.com)	New status: Ready for Committer
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