From: Michael Paquier <michael@paquier.xyz>
To: jeremyevans0@gmail.com
To: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17495: Regression in 15beta1 when filtering subquery including row_number window function
Date: Wed, 25 May 2022 09:51:42 +0900
Message-ID: <Yo19nvTiHUZDDqwl@paquier.xyz> (raw)
In-Reply-To: <17495-7ffe2fa0b261b9fa@postgresql.org>
References: <17495-7ffe2fa0b261b9fa@postgresql.org>
On Tue, May 24, 2022 at 04:17:35PM +0000, PG Bug reporting form wrote:
> From testing with 15beta1, I think there is a regression in filtering a
> subquery using the result of the row_number window function. Here is the
> code:
>
> This was discovered by the tests for Sequel, a Ruby database access
> library.
Inconsistency reproduced here, thanks for the detailed report and the
test case! I have added an open item:
https://wiki.postgresql.org/wiki/PostgreSQL_15_Open_Items
--
Michael
Attachments:
signature.asc (application/pgp-signature, 832B) download
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: pgsql-bugs@postgresql.org
Cc: michael@paquier.xyz, jeremyevans0@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17495: Regression in 15beta1 when filtering subquery including row_number window function
In-Reply-To: <Yo19nvTiHUZDDqwl@paquier.xyz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox