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.
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? |
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? |