suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT23694 Status: Closed

THE EXPLANATION FOR SQL0338N NEEDS AN UPDATE AFTER THE ENHANCEMENT MADE
SINCE 10.1 TO ALLOW SUBQUERIES IN AN ON CLAUSE

product:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problem description:
## Problem description
The Explanation for SQL0338N needs to be updated after an
enhancement has been made since 10.1 to allow subqueries in an
ON clause under some circumstances.

## How to reproduce the problem
The following query returns SQL0338N in 9.7, but succeeds in
10.1 onward.
It's because there is an enhancement made since 10.1. The
explanation of SQL0338N in 10.1 onward is still the same as in
9.7 and therefore a bit misleading to the user.
----------------------------------
CREATE TABLE TEST01(C1 INTEGER);
CREATE TABLE TEST02(C1 INTEGER);
CREATE TABLE TEST03(C1 INTEGER);

INSERT INTO TEST01 VALUES(1);
INSERT INTO TEST02 VALUES(1);
INSERT INTO TEST03 VALUES(1);

SELECT *
FROM TEST01 T1
LEFT OUTER JOIN TEST02 T2
ON T1.C1 = T2.C1
AND T2.C1 = (SELECT C1 FROM TEST03);
----------------------------------
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 version 10.5 fix pack 10                      *
****************************************************************
Local Fix:
Solution
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : 
follow-up : IT24702 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
11.01.2018
18.07.2018
18.07.2018
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)