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

From: Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Richard Guo <guofenglinux(at)gmail(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: Clause accidentally pushed down ( Possible bug in Making Vars outer-join aware)
Date: 2023-05-22 06:07:23
Message-ID: 32adb59d-e1ea-9ccd-9aac-00677e53b44c@postgrespro.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 5/19/23 23:50, Tom Lane wrote:
> Richard Guo <guofenglinux(at)gmail(dot)com> writes:
>> ...
>> We'd be mistaken to think t1/t2 join is removable, because we are
>> checking its syntactic relid set, which includes all rels, and so that
>> are not aware that t2.a is used by t2/t3 join.
> ...
> I think your patch is correct.

Because the feature pushed into the master, I checked it with the
sqlancer tests. During all-weekend run no any problems were found.

--
Regards
Andrey Lepikhov
Postgres Professional

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Hans Buschmann 2023-05-22 07:11:16 AW: AW: BUG #17923: Excessive warnings of collation version mismatch in logs
Previous Message Masahiko Sawada 2023-05-22 00:56:27 Re: BUG #17695: Failed Assert in logical replication snapbuild.