DB2 - Problembeschreibung
Problem IC63538 | Status: Geschlossen |
WRONG RESULTS OR ERROR SQL0802 WITH FUNCTION SYSIBM.POWER WHERE SECOND ARGUMENT IS NULL | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
The result of function SYSIBM.POWER is supposed to be NULL is any of it's input arguments is NULL. SYSIBM.POWER will either return wrong results or error SQL0802 if the second argument is NULL. e.g.: db2 "values(power(10,cast(NULL as integer)))" 1 ----------- 1 db2 "values(power(10,cast(NULL as decimal(5,1))))" 1 ------------------------ +1.00000000000000E+140 db2 "values(power(10,cast(NULL as decimal)))" 1 ------------------------ SQL0802N Arithmetic overflow or other arithmetic exception occurred. SQLSTATE=22003 This APAR addresses this issue and ensures correct results when using function SYSIBM.POWER. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * The result of function SYSIBM.POWER is supposed to be NULL * * is * * any of it's input arguments is NULL. * * * * * * * * SYSIBM.POWER will either return wrong results or error * * SQL0802 * * if the second argument is NULL. * * * * e.g.: * * * * * * * * db2 "values(power(10,cast(NULL as integer)))" * * * * * * * * 1 * * * * ----------- * * * * 1 * * * * * * * * * * * * * * * * db2 "values(power(10,cast(NULL as decimal(5,1))))" * * * * * * * * 1 * * * * ------------------------ * * * * +1.00000000000000E+140 * * * * * * * * * * * * * * * * db2 "values(power(10,cast(NULL as decimal)))" * * * * * * * * 1 * * * * ------------------------ * * * * SQL0802N Arithmetic overflow or other arithmetic exception * * * * occurred. * * * * SQLSTATE=22003 * * * * * * * * * * * * This APAR addresses this issue and ensures correct results * * when * * using function SYSIBM.POWER. * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 9.7 FP2 * **************************************************************** | |
Local-Fix: | |
Use SYSFUN.POWER as a workaround. | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows | |
Lösung | |
first fixed in 9.7 FP2 (Signature: 9.7.0.2; Build level: s100514) | |
Workaround | |
Use SYSFUN.POWER as a workaround. | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 02.10.2009 31.05.2010 31.05.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.0.2, 9.7.FP2 | |
Problem behoben lt. FixList in der Version | |
9.7.0.2 |