|
Problem IT08235
|
Status: Geschlossen |
INCORRECT RESULT COULD BE RETURNED WHEN USING FULLWIDTH UNDER- SCORE CHARACTER (X'EFBCBF') IN LIKE PREDICATE AGAINST CLOB DATA |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problembeschreibung: |
Sometimes extra rows that do not qualify might be returned. This
occurs when you use the fullwidth underscore character X'EFBCBF'
in the LIKE predicate to match the CLOB datatype in the CLOB
columns against Unicode databases, and the data's length is less
than the pattern's length. This is because the fullwidth
underscore character is 3 bytes. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All users of Unicode databases *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 10.1.0.5. *
**************************************************************** |
| Local-Fix: |
Apply this fix or change to use single byte underscore. |
| 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:
| 10.04.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
|
 |
