Re: BUG #19553: Wrong results from nested LEFT JOINs over an empty subquery (regression since v16)

From: "Matheus Alcantara" <matheusssilv97(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <leis(at)in(dot)tum(dot)de>, <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #19553: Wrong results from nested LEFT JOINs over an empty subquery (regression since v16)
Date: 2026-07-16 23:47:12
Message-ID: DK0EAFS5XDMW.1FDFY8FPSOPXR@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Thu Jul 16, 2026 at 8:23 PM -03, Tom Lane wrote:
>
> [ ... ]
>
> But I've not tried to write any code yet; do you feel like attacking
> that?
>

Sure, I'll try to write and I'll share soon.

--
Matheus Alcantara
EDB: https://www.enterprisedb.com

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2026-07-17 03:55:20 BUG #19555: TRAP: failed Assert (ent->cmin == change->data.tuplecid.cmin) on logical replication
Previous Message Tom Lane 2026-07-16 23:23:30 Re: BUG #19553: Wrong results from nested LEFT JOINs over an empty subquery (regression since v16)