Re: BUG #18999: Equivalent queries processing WHERE IS NULL & WHERE IS NOT NULL produce mutually exclusive results - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #18999: Equivalent queries processing WHERE IS NULL & WHERE IS NOT NULL produce mutually exclusive results
Date
Msg-id CAKFQuwYn262QrZBOyxjg8qk8Ch-atvCfsEuAEgkLevz6HMwGGg@mail.gmail.com
Whole thread Raw
In response to Re: BUG #18999: Equivalent queries processing WHERE IS NULL & WHERE IS NOT NULL produce mutually exclusive results  ("Jinhui Lai" <jinhui-lai@foxmail.com>)
List 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.

pgsql-bugs by date:

Previous
From: Hugo DUBOIS
Date:
Subject: Re: Unexpected Standby Shutdown on sync_replication_slots change