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