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

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

From
"JEAN-PIERRE PELLETIER"
Date:
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

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

From
"JEAN-PIERRE PELLETIER"
Date:
This is just to confirm that 8.2 beta3 fixes that problem.

Thanks again,
Jean-Pierre Pelletier

>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