|
Problem IC61603
|
Status: Geschlossen |
XS:DOUBLE(<INPUT STRING>) RETUNS SQL0901N WHEN THE <INPUT STRING> TERMINATES WITH "+" OR "-", FOR EXAMPLE XS:DOUBLE("8E+") |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problembeschreibung: |
xs:double is returning a -901 system error for a malformed input
to xs:double() which is incorrect and very misleading to the
user.
Because 8E+ is not in a valid lexical representation for
xs:double (From the spec 3.2.5.1 Lexical representation
http://www.w3.org/TR/xmlschema-2/#double) we should be returning
the SQL16061N error below.
SQL16061N The value "" cannot be constructed as, or cast (using
an implicit
or explicit cast) to the data type "xs:double". Error
QName=err:FORG0001.
SQLSTATE=10608 |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* DB2 LUW All Platforms *
****************************************************************
* PROBLEM DESCRIPTION: *
* xs:double is returning a -901 system error for a malformed *
* input *
* to xs:double() which is incorrect and very misleading to the *
* user. *
* *
* Because 8E+ is not in a valid lexical representation for *
* xs:double (From the spec 3.2.5.1 Lexical representation *
* http://www.w3.org/TR/xmlschema-2/#double) we should be *
* returning *
* the SQL16061N error below. *
* *
* SQL16061N The value "" cannot be constructed as, or cast *
* (using *
* an implicit *
* or explicit cast) to the data type "xs:double". Error *
* QName=err:FORG0001. *
* SQLSTATE=10608 *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 v95 Fixpack 5. *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
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 |
The fix catches the malformed input and raises the correct
error. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 19.06.2009
19.02.2010
19.02.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.5.FP5
|
| Problem behoben lt. FixList in der Version |
| 9.5.0.5
|
 |
