|
Problem IC97851
|
Status: Closed |
INCORRECT RESULT IN UNICODE DB WITH LIKE PREDICATE AND FULLWIDTH UNDERSCORE WILD CHARACTER ON A CLOB COLUMN |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
In a unicode database, running a query might return incorrect
results if it contains a like predicate against a clob column,
and the pattern to match contains a fullwidth underscore wild
character (X'EFBCBF').
For example:
create table tbl1 ( id int, cclob20oct clob(20))
insert into tbl1 values (1, X'F094AE8041')
select id from tbl1 where cclob20oct like X'F094AE80EFBCBF'
ID
-----------
0 record(s) selected.
<-- incorrect result returns : the matching row is not returned.
Recall that the fullwidth underscore is a wildcard character.
See the Information Center for details. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* UTF-8 databases *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to 10.5.0.3 *
**************************************************************** |
| Local Fix: |
Use halfwidth underscore character (X'5F') instead of a
fullwidth underscore character (X'EFBCBF'). |
| available fix packs: |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Solution |
Problem Fixed In 10.5.0.3 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 21.11.2013
03.03.2014
07.04.2015 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.3
|
 |
| 10.5.0.3
|
|
