|
Problem IT16271
|
Status: Geschlossen |
JOIN-CONDITION RETURNS SQLCODE -338 WHEN TABLE FROM IMPLICIT CROSS JOIN IS REFERENCED |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problembeschreibung: |
Description: The following join-condition results in SQLCODE
-338 during query compilation:
select * from T1, T2 inner join T3 on T3.C1=T1.C1
SQL0338N An ON clause associated with a JOIN operator or in
a MERGE statement |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 11.1 fix pack 1 *
**************************************************************** |
| Local-Fix: |
Change the implicit cross join to an explicit cross join, i.e:
select * from T1 CROSS JOIN T2 inner join T3 on T3.C1=T1.C1 |
| verfügbare FixPacks: |
DB2 Version 11.1 Mod1 Fix Pack1 iFix001 for Linux, UNIX, and Windows
DB2 Version 11.1 Mod 2 Fix Pack 2 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
|
| Lösung |
First fixed in DB2 version 11.1 fix pack 1 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 25.07.2016
08.05.2017
08.05.2017 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 11.1.1.1
|
 |
