From: | "Sergey" <for(dot)adv(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #2862: ERROR: failed to build any 7-way joins |
Date: | 2006-12-23 12:46:17 |
Message-ID: | 200612231246.kBNCkH9J067639@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: 2862
Logged by: Sergey
Email address: for(dot)adv(at)gmail(dot)com
PostgreSQL version: 8.2.0-1
Operating system: Windows XP Pro SP2
Description: ERROR: failed to build any 7-way joins
Details:
After migrating to 8.2 I received an error:
ERROR: failed to build any 7-way joins
SQL state: XX000
STATEMENT: select * from v_well_main w LEFT OUTER JOIN v_state_main s ON
(w."Id_well"=s."Id_wl") LEFT OUTER JOIN v_expl_main e ON
(w."Id_well"=e."Id_wl") where w."Id_dep"=7
View v_well_main contained statement:
SELECT w."Id_well", w."Name_wl", w."Num", w."Cod", c."Name" AS
"Categor_name", w."Inv_num", w."Balance", w."Obl", w."Reg", w."Sl_rada",
w."Latitude_deg", w."Latitude_min", w."Latitude_sec", w."Longitude_deg",
w."Longitude_min", w."Longitude_sec", w."Topograf_note", w."Passp_org",
w."Passp_date", w."Executor", w."Exec_phone", w."Director", w."Al_rotor",
w."Al_gr", w."dP", o."Id_org", o."Name", o."Address", o."EDRPOU", o."Phone",
b."Name" AS name_obl, b."KOATUU" AS obl_koatuu, r."Name" AS name_raj,
r."KOATUU" AS raj_koatuu, s."Name" AS sl, v."Id_dep", v."Name_dep", v."Typ",
v.obj_typ, v."Begin", v."End"
FROM v_well_obj v, "Categor_dic" c, "Well" w
LEFT JOIN "Obl_dic" b ON w."Obl" = b."Id_obl"
LEFT JOIN "Raj_dic" r ON w."Reg" = r."Id_raj"
LEFT JOIN "Sl_rad_dic" s ON w."Sl_rada" = s."Id_s"
LEFT JOIN "Org_dic" o ON w."Passp_org" = o."Id_org"
WHERE v."Id_well" = w."Id_well" AND c."Id_cat" = w."Categor"
ORDER BY w."Num";
The query was executed in pgAdmin III
If STATEMENT change to:
select * from v_well_main w where w."Id_dep"=113
then it executed OK
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Locke | 2006-12-23 13:10:53 | BUG #2863: vacuum failing, weird record in table... |
Previous Message | goodsforyou | 2006-12-23 03:53:46 | BUG #2861: when backup UTF-8 database, pgdump add comments not encoded in UTF-8 |