Quick Links

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

From:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:	Richard Guo <guofenglinux(at)gmail(dot)com>
Cc:	Matheus Alcantara <matheusssilv97(at)gmail(dot)com>, 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-18 18:11:11
Message-ID:	298498.1784398271@sss.pgh.pa.us
Views:	Whole Thread \| Raw Message \| Download mbox \| Resend email
Thread:
Lists:	pgsql-bugs

Richard Guo <guofenglinux(at)gmail(dot)com> writes:
> On Sat, Jul 18, 2026 at 2:20 AM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> If no objections, I'll push and backpatch soon.

> v3 LGTM.

Pushed.

regards, tom lane

In response to

Re: BUG #19553: Wrong results from nested LEFT JOINs over an empty subquery (regression since v16) at 2026-07-18 01:40:28 from Richard Guo

Responses

Re: BUG #19553: Wrong results from nested LEFT JOINs over an empty subquery (regression since v16) at 2026-07-18 18:33:26 from Matheus Alcantara
Re: BUG #19553: Wrong results from nested LEFT JOINs over an empty subquery (regression since v16) at 2026-07-20 02:33:23 from Richard Guo

Browse pgsql-bugs by date

	From	Date	Subject
Next Message	Matheus Alcantara	2026-07-18 18:33:26	Re: BUG #19553: Wrong results from nested LEFT JOINs over an empty subquery (regression since v16)
Previous Message	Tom Lane	2026-07-18 17:03:31	Re: [patch] BUG #19558: User-defined prefix operators "\|" and "->" no longer parse in 19beta2 (SQL/PGQ grammar change)