Re: BUG #3012: Wrong JOIN order when a JOIN depends on result from a LEFT JOIN.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #3012: Wrong JOIN order when a JOIN depends on result from a LEFT JOIN.
Дата
Msg-id 7538.1171659641@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #3012: Wrong JOIN order when a JOIN depends on result from a LEFT JOIN.  ("Pelle Johansson" <morth@morth.org>)
Ответы Re: BUG #3012: Wrong JOIN order when a JOIN depends on result from a LEFT JOIN.  (Pelle Johansson <morth@morth.org>)
Список pgsql-bugs
"Pelle Johansson" <morth@morth.org> writes:
> We have a join where we select which row to join on a subquery with a
> coalesce on a column from a left join, which is not working as expected.

The attached patch should fix this.

            regards, tom lane


Вложения

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #3015: libpq: PQftype() on a lo type result column returns Oid of type oid instead of Oid of type lo.
Следующее
От: Phil Frost
Дата:
Сообщение: Re: Segfaults and assertion failures with not too extraordinary views and queries