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

DB2 MIGHT PRODUCE INCORRECT RESULTS WHEN RUNNING QUERIES WITH EQUALITY
TIMESTAMP PREDICATES

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
DB2 might produce incorrect results when running queries with 
equality timestamp predicates 
Description: 
Under rare scenarios, DB2 might produce incorrect results if the 
following conditions are true: 
1) The query contains two or more subselects and tables 
2) Each of these have atleast one column of type TIMESTAMP with 
default precision 6 
3) One or more of these columns are projected out from the 
select 
4) The columns also contains an equality predicate with a string 
representation of timestamp 
 
eg. Select * 
       from T1, (Select TS 
                        from T2 
                        where T2.TS = '2015-01-01 00:00:00') as 
tmp 
       where T1.TS = '2015-01-01 00:00:00' and tmp.TS = 
'2015-01-01 00:00:00'
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* First fixed in v9.7 fp11                                     * 
****************************************************************
Local-Fix:
Workaround: 
1) Turn on statement concentrator 
2) Modify the query to introduce T1.TS = T2.TS predicate
Lösung
First fixed in v9.7 fp11
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
20.05.2015
21.10.2015
21.10.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP11
Problem behoben lt. FixList in der Version
9.7.0.11 FixList