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) |