dbTalk Databases Forums  

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

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] BUG #2837: i received ERROR: failed to build any 7-way joins in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
canli
 
Posts: n/a

Default [BUGS] BUG #2837: i received ERROR: failed to build any 7-way joins - 12-18-2006 , 04:24 PM







The following bug has been logged online:

Bug reference: 2837
Logged by: canli
Email address: canli (AT) wp (DOT) 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

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.