Re: apply outer->inner join optimisation to OR clauses

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: apply outer->inner join optimisation to OR clauses
Дата
Msg-id 15308.1051982531@sss.pgh.pa.us
обсуждение исходный текст
Ответ на apply outer->inner join optimisation to OR clauses  (Bradley Baetz <bbaetz@acm.org>)
Ответы Re: apply outer->inner join optimisation to OR clauses  (Bradley Baetz <bbaetz@acm.org>)
Список pgsql-patches
Bradley Baetz <bbaetz@acm.org> writes:
> The attached patch applies the optimisation translating outer joins to
> inner joins (where safe) to the cases where the WHERE clause has OR bits
> in it too, if the column is present (and not null) in all of the OR
> bits.

Your change for AND is obviously incorrect, and I don't think I believe
the OR case either.  Why is it safe to pass down a TRUE top_level flag?

            regards, tom lane


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

Предыдущее
От: Joe Conway
Дата:
Сообщение: contrib/tablefunc bugfix
Следующее
От: Tom Lane
Дата:
Сообщение: Re: contrib/tablefunc bugfix