Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #17495: Regression in 15beta1 when filtering subquery including row_number window function - Mailing list pgsql-bugs

From Richard Guo
Subject Re: BUG #17495: Regression in 15beta1 when filtering subquery including row_number window function
Date
Msg-id CAMbWs48zrWjc2EwbOqodP=UMu=p4u_tCic+OZ=YPD8P9AFiKpQ@mail.gmail.com
Whole thread Raw
In response to Re: BUG #17495: Regression in 15beta1 when filtering subquery including row_number window function  (Richard Guo <guofenglinux@gmail.com>)
Responses Re: BUG #17495: Regression in 15beta1 when filtering subquery including row_number window function
List pgsql-bugs
Tree view

On Thu, May 26, 2022 at 4:22 PM Richard Guo <guofenglinux@gmail.com> wrote:
On Thu, May 26, 2022 at 1:38 PM David Rowley <dgrowleyml@gmail.com> wrote:
Yeah, I was aiming for a way to have it so the planner didn't
vandalise WindowClause.

I've attached a patch which fixes the bug and does not require any
further modifications to WindowClause.

The patch looks sane to me, expect that line 122 in the patch introduces
a whitespace-only line.

Another review comment:

- * extra_used_attrs can passed as non-NULL to mark any columns that we should
+ * extra_used_attrs can be passed as non-NULL to mark any columns that we should

Thanks
Richard 

pgsql-bugs by date:

Previous
From: Richard Guo
Date:
Subject: Re: BUG #17495: Regression in 15beta1 when filtering subquery including row_number window function
Next
From: Bruce Momjian
Date:
Subject: Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY