Lists: | pgsql-bugs |
---|
From: | "JEAN-PIERRE PELLETIER" <pelletier_32(at)sympatico(dot)ca> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | ERROR: failed to build any 4-way joins SQL state: XX000, PostgreSQL 8.2 beta1 |
Date: | 2006-10-24 15:27:14 |
Message-ID: | BAY118-F21F664BEEA514B5150A21295010@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | 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
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "JEAN-PIERRE PELLETIER" <pelletier_32(at)sympatico(dot)ca> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: ERROR: failed to build any 4-way joins SQL state: XX000, PostgreSQL 8.2 beta1 |
Date: | 2006-10-24 17:51:31 |
Message-ID: | 21640.1161712291@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
"JEAN-PIERRE PELLETIER" <pelletier_32(at)sympatico(dot)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
From: | "JEAN-PIERRE PELLETIER" <pelletier_32(at)sympatico(dot)ca> |
---|---|
To: | tgl(at)sss(dot)pgh(dot)pa(dot)us |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: ERROR: failed to build any 4-way joins SQL state: XX000, PostgreSQL |
Date: | 2006-11-08 15:00:57 |
Message-ID: | BAY118-F14A24C5980EEB672DDBD3D95F10@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
This is just to confirm that 8.2 beta3 fixes that problem.
Thanks again,
Jean-Pierre Pelletier
>From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
>To: "JEAN-PIERRE PELLETIER" <pelletier_32(at)sympatico(dot)ca>
>CC: pgsql-bugs(at)postgresql(dot)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(at)sympatico(dot)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