Postgres Pro
Downloads
Home   >   mailing lists

Re: v16 regression - wrong query results with LEFT JOINs + join removal - Mailing list pgsql-hackers

From Robert Haas
Subject Re: v16 regression - wrong query results with LEFT JOINs + join removal
Date
Msg-id CA+TgmoYqkaQxn6D-R9XEduZr+7S32w9e8JJnOeo93HD_NA1FOA@mail.gmail.com
Whole thread Raw
In response to Re: v16 regression - wrong query results with LEFT JOINs + join removal  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
On Thu, May 11, 2023 at 1:46 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> > What I'm inclined to do about it is just revert this particular
> > change.  But I'd better run around and see where else I did that,
> > because the idea is evidently not ready for prime time.
>
> Looks like that was the only such change in 2489d76c4 or
> follow-ons, so done, with a test case based on your example.

Thanks, Tom!

--
Robert Haas
EDB: http://www.enterprisedb.com

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: v16 regression - wrong query results with LEFT JOINs + join removal
Next
From: Tom Lane
Date:
Subject: Re: psql tests hangs