|
Problem IT38969
|
Status: Closed |
WRONG STRING COMPARISON FOR THAI NLSCHAR DATABASE COULD HAPPEN
|
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
In the database created with this codepage and collation
NLSCHAR:
create db USING CODESET TIS620-1 TERRITORY TH COLLATE
USING NLSCHAR
Incorrect comparison between char strings could happen.
It can also lead to bad order.
Indexes could be affected. Please use 'db2dart ' to
identify any
affected indexes.
After this fix is installed all affected indexes need to be
recreated. Indexes can also be rebuilt using REORG INDEXES.
Example of the problem issue:
create table test1 (c1 char(50),c2 char(50));
insert into test1 values
(
x'E0202020202020202020202020202020202020202020202020202020202020
20202020202020202020202020202020202020',
x'E0FB2020202020202020202020202020202020202020202020202020202020
20202020202020202020202020202020202020'
);
insert into test1 values
(
x'E0FB2020202020202020202020202020202020202020202020202020202020
20202020202020202020202020202020202020',
x'E0202020202020202020202020202020202020202020202020202020202020
20202020202020202020202020202020202020'
);
and one see different ordering with c1 and c2:
db2 "select hex(c1) from test1 order by c1"
1
----------------------------------------------------------------
------------------------------------
E020202020202020202020202020202020202020202020202020202020202020
202020202020202020202020202020202020
E0FB202020202020202020202020202020202020202020202020202020202020
202020202020202020202020202020202020
2 record(s) selected.
db2 "select hex(c2) from test1 order by c2"
1
----------------------------------------------------------------
------------------------------------
E0FB202020202020202020202020202020202020202020202020202020202020
202020202020202020202020202020202020
E020202020202020202020202020202020202020202020202020202020202020
202020202020202020202020202020202020
2 record(s) selected. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* THAI NLSCHAR DATABASE only *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description, install this fix *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 11.1.4.7 *
**************************************************************** |
| Local Fix: |
N/A
Please, install this fix and re-create indexes affected. |
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* THAI NLSCHAR DATABASE only *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description, install this fix *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 11.1.4.7 *
**************************************************************** |
| Comment |
Upgrade to 11.1.4.7 |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 04.11.2021
17.04.2022
20.04.2022 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
