Re: BUG #18429: Inconsistent results on similar queries with join lateral

From: Richard Guo <guofenglinux(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, "b(dot)ryder(at)ateme(dot)com" <b(dot)ryder(at)ateme(dot)com>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #18429: Inconsistent results on similar queries with join lateral
Date: 2024-04-14 09:15:24
Message-ID: CAMbWs49Z1wkMgWo5aytkDJD3JPW7QURV=ChfAQ+bmPa30Zt1EQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, Apr 12, 2024 at 10:50 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> "git bisect" fingers this commit as the first one producing correct
> answers:
>
> commit 2489d76c4906f4461a364ca8ad7e0751ead8aa0d
> Author: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2024-04-14 16:08:07 BUG #18433: Logical replication timeout
Previous Message Richard Guo 2024-04-14 08:59:06 Re: BUG #18429: Inconsistent results on similar queries with join lateral