DB2 - Problembeschreibung
Problem IT26009 | Status: Geschlossen |
COLUMNAR ONLY: POSSIBLE WRONG RESULT IN EQUALITY JOIN WHEN COMPARING ZERO BINARY FLOATING POINT VALUE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problembeschreibung: | |
Prerequisites: - PowerPC platform - Equality join executed in Columnar Logic (under CTQ in the plan, for example) - Unary minus used on join predicate on a REAL or DOUBLE value and value is 0.0 Sample: create table state(floatnr double, state varchar(20)) organize by column; insert into state values(+0.0, 'CALIFORNIA'); insert into state values(+1.0, 'TEXAS'); insert into state values(+2.0, 'OREGON'); insert into state values(+3.0, 'FLORIDA'); SELECT Y.FLOATNR, Y.STATE FROM STATE Y, STATE X WHERE X.FLOATNR = -Y.FLOATNR; FLOATNR STATE ------------------------ -------------------- 0 record(s) selected. Expected result: FLOATNR STATE ------------------------ -------------------- +0.00000000000000E+000 CALIFORNIA 1 record(s) selected. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1 Mod 4 Fixpack 4 or higher * **************************************************************** | |
Local-Fix: | |
db2set DB2_CDE_HW_SIMD=13 | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 19.08.2018 27.11.2018 27.11.2018 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version |