|
Problem IC62781
|
Status: Geschlossen |
INSTANCE MAY ABEND DURING COMPILATION OF A QUERY CONTAINING IMPL ICITLY EQUIVALENT COLUMNS AND A PREDICATE WITH AN EMPTY STRING |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
A query being compiled that has a local predicate (LOCPRD) with
an empty string literal, i.e., '', may cause the instance to
abend if the following conditions are satisfied:
1) The column (COMPCOL) in LOCPRD is equivalent to another
column (OTHCOL), e.g., via a join
2) OTHCOL is also involved in a local predicate (OTHLOCPRD)
3) LOCPRD is either an equi-join or non-equi-join predicate
4) OTHLOCPRD is an equi-join predicate
5) OTHCOL and COMPCOL are both string-type columns
The stack trace from such an abend will look something like:
sqlrxcp1
sqlnr_seldel_test
sqlnr_upddelpd_cond
sqlnr_seq
sqlnr_rcc
sqlnr_magic_detail_action
... |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 Fix Pack 3 or later. *
**************************************************************** |
| Local-Fix: |
Manually rewrite the query by adjusting the empty strings in
the2 predicates involved to have the same length as the columns
they are being compared against using spaces, e.g.,
VARCHAR_4_COL = ''
can be safely adjusted to:
VARCHAR_4_COL = ' ' |
| verfügbare FixPacks: |
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 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
First fixed in DB2 Version 9.7 Fix Pack 3. |
| Workaround |
See LOCAL FIX |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 27.08.2009
30.09.2010
30.09.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP3
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.3
|
 |
| 9.7.0.3
|
|
