MIME-Version: 1.0
References: <19533-413a1014e5d0e766@postgresql.org>
 <EC273387-5C73-4C9C-BF30-8BA260A90FFB@outlook.com>
 <CAMbWs4-6umOecRifmC88RW0SHWDAvb4c3-VD8XQ3NJufsUyUOQ@mail.gmail.com>
 <CAApHDvqHXZpF9pPStLqPp5O=G2gVpPD959bMTRRkLjdy4Tvx7g@mail.gmail.com>
 <CAApHDvoJ07GM6V2QWyJAgsJcM-dcFS+nwPq4Um=-NsXv5PmoCw@mail.gmail.com>
 <CANWCAZbiYQ+=CHAaftwp2x83Gy6tJCB8GUe15yO5DW-cpp0Mxg@mail.gmail.com>
In-Reply-To: 
 <CANWCAZbiYQ+=CHAaftwp2x83Gy6tJCB8GUe15yO5DW-cpp0Mxg@mail.gmail.com>
From: John Naylor <johncnaylorls@gmail.com>
Date: Fri, 3 Jul 2026 16:11:13 +0700
Message-ID: 
 <CANWCAZbhqpLOWKLx4FSdwRFuBDG6YLjdYkDyy7hCbO0wOngb-A@mail.gmail.com>
Subject: Re: BUG #19533: Wrong results from WindowAgg run-condition pushdown
 on count() with EXCLUDE CURRENT ROW
To: David Rowley <dgrowleyml@gmail.com>
Cc: Richard Guo <guofenglinux@gmail.com>,
 Chengpeng Yan <chengpeng_yan@outlook.com>,
	"imchifan@163.com" <imchifan@163.com>,
	"pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: 
 <https://www.postgresql.org/message-id/CANWCAZbhqpLOWKLx4FSdwRFuBDG6YLjdYkDyy7hCbO0wOngb-A%40mail.gmail.com>
Precedence: bulk

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

Sorry, this last result should be

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

--=20
John Naylor
Amazon Web Services