The following bug has been logged on the website:
Bug reference: 7850
Logged by: Nadir Vardar
Email address: [email protected]
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=tbl.devicemakemodel)
left outer join DIM_devicePlatformType ext7 on
(ext7.DIM_ID=tbl.deviceplatformtype)
left outer join DIM_deviceVersion ext8 on
(ext8.DIM_ID=tbl.deviceversion)
left outer join DIM_operator ext9 on (ext9.DIM_ID=tbl.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" =
"TMPTT6624_1"."deviceplatformtype") WHERE "ext7"."dim_id" IS NULL
Line: 1
[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=ext6.DIM_ID AND tbl.deviceplatformtype=ext7.DIM_ID
AND tbl.deviceversion=
ext8.DIM_ID AND tbl.operator=ext9.DIM_ID
ORDER BY
tbl.id ASC
works btw...
Thanks.
--
Sent via pgsql-bugs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
