| From: | David Rowley <dgrowleyml(at)gmail(dot)com> |
|---|---|
| To: | Michael Paquier <michael(at)paquier(dot)xyz> |
| Cc: | jeremyevans0(at)gmail(dot)com, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: BUG #17495: Regression in 15beta1 when filtering subquery including row_number window function |
| Date: | 2022-05-25 02:17:05 |
| Message-ID: | CAApHDvrN70gq8jY+HjDwXG1015SOne9B8a2SBtAyxmn_v0ErYw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Wed, 25 May 2022 at 12:51, Michael Paquier <michael(at)paquier(dot)xyz> wrote:
>
> 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
Thanks for adding. I've put myself as the owner of this and will look
at it soon.
Jeremy, Thanks for the report.
David
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Guo | 2022-05-25 02:35:27 | Re: BUG #17495: Regression in 15beta1 when filtering subquery including row_number window function |
| Previous Message | Tom Lane | 2022-05-25 01:25:14 | Re: Use of signal-unsafe functions from signal handlers |