DB2 - Problembeschreibung
Problem IC62780 | 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 / 950 - 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.5 Fix Pack 6 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.5 Fix Pack 6a for Linux, UNIX, and Windows | |
Lösung | |
First fixed in DB2 Version 9.5 Fix Pack 6. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 27.08.2009 25.05.2010 25.05.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP6 | |
Problem behoben lt. FixList in der Version |