Horton

Re: Clause accidentally pushed down ( Possible bug in Making Vars outer-join aware)

Robert Haas <robertmhaas@gmail.com>

View thread View on postgr.es
From: Robert Haas <robertmhaas@gmail.com>
To: Richard Guo <guofenglinux@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Andrey Lepikhov <a.lepikhov@postgrespro.ru>, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Date: 2023-05-11T16:11:14Z
Lists: pgsql-bugs 
On Sun, May 7, 2023 at 10:39 PM Richard Guo <guofenglinux@gmail.com> wrote:
> Hi Tom, how do you think about the v3 patch?

Hi Richard,

Thanks for working on this.

Today I reported an issue that Tom speculated might be related, so I
tried these patches and they didn't seem to fix it. It might be an
unrelated problem, but I thought it might be a good idea to put a link
to that thread here just for awareness:

https://www.postgresql.org/message-id/CA+TgmoYco=hmg+iX1CW9Y1_CzNoSL81J03wUG-d2_3=rue+L2A@mail.gmail.com

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

Commits

  1. Fix thinko in join removal.

  2. Convert nullingrels match checks from Asserts to test-and-elog.

  3. Fix some issues with improper placement of outer join clauses.