DB2 - Problembeschreibung
Problem IT05616 | Status: Geschlossen |
DB2 MIGHT NOT SPLIT OLAP FUNCTIONS AND SUBQUERIES FROM CASE EXPRESSIONS | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
Under certain scenarios DB2 might create a trap if the following conditions are true: 1. Query with two case expressions in a select list 2. Where one case expression contains an OLAP function like Min, Max and Rank 3. Where the other case expression contains an existential subquery like IN, NOT IN and EXISTS 4. One or more of the when clauses of the case expression contains an OLAP function 5. One or more of the when clauses of the case expression contains an existential subquery Some of the known stack traces are the following: sqlnq_const_fold_treeP9sqlnq_pid sqlnq_exp17optimizeParseTree sqlnr_coleq_class_action sqlnr_seqPiP10sqlnr_qrwaPi sqlnr_rcciP10sqlnr_qrwaPi sqlnr_endqtb_action sqlnr_seqPiP10sqlnr_qrwaP14sqlnr_progressP12sqlnr_rclass sqlnq_const_fold_treeP9sqlnq_pid sqlnq_exp17optimizeParseTree sqlnr_selbox_mergeP9sqlnq_qtb sqlnr_sel_mrg_actionP10sqlnr_qrwaPi sqlnr_compPiiP16sqlnr_rule_state sqlnr_seqPiP10sqlnr_qrwa sqlnr_rcciP10sqlnr_qrwa | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 10.5 and Fix Pack 7 * **************************************************************** | |
Local-Fix: | |
Lösung | |
Problem was first fixed in DB2 Version 10.5 and Fix Pack 7 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 17.11.2014 20.01.2016 20.01.2016 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.7 |