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

"<TIMESTAMP_COLUMN> + <DECIMAL_COLUMN> SECONDS" MIGHT
PRODUCE INCORRECT RESULTS IN COLUMN-ORGANIZED TABLES

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
Selecting "<TIMESTAMP_COLUMN> + <DECIMAL_COLUMN> SECONDS" from a 
column-organized table might produce incorrect results for rows 
with <DECIMAL_COLUMN> < 0 and <DECIMAL_COLUMN> > -1.  For 
example, the following SQL statements return a value of 
2014-01-01-12.00.01.900000 when it should return a value of 
'2014-01-01-11.59.59.900000'. 
 
create table t1 (t1 timestamp, d2 decimal(10,5)) organize by 
column; 
insert into t1 values ('2014-01-01-12.00.00', -0.1); 
select t1 + d2 seconds from t1;
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 10.5.0.5.                             * 
****************************************************************
Local-Fix:
Lösung
The problem is first fixed in DB2 version 10.5.0.5.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
16.09.2014
13.03.2015
09.04.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.5 FixList