DB2 FOR LUW / DB2FORLUW / 950 - DB2

When a XML schema contains boundary facets that have different 
representations of the number zero, DB2 schema registration 
fails with SQL16157N.  When an XML instance is validated 
againsta schema which requires comparison between 0, 0.0 or 
-0.0, validation fails with SQL16210N. 
 
Example 1: the following schema will fail to register 
because the facets minInclusive and minExclusive have three 
different representations for the value zero (0, 0.0 and 
-0.0). 
 
--schema 
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"> 
 
<xs:simpleType name="baseType"> 
<xs:restriction base="xs:decimal"> 
<xs:minInclusive value="0.0" /> 
</xs:restriction> 
</xs:simpleType> 
 
<xs:simpleType name="restrictedTypeGTZero"> 
<xs:restriction base="baseType"> 
<xs:minExclusive value="0" /> 
</xs:restriction> 
</xs:simpleType> 
 
<xs:simpleType name="restrictedTypeGTNegativeFractionalZero"> 
<xs:restriction base="baseType"> 
<xs:minExclusive value="-0.0" /> 
</xs:restriction> 
</xs:simpleType> 
 
<xs:element name="decimalGreaterThanZero" 
type="restrictedTypeGTZero" /> 
<xs:element name="decimalGreaterThanNegativeFractionalZero" 
type="restrictedTypeGTNegativeFractionalZero" /> 
 
</xs:schema> 
 
Example 2: the following XML instance will fail to validate 
against the following schema because the XML instance 
represents the number zero differently than the schema (0 vs 
0.0). 
 
--xml instance 
<decimalGreaterThanOrEquealFractionalZero>0</decimalGreaterThanO 
rEquealFractionalZero> 
 
 
--schema 
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"> 
 
<xs:simpleType name="baseType"> 
<xs:restriction base="xs:decimal"> 
<xs:minInclusive value="0.0" /> 
</xs:restriction> 
</xs:simpleType> 
 
<xs:element name="decimalGreaterThanOrEquealFractionalZero" 
type="baseType" /> 
 
</xs:schema>

To avoid any comparison between 0, 0.0 and -0.0, consistently 
 
use only one representation of the number zero (0, 0.0 or 
-0.0) in the XML schemas and XML instances.

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
 

keiner bekannt / siehe Local-Fix

SCHEMA REGISTRATION FAILS WITH SQL16157N WHEN XML SCHEMA 
INVOLVES ANY COMPARISON BETWEEN 0,0.0 OR -0.0

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

25.06.2009
25.02.2010
25.02.2010