Re: Unify "In" Sublink to EXIST Sublink for better optimize opportunity

2022-10-09 Thread Andy Fan
Hi: On Thu, Oct 6, 2022 at 3:24 PM Andy Fan wrote: > > Due to the implementation of convert_ANY_sublink_to_join, we have > limitations below, which has been discussed at [1] [2]. > > if (contain_vars_of_level((Node *) subselect, 1)) > return NULL; > > I'm thinking if we can do the $

Unify "In" Sublink to EXIST Sublink for better optimize opportunity

2022-10-06 Thread Andy Fan
Due to the implementation of convert_ANY_sublink_to_join, we have limitations below, which has been discussed at [1] [2]. if (contain_vars_of_level((Node *) subselect, 1)) return NULL; I'm thinking if we can do the ${subject}. If so, the query like SELECT * FROM t1 WHERE a IN (SELE