Re: BUG #19707: Reproduction of BUG #19553 on PostgreSQL 18.4: nested LEFT JOIN returns a constant instead of NULL

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: "1482694023(at)qq(dot)com" <1482694023(at)qq(dot)com>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #19707: Reproduction of BUG #19553 on PostgreSQL 18.4: nested LEFT JOIN returns a constant instead of NULL
Date: 2026-09-20 14:07:11
Message-ID: CAKFQuwbnL66k8X9sZymj0vmynF3-aLTdaczWdmE0C-5B9R-10A@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Sunday, September 20, 2026, PG Bug reporting form <noreply(at)postgresql(dot)org>
wrote:

> The following bug has been logged on the website:
>
> Bug reference: 19707
> Logged by: N J
> Email address: 1482694023(at)qq(dot)com
> PostgreSQL version: 18.4
> Operating system: Windows 11 64-bit
> Description:
>
> Environment:
> PostgreSQL: 18.4
> Client: pgAdmin 4
> Operating system: Windows 11 64-bit

It’s usually not that helpful to report problems against
obsolete/unsupported versions. The supported 18.6 release notes has an
entry that appears to cover this. You need to upgrade.

David J.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2026-09-20 15:49:45 Re: BUG #19703: information_schema.usage_privileges omits a sequence owner's implicit USAGE privilege
Previous Message Laurenz Albe 2026-09-20 13:02:23 Re: BUG #19706: Documentation: Missing step in the instructions for restoring sample dvdrental DB from dvdrental.zip