ERROR: failed to build any 4-way joins SQL state: XX000, PostgreSQL 8.2 beta1
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
"JEAN-PIERRE PELLETIER" <pelletier_32@sympatico.ca> writes:
I have a query that throws "ERROR: failed to build any 4-way joins
Fixed --- thanks for the report! (This didn't make beta2, but will
be in the next one.)
regards, tom lane
This is just to confirm that 8.2 beta3 fixes that problem.
Thanks again,
Jean-Pierre Pelletier
Show quoted text
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "JEAN-PIERRE PELLETIER" <pelletier_32@sympatico.ca>
CC: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] ERROR: failed to build any 4-way joins SQL state:
XX000, PostgreSQL 8.2 beta1 Date: Tue, 24 Oct 2006 13:51:31 -0400"JEAN-PIERRE PELLETIER" <pelletier_32@sympatico.ca> writes:
I have a query that throws "ERROR: failed to build any 4-way joins
Fixed --- thanks for the report! (This didn't make beta2, but will
be in the next one.)regards, tom lane