Date: Tue, 11 Mar 2025 18:58:27 -0400
From: Bruce Momjian <bruce@momjian.us>
To: Tom Lane <tgl@sss.pgh.pa.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>
Subject: Re: Query result differences between PostgreSQL 17 vs 16
Message-ID: <Z9DAExs0YGLITyaZ@momjian.us>
References: 
 <CAMbWs4_SqFDZ1Mnp0Kmy-H2s7_-PdeuXva+kBG-jKSampoDHnw@mail.gmail.com>
 <CAMbWs48-_meMqqbkFQoVEEKBYYsanMvRk3zCqmVr23gyxkNhag@mail.gmail.com>
 <2337383.1740630494@sss.pgh.pa.us>
 <CAMbWs4-ATTw82Pc3B+64im26JQEWHemC-6VcGzqqqo_mjCEqpw@mail.gmail.com>
 <2748914.1740757698@sss.pgh.pa.us>
 <CAMbWs4_4HBfqs+AjrtNOeqZYwKTJps2jANzdCbAfQSCd-CdeGA@mail.gmail.com>
 <3650809.1741015351@sss.pgh.pa.us>
 <CAMbWs4_35p90MAuEV_cU4s8bMyL1ci9oLbSgzmdTB_+umXvkSw@mail.gmail.com>
 <Z9CzPA0W3Zyvqb6g@momjian.us>
 <1837979.1741731589@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <1837979.1741731589@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/Z9DAExs0YGLITyaZ%40momjian.us>
Precedence: bulk

On Tue, Mar 11, 2025 at 06:19:49PM -0400, Tom Lane wrote:
> Bruce Momjian <bruce@momjian.us> writes:
> > Uh, if we fixed this for NULL optimization and backpatched, should we do
> > the same for:
> > 	Parameter NOT NULL to CREATE DOMAIN not the same as CHECK (VALUE IS NOT NULL)
> > 	https://www.postgresql.org/message-id/flat/173591158454.714.7664064332419606037%40wrigleys.postgresql.org
> 
> This is unrelated to that.

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?

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Do not let urgent matters crowd out time for investment in the future.