DB2 - Problembeschreibung
Problem IC63207 | Status: Geschlossen |
WRONG RESULTS WITH LIKE EXPRESSION USING '^' (CIRCUMFLEX ACCENT)AND LANGUAGE AWARE COLLATION SEQUENCE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
In a unicode database which was created with a "language aware collation" sequence, like "UCA500R1_LROOT_AN_CX_EX_FX_HX_NX_S2" we may see wrong results with pattern matching during a expression using LIKE and the character "^" (CIRCUMFLEX ACCENT). For example the following query retruns wrong result: db2 select case when '^' like '^' then 1 else 0 end from sysibm.sysdummy1 1 ----------- 0 This does not happen with the default collating sequence (IDENTITY). | |
Problem-Zusammenfassung: | |
Users Affected: ALL Problem Description: In a unicode database which was created with a "language aware collation" sequence, like "UCA500R1_LROOT_AN_CX_EX_FX_HX_NX_S2" we may see wrong results with pattern matching during a expression using LIKE and the character "^" (CIRCUMFLEX ACCENT). For example the following query retruns wrong result: db2 select case when '^' like '^' then 1 else 0 end from sysibm.sysdummy1 1 ----------- 0 This does not happen with the default collating sequence (IDENTITY). Problem Summary: In a unicode database which was created with a "language aware collation" sequence, like "UCA500R1_LROOT_AN_CX_EX_FX_HX_NX_S2" we may see wrong results with pattern matching during a expression using LIKE and the character "^" (CIRCUMFLEX ACCENT). For example the following query retruns wrong result: db2 select case when '^' like '^' then 1 else 0 end from sysibm.sysdummy1 1 ----------- 0 This does not happen with the default collating sequence (IDENTITY). | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows | |
Lösung | |
First fixed in DB2 UDB Version 9.5, FixPak 5 (build s091123) | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 17.09.2009 15.12.2009 16.06.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5. | |
Problem behoben lt. FixList in der Version | |
9.5.0.5 |