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

On Fri, Nov 6, 2026 at 9:26 AM Tatsuo Ishii <ishii(at)postgresql(dot)org> wrote:
> Pushed. Thank you!
>
> https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=69b20fdd20de68b0f0eaa855669a6657c65c8533

Thanks for working on this!

The following query succeeded before this fix but fails afterward.
Is this intentional?

WITH t AS MATERIALIZED (
SELECT NULLIF(i, 1) / (2 - i) AS v
FROM generate_series(1, 2) AS g(i)
)
SELECT first_value(v) IGNORE NULLS OVER (ROWS CURRENT ROW)
FROM t
LIMIT 1;

Regards,

--
Fujii Masao