Re: BUG #19707: Reproduction of BUG #19553 on PostgreSQL 18.4: nested LEFT JOIN returns a constant instead of NULL - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #19707: Reproduction of BUG #19553 on PostgreSQL 18.4: nested LEFT JOIN returns a constant instead of NULL
Date
Msg-id CAKFQuwbnL66k8X9sZymj0vmynF3-aLTdaczWdmE0C-5B9R-10A@mail.gmail.com
Whole thread
In response to BUG #19707: Reproduction of BUG #19553 on PostgreSQL 18.4: nested LEFT JOIN returns a constant instead of NULL  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
On Sunday, September 20, 2026, PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      19707
Logged by:          N J
Email address:      1482694023@qq.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.
 

pgsql-bugs by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: BUG #19706: Documentation: Missing step in the instructions for restoring sample dvdrental DB from dvdrental.zip
Next
From: Tom Lane
Date:
Subject: Re: BUG #19703: information_schema.usage_privileges omits a sequence owner's implicit USAGE privilege