Re: BUG #18846: Incorrect Filtering Behavior with FULL OUTER JOIN and WHERE Condition - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #18846: Incorrect Filtering Behavior with FULL OUTER JOIN and WHERE Condition
Date
Msg-id CAKFQuwZYFdcjfOHUskBK0ODPoZat-YA1YYYm_sVF105P-abGQQ@mail.gmail.com
Whole thread Raw
In response to BUG #18846: Incorrect Filtering Behavior with FULL OUTER JOIN and WHERE Condition  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
On Friday, March 14, 2025, PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      18846
Logged by:          zhiqiang cheng
Email address:      cheng.zhi.qiang@outlook.com
PostgreSQL version: 16.1
Operating system:   Ubuntu 20.04
Description:       

Postgres version:
Github commit: 3f1aaaa180689f2015e7f7bd01c9be6d7a993b42
Version:  PostgreSQL 16beta1 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu
9.4.0-1ubuntu1~20.04.2) 9.4.0, 64-bit

16beta1 is not a valid version to be reporting bugs against or asking for support on.  Or to be running.

Testing against 16.6 shows the expected result.

David J.
 

pgsql-bugs by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: ISN extension - wrong volatility level for isn_weak() function
Next
From: Daniel Gustafsson
Date:
Subject: Re: BUG #18845: DEREF_OF_NULL.RET guc_malloc possibly returns NULL