BUG #2837: i received ERROR: failed to build any 7-way joins

Started by canliover 19 years ago2 messagesbugs
Jump to latest
#1canli
canli@wp.pl

The following bug has been logged online:

Bug reference: 2837
Logged by: canli
Email address: canli@wp.pl
PostgreSQL version: 8.2.0
Operating system: Linux ES 4
Description: i received ERROR: failed to build any 7-way joins
Details:

When I execute a query:

SELECT n1.numer AS wydany_nr, n2.numer AS zwrocony_nr FROM operacje o LEFT
JOIN (wydane_numery wt1 JOIN boki_
numery bn1 USING(id_nr_w_bok) JOIN numery n1 USING(id_numeru ))
ON(wt1.id_operacji = o.id_operacji AND wt1.wydanie_zwrot = 'W') LEFT JOIN
(wydane_numery wt2
JOIN boki_numery bn2 USING(id_nr_w_bok) JOIN numery n2 USING(id_numeru ))
ON(wt2.id_operacji = o.id_operacji AND wt2.wydanie_zwrot = 'Z') WHERE
o.id_operacji
= 349736

i received an error: failed to build any 7-way joins

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: canli (#1)
Re: BUG #2837: i received ERROR: failed to build any 7-way joins

"canli" <canli@wp.pl> writes:

i received an error: failed to build any 7-way joins

I think this is the same problem already reported here:
http://archives.postgresql.org/pgsql-bugs/2006-12/msg00092.php
and patched here:
http://archives.postgresql.org/pgsql-committers/2006-12/msg00102.php

regards, tom lane