Postgres Pro
Downloads
Home   >   mailing lists

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

From Richard Guo
Subject Re: BUG #18429: Inconsistent results on similar queries with join lateral
Date
Msg-id CAMbWs49Z1wkMgWo5aytkDJD3JPW7QURV=ChfAQ+bmPa30Zt1EQ@mail.gmail.com
Whole thread Raw
In response to Re: BUG #18429: Inconsistent results on similar queries with join lateral  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view

On Fri, Apr 12, 2024 at 10:50 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
"git bisect" fingers this commit as the first one producing correct
answers:

commit 2489d76c4906f4461a364ca8ad7e0751ead8aa0d
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date:   Mon Jan 30 13:16:20 2023 -0500

    Make Vars be outer-join-aware.

This is kind of exciting for me, as IIRC it's the first field-detected
bug that that work fixes.

+1.  As a big fan of the outer-join-aware-Var work, I'm so excited to
see field-detected bugs it fixes.

Thanks
Richard

pgsql-bugs by date:

Previous
From: Richard Guo
Date:
Subject: Re: BUG #18429: Inconsistent results on similar queries with join lateral
Next
From: PG Bug reporting form
Date:
Subject: BUG #18433: Logical replication timeout