Horton
Menu

Re: BUG #18846: Incorrect Filtering Behavior with FULL OUTER JOIN and WHERE Condition

David G. Johnston <david.g.johnston@gmail.com>

View thread
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: "cheng.zhi.qiang@outlook.com" <cheng.zhi.qiang@outlook.com>, "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Date: 2025-03-14T13:48:35Z
Lists: 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.

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. doc: PG 16 relnotes, fix PREPARE/EXECUTE wording