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 IT01660 Status: Geschlossen

INCORRECT RESULTS MIGHT BE PRODUCED WITH PREDICATES INVOLVING NULL
CONSTANTS

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
Under rare scenarios, DB2 might produce an incorrect result if 
the following conditions are true: 
1) The query contains a NULL constant in predicate 
2) The predicate is of the form expression <relop> NULL where 
<relop> can be =,>=,<= 
3) The expression is either a CASE expression or a NULLIF 
function 
4) The output of the expression is guaranteed to be NULL 
 
eg. 
select * from t1 where NULLIF (c1, c1) >= Cast(NULL as int); 
select * from t1 where case when c1 = c1 then NULL else c1 end 
>= cast(NULL as BIGINT);
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 9.7.0.10.                             * 
****************************************************************
Local-Fix:
1) drop the redundant predicate 
2) Change the query optimization level to 0
Lösung
The problem is first fixed in DB2 version 9.7.0.10.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
08.05.2014
08.12.2014
21.04.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.0.10
Problem behoben lt. FixList in der Version
9.7.0.10 FixList