|
Problem IT34655
|
Status: Closed |
A COMPLEX XML QUERY INVOLVING XMLTABLE FUNCTION COULD TRAP
|
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
A complex query with the following characteristic could trap ;
- XMLTABLE functions used
- Many CSEs (common subexpressions) are used in cascading
manners
The stack looks like below:
sqlnq_xq_trf_let_qun
sqlnr_xq_native_optprep
sqlnr_optprep_chunk2
sqlnr_optprep_chunk2_action
sqlnr_comp
sqlnr_seq
sqlnr_rcc
sqlnr_exe |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* no workaround *
* upgrade to Db2 v.11.1.4.FP6 *
**************************************************************** |
| Local Fix: |
no workaround
upgrade to Db2 v.11.1.4.FP6 |
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* no workaround *
* upgrade to Db2 v.11.1.4.FP6 *
**************************************************************** |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 23.10.2020
27.10.2021
27.10.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
