|
Problem IC98117
|
Status: Closed |
COLLATION_KEY_BIT MIGHT GENERATE EMPTY STRINGS IN ORACLE MODE IF INPUT STRING CONSISTS OF BLANKS |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
The COLLATION_KEY_BIT function might generate empty strings
while running in Oracle mode if the input string consists of
nothing but one or more blank characters. In Oracle there is no
concept of an empty string. Instead of an empty string,
the COLLATION_KEY_BIT function should return NULL. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 9.7.0.10. *
**************************************************************** |
| Local Fix: |
Avoid using the COLLATION_KEY_BIT function on blank input
strings while running in Oracle mode. |
| Solution |
The problem is first fixed in DB2 version 9.7.0.10. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 04.12.2013
06.11.2014
07.04.2015 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.0.10
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.10
|
 |
