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

From Andrey Lepikhov
Subject Re: Clause accidentally pushed down ( Possible bug in Making Vars outer-join aware)
Date
Msg-id 32adb59d-e1ea-9ccd-9aac-00677e53b44c@postgrespro.ru
Whole thread Raw
In response to Re: Clause accidentally pushed down ( Possible bug in Making Vars outer-join aware)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Clause accidentally pushed down ( Possible bug in Making Vars outer-join aware)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On 5/19/23 23:50, Tom Lane wrote:
> Richard Guo <guofenglinux@gmail.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




pgsql-bugs by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: BUG #17695: Failed Assert in logical replication snapbuild.
Next
From: Hans Buschmann
Date:
Subject: AW: AW: BUG #17923: Excessive warnings of collation version mismatch in logs