Do we need to pass down nonnullable_vars when reducing outer joins?

Поиск
Список
Период
Сортировка
От Richard Guo
Тема Do we need to pass down nonnullable_vars when reducing outer joins?
Дата
Msg-id CAMbWs48KLy9aBb=sZ5MoNmnqAcGHaW_JTGWLCgoE_uMW7S6C-A@mail.gmail.com
обсуждение исходный текст
Ответы Re: Do we need to pass down nonnullable_vars when reducing outer joins?
Список 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
Вложения

В списке pgsql-hackers по дате отправления: