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

Started by Jean-Pierre Pelletierover 19 years ago3 messagesbugs
Jump to latest
#1Jean-Pierre Pelletier
pelletier_32@sympatico.ca

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Jean-Pierre Pelletier (#1)
Re: ERROR: failed to build any 4-way joins SQL state: XX000, PostgreSQL 8.2 beta1

"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

#3Jean-Pierre Pelletier
pelletier_32@sympatico.ca
In reply to: Tom Lane (#2)
Re: ERROR: failed to build any 4-way joins SQL state: XX000, PostgreSQL

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