public inbox for [email protected]
help / color / mirror / Atom feedFrom: John Naylor <[email protected]>
To: David Rowley <[email protected]>
Cc: Richard Guo <[email protected]>
Cc: Chengpeng Yan <[email protected]>
Cc: [email protected] <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: BUG #19533: Wrong results from WindowAgg run-condition pushdown on count() with EXCLUDE CURRENT ROW
Date: Fri, 3 Jul 2026 16:11:13 +0700
Message-ID: <CANWCAZbhqpLOWKLx4FSdwRFuBDG6YLjdYkDyy7hCbO0wOngb-A@mail.gmail.com> (raw)
In-Reply-To: <CANWCAZbiYQ+=CHAaftwp2x83Gy6tJCB8GUe15yO5DW-cpp0Mxg@mail.gmail.com>
References: <[email protected]>
<[email protected]>
<CAMbWs4-6umOecRifmC88RW0SHWDAvb4c3-VD8XQ3NJufsUyUOQ@mail.gmail.com>
<CAApHDvqHXZpF9pPStLqPp5O=G2gVpPD959bMTRRkLjdy4Tvx7g@mail.gmail.com>
<CAApHDvoJ07GM6V2QWyJAgsJcM-dcFS+nwPq4Um=-NsXv5PmoCw@mail.gmail.com>
<CANWCAZbiYQ+=CHAaftwp2x83Gy6tJCB8GUe15yO5DW-cpp0Mxg@mail.gmail.com>
On Fri, Jul 3, 2026 at 4:09 PM John Naylor <[email protected]> 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
view thread (15+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: BUG #19533: Wrong results from WindowAgg run-condition pushdown on count() with EXCLUDE CURRENT ROW
In-Reply-To: <CANWCAZbhqpLOWKLx4FSdwRFuBDG6YLjdYkDyy7hCbO0wOngb-A@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox