Re: [BUGS] BUG #7850: left outer join is not working or I didn't contruct the query properly

Tuesday, February 05, 2013 12:40 PM nvardar wrote:
> 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.

Why the query is different in Exception?
Can you try with
SELECT
tbl.id,
tbl.day,
tbl.week,
tbl.appfailure,
tbl.appname,
tbl.deviceid,
ext6.DIM_NAME,
tbl.starttime
FROM
APPSTARTEVT tbl
left outer join DIM_deviceMakeModel ext6 on
(ext6.DIM_ID=tbl.devicemakemodel)
ORDER BY tbl.id ASC

Also as Pavel has pointed, send this to General mailing list.

With Regards,
Amit Kapila.