DB2 - Problembeschreibung
Problem IT07739 | Status: Geschlossen |
DB2 MIGHT ABEND WHEN EXECUTING A QUERY WITH AN EQUALITY PREDICATE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
Under rare scenarios, DB2 might abend if the following conditions are true: 1) The query contains one or more comparison predicate(s) in the form of Substr(c1, 1, <a_constant>) <relop> <a_constant> where <relop> can be =, <>, >=, >, <, <=. 2) The column c1 of predicate 1) is derived from subquery such that its outmost operator is either UNION ALL or GROUP BY. 3) The subquery of 2) has an output column invovled in an equality join predicate. Error: SQL0901N The SQL statement failed because of a non-severe system error. Subsequent SQL statements can be processed. (Reason "Incorrect index: size = 64 ix = -108.".) SQLSTATE=58004 Stack trace: sqlzeDump sqlzeSqlCode sqlno_add_to_set sqlno_assign_after_prds sqlno_assign_walk_quns_and_ff sqlno_each_opr sqlno_assign_walk_quns_and_ff | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Manually re-write the query by adding an empty string * * literal * * using concatenation. * **************************************************************** | |
Local-Fix: | |
Manually re-write the query by adding an empty string literal using concatenation. change WHERE (Substr(t1.c1, 1, 3) = 'CONTANT') to WHERE ( '' + Substr(t1.c1, 1, 3) = 'CONSTANT') | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 17.03.2015 21.10.2015 21.10.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
9.7.0.11 |