Re: wrong query result due to wang plan

Поиск
Список
Период
Сортировка
От Richard Guo
Тема Re: wrong query result due to wang plan
Дата
Msg-id CAMbWs49De1Wsk3QPKK9BQW_H0Pk2LMz7XvX8aO=MSq+FNvazdw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: wrong query result due to wang plan  (Richard Guo <guofenglinux@gmail.com>)
Список pgsql-hackers

On Thu, Feb 16, 2023 at 5:50 PM Richard Guo <guofenglinux@gmail.com> wrote:
It seems we still need to check whether a variable-free qual comes from
somewhere that is below the nullable side of an outer join before we
decide that it can be evaluated at join domain level, just like we did
before.  So I wonder if we can add a 'below_outer_join' flag in
JoinTreeItem, fill its value during deconstruct_recurse, and check it in
distribute_qual_to_rels() like

       /* eval at join domain level if not below outer join */
-      relids = bms_copy(jtitem->jdomain->jd_relids);
+      relids = jtitem->below_outer_join ?
+               bms_copy(qualscope) : bms_copy(jtitem->jdomain->jd_relids);
 
To be concrete, I mean something like attached.

Thanks
Richard
Вложения

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

Предыдущее
От: "Drouvot, Bertrand"
Дата:
Сообщение: Re: Normalization of utility queries in pg_stat_statements
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Move defaults toward ICU in 16?