|
Problem IC65784
|
Status: Geschlossen |
SYSTEM MODULE ROUTINE DBMS_LOB.COMPARE() WITH INVALID OFFSET ARG UMENT MAY INCORRECTLY RETURN A RESULT INSTEAD OF GIVING SQL0138. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
The system module routine DBMS_LOB.COMPARE(...) is used to
compare two large objects. An optional argument to the routine
is to provide a offset for either of the input large objects to
use as the starting point for the comparison.
If the user inputs an offset value that is larger than the
length of
the input large object, then this is invalid input and an
SQL0138 should be returned. However, because of this defect, it
may not detect this situation and instead the routine would
return a -1,0, or 1 return code.
The fix for the issue will ensure that SQL0138 is properly given
if the input argument for the offset exceeds the length of the
input large object. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* Users Affected: All *
****************************************************************
* PROBLEM DESCRIPTION: *
* Problem description:SYSTEM MODULE ROUTINE DBMS_LOB.COMPARE() *
* WITH INVALID OFFSETARGUMENT MAY INCORRECTLY RETURN A RESULT *
* INSTEAD OF GIVINGSQL0138. *
****************************************************************
* RECOMMENDATION: *
* install v97 fp2 *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
fix contained in v97fp2 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 22.01.2010
12.07.2010
12.07.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP2
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.2
|
 |
