DB2 - Problembeschreibung
Problem IT07116 | Status: Geschlossen |
BLOBS ARE NOT HANDLED CORRECTLY WHEN FETCHING THE DATA FROM CURSORS OPENED WHEN CALLING THE PROCEDURE. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
Blob columns are not handled correctly in the output of queries called from inside procedures CLP example below can be used to reproduce the bug: create table myTable (blobCol blob(10)); insert into myTable values (blob(x'1122334455')), (blob(x'112233')), (blob(x'11')), (blob(x'667788')), (blob(x'66')), (blob(x'AABBCCDDEEFF')), (blob(x'AABBCC')); create or replace procedure myProc() dynamic result sets 1 begin declare txt varchar(30) default 'select blobCol from myTable' ;-- declare cur cursor with return to client for stmt ;-- prepare stmt from txt ;-- open cur ;-- end ; -- call query from inside procedure => wrong results call myProc(); Result set 1 -------------- BLOBCOL ------------------------------------------- x'1122334455' x'112233'455' x'11'233'455' x'667788'455' x'66'788'455' x'AABBCCDDEEFF' x'AABBCC'DEEFF' 7 record(s) selected. Return Status = 0 -- expected results from same query select blobCol from myTable; BLOBCOL ----------------------- x'1122334455' x'112233' x'11' x'667788' x'66' x'AABBCCDDEEFF' x'AABBCC' 7 record(s) selected. drop table myTable; | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * DB2 CLP users using db2 V10.1 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 V10.1.5 and later * **************************************************************** | |
Local-Fix: | |
Lösung | |
Problem fixed from DB2 V10.1.5 onwards | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 12.02.2015 13.07.2015 13.07.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.5 |