Horton

Re: v16 regression - wrong query results with LEFT JOINs + join removal

Robert Haas <robertmhaas@gmail.com>

View thread View on postgr.es
From: Robert Haas <robertmhaas@gmail.com>
To: Kirk Wolak <wolakk@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2023-05-12T11:39:29Z
Lists: pgsql-hackers 
On Thu, May 11, 2023 at 4:16 PM Kirk Wolak <wolakk@gmail.com> wrote:
> Forgive the noob question...  But does this trigger a regression test to be created?
> And who tracks/pushes that?

Tom included one in the commit.

-- 
Robert Haas
EDB: http://www.enterprisedb.com

Commits

  1. Undo faulty attempt at not relying on RINFO_IS_PUSHED_DOWN.

  2. Generate code for query jumbling through gen_node_support.pl

  3. Allow REPLICA IDENTITY to be set on an index that's not (yet) valid.