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

Поиск
Список
Период
Сортировка
От Pelle Johansson
Тема Re: BUG #3012: Wrong JOIN order when a JOIN depends on result from a LEFT JOIN.
Дата
Msg-id CB4E41BE-E528-40C8-BE32-CD3922CCA0EF@morth.org
обсуждение исходный текст
Ответ на Re: BUG #3012: Wrong JOIN order when a JOIN depends on result from a LEFT JOIN.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
16 feb 2007 kl. 22.00 skrev Tom Lane:

> "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.

Hi Tom,

Thanks for the quick fix. We don't really have any good way to apply
the patch, so we'll just use our workaround in the mean time, but
it's good to know the issue is resolved.
--
Pelle Johansson

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: BUG #3056: strange behave of CHECK constraint
Следующее
От: "Dr. Axel Reimann"
Дата:
Сообщение: BUG #3030: Unable to query SQL_WCHAR column via ODBC