Re: prerequisites of pull_up_sublinks

On Wed, Apr 21, 2021 at 4:37 PM David Rowley wrote: > On Wed, 21 Apr 2021 at 14:55, Andy Fan wrote: > > * However, this optimization *only* > > * works at the top level of WHERE or a JOIN/ON clause, because we cannot > > * distinguish whether the ANY ought to return FALSE or NULL in cases > >

Re: prerequisites of pull_up_sublinks

On Wed, 21 Apr 2021 at 14:55, Andy Fan wrote: > * However, this optimization *only* > * works at the top level of WHERE or a JOIN/ON clause, because we cannot > * distinguish whether the ANY ought to return FALSE or NULL in cases > * involving NULL inputs. Also, in an outer join's ON clause we

prerequisites of pull_up_sublinks

Hi, I'm reading the pull_up_sublinks, and find the below comments. * However, this optimization *only* * works at the top level of WHERE or a JOIN/ON clause, because we cannot * distinguish whether the ANY ought to return FALSE or NULL in cases * involving NULL inputs. Also, in an outer join'