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.