Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #18429: Inconsistent results on similar queries with join lateral - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #18429: Inconsistent results on similar queries with join lateral
Date
Msg-id 481322.1712948510@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #18429: Inconsistent results on similar queries with join lateral  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-bugs
Tree view 
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Fri, Apr 12, 2024 at 8:50 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> I'm not seeing a bulletproof way offhand, other than "update to v16".

> Q1 is trivially fixed by specifying "WITH c2 AS MATERIALIZED ( ... )", No?

Q1 as stated, yeah.  But the question was about generically avoiding
this bug, and I'm not yet sure about how to do that in cases not
involving a WITH boundary (eg Q3,Q4).

            regards, tom lane

pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: BUG #18430: syntax error when using aggregate function in where clause of subquery
Next
From: Tom Lane
Date:
Subject: Re: BUG #18430: syntax error when using aggregate function in where clause of subquery