Re: BUG #19533: Wrong results from WindowAgg run-condition pushdown on count() with EXCLUDE CURRENT ROW - Mailing list pgsql-bugs

On Fri, Jul 3, 2026 at 4:09 PM John Naylor <johncnaylorls@gmail.com> wrote:
> =# SELECT * FROM
>   (SELECT x,
>           count(*) OVER (ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) c
>    FROM t7) s
> WHERE c + 0 >= 2;    -- baseline
>  x | c
> ---+---
>  2 | 2
>  2 | 3
> (2 rows)

Sorry, this last result should be

 x | c
---+---
 8 | 2
 9 | 3
(2 rows)

--
John Naylor
Amazon Web Services