Do we need to pass down nonnullable_vars when reducing outer joins? - Mailing list pgsql-hackers

From Richard Guo
Subject Do we need to pass down nonnullable_vars when reducing outer joins?
Date
Msg-id CAMbWs48KLy9aBb=sZ5MoNmnqAcGHaW_JTGWLCgoE_uMW7S6C-A@mail.gmail.com
Whole thread Raw
Responses Re: Do we need to pass down nonnullable_vars when reducing outer joins?
List pgsql-hackers
AFAICS, the Vars forced nonnullable by given clause are only used to
check if we can reduce JOIN_LEFT to JOIN_ANTI, and it is checking the
join's own quals there. It seems to me we do not need to pass down
nonnullable_vars by upper quals to the children of a join.

Attached is a patch to remove the pass-down of nonnullable_vars.

Thanks
Richard
Attachment

pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: is_superuser is not documented
Next
From: Kyotaro Horiguchi
Date:
Subject: Re: Error "initial slot snapshot too large" in create replication slot