Re: BUG #1916: selection criteria from one outer join on clause applied to other joins

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #1916: selection criteria from one outer join on clause applied to other joins
Дата
Msg-id 1909.1127882077@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #1916: selection criteria from one outer join on clause applied to other joins  ("Kevin Grittner" <kevin.grittner@wicourts.gov>)
Ответы Re: BUG #1916: selection criteria from one outer join on clause applied to other joins  (Klint Gore <kg@kgb.une.edu.au>)
Список pgsql-bugs
Дерево обсуждения 
"Kevin Grittner" <kevin.grittner@wicourts.gov> writes:
> Obviously, adding an outer join to a query which is already returning rows
> should never reduce the number of rows returned.

I think this is a case of overenthusiastic propagation of implied
equalities.  Do you know offhand if it fails in 8.0.* or earlier
branches?

            regards, tom lane

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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: BUG #1916: selection criteria from one outer join on clause applied to other joins
Следующее
От: Klint Gore
Дата:
Сообщение: Re: BUG #1916: selection criteria from one outer join on clause applied to other joins