Re: Removing const-false IS NULL quals and redundant IS NOT NULL quals

David Rowley <dgrowleyml@gmail.com>

From: David Rowley <dgrowleyml@gmail.com>
To: Peter Smith <smithpb2250@gmail.com>
Cc: Richard Guo <guofenglinux@gmail.com>, PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>, Andrei Lepikhov <a.lepikhov@postgrespro.ru>, Tom Lane <tgl@sss.pgh.pa.us>
Date: 2024-01-22T11:11:29Z
Lists: pgsql-bugs, pgsql-hackers

Attachments

On Mon, 22 Jan 2024 at 17:32, Peter Smith <smithpb2250@gmail.com> wrote:
> Hi, This patch has a CF status of "Needs Review" [1], but it seems
> there were CFbot test failures last time it was run [2].

I've attached v11 which updates the expected results in some newly
added regression tests.

No other changes.

David

Commits

  1. Add better handling of redundant IS [NOT] NULL quals