home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IT09419 Status: Geschlossen

INCORRECT RESULT WHEN QUERY HAS LEFT OUTER JOIN AND UNION ALL

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
A query might return incorrect query result when it has all the 
following characteristics: 
- The query has a UNION ALL query block, e.g. (select * from 
table1 UNION ALL select * from table2), called uaSubQ. 
- The query has LEFT OUTER JOIN query block, whose row 
preserving side includes base table(s) and null producing side 
is uaSubQ, e.g.  (select ... from table3 LEFT OUTER JOIN uaSubQ 
on ... where <predUaT3>) , called lojSubQ. 
- <predUaT3> is a comparison predicate, which references 
column(s) from both uaSubQ and table3. The predicate expression 
consists of CASE expression that has WHEN clause predicate, 
which tests if the null producing side column is null, e.g. 
"WHEN uaSubQ.column IS NULL". 
 
To find whether a query hits this problem, you can generate 
db2exfmt plan and search if "ROWNUMBER" OnLine Analytical 
Processing (OLAP) function is present in the optimized statement 
section.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.5 and Fix Pack 7                   * 
****************************************************************
Local-Fix:
Compile query at optimization level 0 or 1.
Lösung
Problem was first fixed in DB2 Version 10.5 and Fix Pack 7
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
11.06.2015
20.01.2016
11.07.2016
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.7 FixList