|
Problem IT09614
|
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 / A50 - 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 *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 10.5 Fix Pack 7 *
**************************************************************** |
| Local-Fix: |
Apply this fix or change to use single byte underscore. |
| Lösung |
The problem is first fixed in DB2 version 10.5 Fix Pack 7 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 23.06.2015
19.01.2016
27.04.2016 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.5.0.7
|
 |
