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

From: Tatsuo Ishii <ishii(at)postgresql(dot)org>
To: zhong950419(at)gmail(dot)com
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-05 00:19:47
Message-ID: 20261105.091947.1557138019099337522.ishii@postgresql.org
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.

The change to row_is_in_frame has not been decided in the community
yet. Why we need to install a test for it now?

Regards,
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message shihao zhong 2026-11-05 00:48:22 Re: first_value()/nth_value() with IGNORE NULLS loop forever (EXCLUDE GROUP/TIES, frame past partition end, no ORDER BY)
Previous Message David Rowley 2026-11-04 21:33:26 Re: Wrong result: count(DISTINCT x COLLATE "C") with GROUP BY x on a nondeterministic collation