BUG #7850: left outer join is not working or I didn't contruct the query properly
От | nvardar@carrieriq.com |
---|---|
Тема | BUG #7850: left outer join is not working or I didn't contruct the query properly |
Дата | |
Msg-id | E1U2cey-0004DC-QS@wrigleys.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #7850: left outer join is not working or I didn't
contruct the query properly
Re: BUG #7850: left outer join is not working or I didn't contruct the query properly |
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 7850 Logged by: Nadir Vardar Email address: nvardar@carrieriq.com PostgreSQL version: 9.0.10 Operating system: linux-gridsql Description: = I am trying to run below query; SELECT tbl.id, tbl.day, tbl.week, tbl.appfailure, tbl.appname, tbl.deviceid, ext6.DIM_NAME, ext7.DIM_NAME, ext8.DIM_NAME, ext9.DIM_NAME, tbl.starttime FROM APPSTARTEVT tbl left outer join DIM_deviceMakeModel ext6 on (ext6.DIM_ID=3Dtbl.devicemakemodel) left outer join DIM_devicePlatformType ext7 on (ext7.DIM_ID=3Dtbl.deviceplatformtype) left outer join DIM_deviceVersion ext8 on (ext8.DIM_ID=3Dtbl.deviceversion) left outer join DIM_operator ext9 on (ext9.DIM_ID=3Dtbl.operator) = ORDER BY tbl.id ASC throws; >[Error] Script lines: 1-20 ------------------------- ERROR: Node 2 has aborted execution, cause is: com.edb.gridsql.exception.XDBServerException : java.lang.NullPointerException QUERY: SELECT "TMPTT6624_1"."deviceplatformtype" AS "deviceplatformtype","TMPTT6624_1"."XSERIALID0" AS "XSERIALID0","TMPTT6624_1"."XONODEID0" AS "XONODEID0" FROM "TMPTT6624_1" = LEFT OUTER JOIN "dim_deviceplatformtype" "ext7" ON ("ext7"."dim_id" =3D "TMPTT6624_1"."deviceplatformtype") WHERE "ext7"."dim_id" IS NULL Line: 1 =03 [Executed: 2/4/13 11:07:08 PM PST ] [Execution: 0/ms] = exception. Is there anything i am missing. Query; SELECT tbl.id, tbl.day, tbl.week, tbl.appfailure, tbl.appname, tbl.deviceid, ext6.DIM_NAME, ext7.DIM_NAME, ext8.DIM_NAME, ext9.DIM_NAME, tbl.starttime FROM APPSTARTEVT tbl, = DIM_deviceMakeModel ext6, DIM_devicePlatformType ext7, DIM_deviceVersion ext8, DIM_operator ext9 WHERE tbl.devicemakemodel=3Dext6.DIM_ID AND tbl.deviceplatformtype=3Dext7.DIM= _ID AND tbl.deviceversion=3D ext8.DIM_ID AND tbl.operator=3Dext9.DIM_ID ORDER BY tbl.id ASC works btw... Thanks.
В списке pgsql-bugs по дате отправления: