From: | "canli" <canli(at)wp(dot)pl> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #2837: i received ERROR: failed to build any 7-way joins |
Date: | 2006-12-18 10:00:07 |
Message-ID: | 200612181000.kBIA078N093218@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2006-12-18 15:52:52 | Re: BUG #2830: Wrong results for prepared statements |
Previous Message | Albert Cervera i Areny | 2006-12-18 09:49:29 | BUG #2836: SPI_execute_plan failed on pl/pgsql function that worked on 8.1 |