pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Richard Guo <guofenglinux@gmail.com>
Cc: Bruce Momjian <bruce@momjian.us>
Cc: David Rowley <dgrowleyml@gmail.com>
Cc: Ronald Cruz <cruz@rentec.com>
Cc: pgsql-bugs@lists.postgresql.org, Peter Ford <pford@rentec.com>
Cc: Aaron J. Garcia <agarcia@rentec.com>
Subject: Re: Query result differences between PostgreSQL 17 vs 16
Date: Mon, 03 Mar 2025 10:22:31 -0500
Message-ID: <3650809.1741015351@sss.pgh.pa.us> (raw)
In-Reply-To: <CAMbWs4_4HBfqs+AjrtNOeqZYwKTJps2jANzdCbAfQSCd-CdeGA@mail.gmail.com>
References: <f5320d3d-77af-4ce8-b9c3-4715ff33f213@rentec.com>
	<Z7kGplh70wbeX9su@momjian.us>
	<3736132.1740181858@sss.pgh.pa.us>
	<CAMbWs4_A=DFhTHQvbtCXpzs7OBGb0HcNX-yDsf01chVP60D9EQ@mail.gmail.com>
	<3818495.1740191559@sss.pgh.pa.us>
	<CAMbWs4_BCC8+4PqJi2NcO5WTu5vsJPMh7iAe7e=nXNVTZNp+LQ@mail.gmail.com>
	<CAMbWs49rShAwK0sMz+-6d9hGd1RsRQd0tBuVUGvh88pNu9hG1w@mail.gmail.com>
	<1716556.1740551169@sss.pgh.pa.us>
	<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>

Richard Guo <guofenglinux@gmail.com> writes:
> Here is an updated patch, which also includes the test case you found
> proving the no-clone-quals limitation in restriction_is_always_false
> is also needed.

LGTM.

			regards, tom lane





view thread (23+ messages)  latest in thread

Message-ID: <3650809.1741015351@sss.pgh.pa.us>
Permalink:  ../3650809.1741015351@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/3650809.1741015351@sss.pgh.pa.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: tgl@sss.pgh.pa.us, guofenglinux@gmail.com, bruce@momjian.us, dgrowleyml@gmail.com, cruz@rentec.com, pford@rentec.com, agarcia@rentec.com
  Subject: Re: Query result differences between PostgreSQL 17 vs 16
  In-Reply-To: <3650809.1741015351@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox