Re: BUG #3588: coalesce not working in join

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #3588: coalesce not working in join
Дата
Msg-id 13471.1188432001@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #3588: coalesce not working in join  ("Richard Harris" <richard_haris@adp.com>)
Список pgsql-bugs
Дерево обсуждения 
"Richard Harris" <richard_haris@adp.com> writes:
> Is PG 8.2.4 behavior correct?

Nope :-(  ... looks like some sorta bug in the rules for when outer
joins can be rearranged.  It's doing the t1a/t1b join first, and
then taking that as the right side of the join to t2, which means
that the t1b column goes to null if there's not a match to t2.pkt2.
Needs some study ...

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #3587: EXECUTE and trigger problem [VASCL:A163D284A86]
Следующее
От: "fuminori ido"
Дата:
Сообщение: BUG #3589: /etc/init.d/postgresql reload doesn't reflect /etc/postgresql/postgresql.conf log_statement