Horton

Re: Query result differences between PostgreSQL 17 vs 16

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bruce Momjian <bruce@momjian.us>
Cc: Richard Guo <guofenglinux@gmail.com>, David Rowley <dgrowleyml@gmail.com>, Ronald Cruz <cruz@rentec.com>, pgsql-bugs@lists.postgresql.org, Peter Ford <pford@rentec.com>, "Aaron J. Garcia" <agarcia@rentec.com>
Date: 2025-03-12T00:57:06Z
Lists: pgsql-bugs 
Bruce Momjian <bruce@momjian.us> writes:
> Well, I was trying to figure out if we should be changing the NULL
> handling in 17.X, but now that you have done it with one patch, it seems
> the above URL patch should also be applied and backpatched to 17, no?

If you want somebody to review that patch, shouldn't it be in the CF?

			regards, tom lane

Commits

  1. Avoid NullTest deduction for clone clauses

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