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

Hello

this is not a bug report.

please, send your query to pg_general mailing list

probably better - ask on gridsql mailing list

Regards

Pavel Stehule

2013/2/5 <nvardar(at)carrieriq(dot)com>:
> The following bug has been logged on the website:
>
> Bug reference: 7850
> Logged by: Nadir Vardar
> Email address: nvardar(at)carrieriq(dot)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=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 (pgsql-bugs(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs