Re: first_value()/nth_value() with IGNORE NULLS loop forever (EXCLUDE GROUP/TIES, frame past partition end, no ORDER BY)

From: shihao zhong <zhong950419(at)gmail(dot)com>
To: Tatsuo Ishii <ishii(at)postgresql(dot)org>
Cc: c(dot)bhuvan(at)iitg(dot)ac(dot)in, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: first_value()/nth_value() with IGNORE NULLS loop forever (EXCLUDE GROUP/TIES, frame past partition end, no ORDER BY)
Date: 2026-11-04 14:23:11
Message-ID: CAGRkXqQOgo8qCsi42rJ-qJOpMVTZFM5YZdKxo9U2em51Vzyhvg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Yes, the last_value test passes with or without the fix and only
guards against a later change to row_is_in_frame that returns -1 for
rows after the current row.

Thanks,
Shihao

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message shihao zhong 2026-11-04 14:33:55 Re: BUG #19775: Incremental backup without data checksums restores a stale visibility map page after VACUUM truncati
Previous Message Fujii Masao 2026-11-04 13:55:33 Re: BUG #19775: Incremental backup without data checksums restores a stale visibility map page after VACUUM truncati