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

Поиск
Список
Период
Сортировка
От canli
Тема BUG #2837: i received ERROR: failed to build any 7-way joins
Дата
Msg-id 200612181000.kBIA078N093218@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #2837: i received ERROR: failed to build any 7-way joins  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Дерево обсуждения 
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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "Albert Cervera i Areny"
Дата:
Сообщение: BUG #2836: SPI_execute_plan failed on pl/pgsql function that worked on 8.1
Следующее
От: "Thomas Jahnsen"
Дата:
Сообщение: BUG #2838: Compile error "tab-complete.c" on Mac OS X