Horton

Re: BUG #18999: Equivalent queries processing WHERE IS NULL & WHERE IS NOT NULL produce mutually exclusive results

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

View thread
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Jinhui Lai <jinhui-lai@foxmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-bugs <pgsql-bugs@lists.postgresql.org>
Date: 2025-07-25T16:22:12Z
Lists: pgsql-bugs 
On Fri, Jul 25, 2025, 07:40 Jinhui Lai <jinhui-lai@foxmail.com> wrote:

>
> #PG 17.5, 16, 15, 14, 13, 12, 11, 10...#
>
> #PG 17.0-17.4#
>

This would be an unintended change/regression when 17.0 came out that was
discovered and fixed in 17.5

Reverting back to long-established behavior should not be a surprising
action to see.

David J.