|
Problem IT08133
|
Status: Geschlossen |
CONCAT IN ORA MODE WITH NULL CLOB TYPES WILL RETURN NULL WHEN THE OTHER VALUE IS NOT NULL |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problembeschreibung: |
The official document recorded that in ORA mode for CONCAT
function and the concatenation operator, A null or empty string
value is ignored in the concatenated result.
http://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.
ibm.db2.luw.apdv.porting.doc/doc/r0052880.html?lang=en
This works fine for literals, but not for column values, the
CONCAT will return NULL. Please see the following detailed test
=> db2 "values cast('xyz' as clob(10))|| cast(null as clob(10))"
1
----------
xyz
1 record(s) selected.
VS
==> db2 "create table ken_clob(col1 integer,clob_col clob)"
==> db2 "insert into ken_clob (col1) values (1)"
==> db2 "insert into ken_clob values (2,'123')"
==>db2 "SELECT CONCAT(clob_col, '123') FROM ken_clob"
------------
- <- The offender
123123
2 record(s) selected. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* Wrong results *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to latest v10.5fp7 *
**************************************************************** |
| Local-Fix: |
|
| Lösung |
|
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 03.04.2015
19.01.2016
19.01.2016 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.5.0.7
|
 |
