ERROR: failed to build any 4-way joins SQL state: XX000, PostgreSQL 8.2 beta1

Поиск
Список
Период
Сортировка
От JEAN-PIERRE PELLETIER
Тема ERROR: failed to build any 4-way joins SQL state: XX000, PostgreSQL 8.2 beta1
Дата
Msg-id BAY118-F21F664BEEA514B5150A21295010@phx.gbl
обсуждение исходный текст
Ответы Re: ERROR: failed to build any 4-way joins SQL state: XX000, PostgreSQL 8.2 beta1
Список pgsql-bugs
Hi,

I have a query that throws "ERROR: failed to build any 4-way joins
SQL state: XX000".

Here's an (arguably) simplified version of it that doesn't require any of my
table:

select
   1
from
   (select 1 as col) t1

   cross join (select 1 as col) t2

   left outer join (select 1 as col) t3
   on  t1.col = t3.col
   and t2.col = t3.col
   and 1 = t3.col

   left outer join (select 1 as col) t4
   on t3.col = t4.col

I am on PostgreSQL 8.2 beta1 under Windows XP Service Pack 2.

Thanks,
Jean-Pierre Pelletier
e-djuster

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

Предыдущее
От: "Thomas H."
Дата:
Сообщение: Re: could not rename xlog (was: BUG #2712)
Следующее
От: "Thomas H."
Дата:
Сообщение: Re: could not rename xlog (was: BUG #2712)