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;
>=20
> 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
>=20
> throws;
>=20
> >[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
>=20
>  [Executed: 2/4/13 11:07:08 PM PST ] [Execution: 0/ms]
>=20
>=20
> exception.
>=20
> Is there anything i am missing.

Why the query is different in Exception?
Can you try with=20
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=3Dtbl.devicemakemodel)
    ORDER BY   tbl.id ASC

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

With Regards,
Amit Kapila.