Thread: 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

>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