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

From: nvardar(at)carrieriq(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #7850: left outer join is not working or I didn't contruct the query properly
Date: 2013-02-05 07:09:40
Message-ID: E1U2cey-0004DC-QS@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-general

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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message luberti 2013-02-05 10:45:51 BUG #7851: Installer crash with message: An error occured executing the Microsoft VC++ runtimeinstaller
Previous Message Kevin Grittner 2013-02-04 21:05:28 Re: BUG #7846: Documentation: Should FOUND be documented as an output of UPDATE statement?

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2013-02-05 08:59:54 Re: DEFERRABLE NOT NULL constraint
Previous Message Pavel Stehule 2013-02-05 06:56:05 Re: What language is faster, C or PL/PgSQL?