Re: BUG #17495: Regression in 15beta1 when filtering subquery including row_number window function

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: BUG #17495: Regression in 15beta1 when filtering subquery including row_number window function
Дата
Msg-id Yo19nvTiHUZDDqwl@paquier.xyz
обсуждение исходный текст
Ответ на BUG #17495: Regression in 15beta1 when filtering subquery including row_number window function  (PG Bug reporting form <noreply@postgresql.org>)
Ответы Re: BUG #17495: Regression in 15beta1 when filtering subquery including row_number window function  (David Rowley <dgrowleyml@gmail.com>)
Список pgsql-bugs
Дерево обсуждения 
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
Вложения

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Use of signal-unsafe functions from signal handlers
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY