|
Problem IC63537
|
Status: Geschlossen |
WRONG RESULTS OR ERROR SQL0802 WITH FUNCTION SYSIBM.POWER WHERE SECOND ARGUMENT IS NULL |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 950 - 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 *
* NULLisany of it's input arguments is NULL.SYSIBM.POWER will *
* either return wrong results or errorSQL0802if the second *
* argument is NULL.e.g.:db2 "values(power(10,cast(NULL as *
* integer)))"1-----------1db2 "values(power(10,cast(NULL as *
* decimal(5,1))))"1------------------------+1.00000000000000E+14
* "values(power(10,cast(NULL as *
* decimal)))"1------------------------SQL0802N Arithmetic *
* overflow or other arithmetic *
* exceptionoccurred.SQLSTATE=22003This APAR addresses this *
* issue and ensures correct resultswhenusing function *
* SYSIBM.POWER. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 9.5 FP6 *
**************************************************************** |
| Local-Fix: |
Use SYSFUN.POWER as a workaround. |
| verfügbare FixPacks: |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
first fixed in DB2 V9.5 FP6 |
| Workaround |
Use SYSFUN.POWER as a workaround. |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC63538 IC65479
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 02.10.2009
22.06.2010
22.06.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.5.FP6
|
| Problem behoben lt. FixList in der Version |
