DB2 - Problembeschreibung
Problem IC98117 | Status: Geschlossen |
COLLATION_KEY_BIT MIGHT GENERATE EMPTY STRINGS IN ORACLE MODE IF INPUT STRING CONSISTS OF BLANKS | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * 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. | |
Lösung | |
The problem is first fixed in DB2 version 9.7.0.10. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 04.12.2013 06.11.2014 07.04.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.0.10 | |
Problem behoben lt. FixList in der Version | |
9.7.0.10 |