Re: RIGHT JOIN is only supported with mergejoinable join conditions

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: RIGHT JOIN is only supported with mergejoinable join conditions
Дата
Msg-id 7727.1005173300@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: RIGHT JOIN is only supported with mergejoinable join conditions  ("Nick Fankhauser" <nickf@ontko.com>)
Список pgsql-sql
"Nick Fankhauser" <nickf@ontko.com> writes:
> I agree that this still may be a bug.

It definitely is a bug --- we fixed a similar problem around 7.1.1 or
so, but this test case appears to expose a different variant of the
mistake.  (The planner is generating a plan that the executor can't
handle; it's supposed to know not to do that.)

I think I know where to fix it, but am not confident enough in
my powers of analysis today to want to actually commit anything.
(I've had a bad head-cold all week and am still unable to do anything
that requires more than a few minutes of sustained thought :-()
Will get back on it as soon as I feel better...
        regards, tom lane


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

Предыдущее
От: "Nick Fankhauser"
Дата:
Сообщение: Re: RIGHT JOIN is only supported with mergejoinable join conditions
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Need help with embedded CASEs