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, c(dot)bhuvan(at)iitg(dot)ac(dot)in
Cc: 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-06 00:25:31
Message-ID: 20261106.092531.2094637405208239588.ishii@postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> Attached is the v1 patch, based on Bhuvan's second patch, minus the
> last_value test case. The commit message is almost copied from his
> patch, except comments about the test cases, which I feel too verbose
> for a commit message. IMO attached patch is ready for commit, but
> comments are welcome. If there's no objection, I will push it to
> master and 19 branches soon.

Pushed. Thank you!

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=69b20fdd20de68b0f0eaa855669a6657c65c8533
--
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 Amit Langote 2026-11-06 02:31:29 Re: BUG #19768: JSON_TABLE: row/text comparisons in context item or PASSING give wrong results or spurious collation
Previous Message Michael Paquier 2026-11-06 00:20:08 Re: [Bug] Heap use-after-free in COPY FROM error context after ON_ERROR ignore skips a row