home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IT09606 Status: Geschlossen

SELECT ON XML USING FN:UPPER-CASE & TABLE HAS AN INDEX CAN RETURN
INCORRECT RESULTS

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
SELECT on XML table using fn:upper-case can return incorrect 
results when the table has an XML index. 
 
If you have the following conditions: 
 
- Table with XML Column 
- Index on this XML column and does not contain the upper-case 
function in the path 
- SELECT statement that has where condition on the XML column 
that uses fn:upper-case 
 
For example, 
 
db2 -v "create table myXMLtable(id int, XMLcol XML)" 
db2 -v "insert into myXMLtable values 
(1,'<AddProtQuoteResponse><surname>Griffin</surname><test>test1< 
/test></AddProtQuoteResponse>')" 
db2 -v "select t.id, x.surname,x.surname1 from myXMLtable t, 
xmltable (xmlnamespaces('http://www.example.org/DataTypeTest' as 
\"inter\"), '\$i/*:AddProtQuoteResponse' passing t.XMLcol AS 
\"i\" columns surname varchar(15) path 'surname', surname1 
varchar(15) path 'surname/fn:upper-case(.)') as x where 
x.surname1 = 'GRIFFIN'"; 
db2 -v "CREATE INDEX TSTIDX ON myXMLtable (XMLcol ASC) GENERATE 
KEY USING XMLPATTERN '/*:AddProtQuoteResponse/surname' AS SQL 
VARCHAR (255)" 
db2 -v "select t.id, x.surname,x.surname1 from myXMLtable t, 
xmltable (xmlnamespaces('http://www.example.org/DataTypeTest' as 
\"inter\"), '\$i/*:AddProtQuoteResponse' passing t.XMLcol AS 
\"i\" columns surname varchar(15) path 'surname', surname1 
varchar(15) path 'surname/fn:upper-case(.)') as x where 
x.surname1 = 'GRIFFIN'";
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 10.1.0.5.                             * 
****************************************************************
Local-Fix:
Lösung
The problem is first fixed in DB2 version 10.1.0.5.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
23.06.2015
10.07.2015
10.07.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.5 FixList