DB2 - Problem description
Problem IT29415 | Status: Closed |
SCALAR FUNCTION HASH8 MAY RETURN DIFFERENT RESULTS FOR THE SAME INPUT ON POWER(TM) LITTLE ENDIAN SYSTEMS | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
Scalar function HASH8 may return different results for the same input on POWER(TM) little endian systems. When the input to the HASH8 function is not an integral multiple of 4 bytes long, repeated invocations of the function for the same input may produce different output hash values. This affects Db2 running on POWER(TM) little endian Linux systems only. e.g. $ db2 "select v,hash8(v) hashvalue from hash8_test" V HASHVALUE ----------------- -------------------- 2T2GK31U09C059690 -8079510515070948960 YV440MDK2G2809791 -3052657120253964598 2 record(s) selected. $ db2 "select v,hash8(v) hashvalue from hash8_test" V HASHVALUE ----------------- -------------------- 2T2GK31U09C059690 -7493176833262375329 YV440MDK2G2809791 3488698275826922457 2 record(s) selected. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 11.06.2019 16.01.2020 16.01.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |