|
Problem IT05711
|
Status: Closed |
DB2 MIGHT NOT SPLIT OLAP FUNCTIONS AND SUBQUERIES FROM CASE EXPRESSIONS |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 and Fix Pack 11 *
**************************************************************** |
| Local Fix: |
|
| Solution |
Problem was first fixed in DB2 Version 9.7 and Fix Pack 11 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 20.11.2014
10.10.2015
10.10.2015 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.11
|
 |
