|
Problem IC95245
|
Status: Closed |
DB2 CAN TRAP WHEN COMPILING A SUB-QUERY that is APPLIED ON XMLQUERY() |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
DB2 can trap when it compiles a SQL query that has a sub-query
applied on XMLQUERY(), and the query block that contains the
sub-query has more than 64 predicates.
The following is an example of the sub-query:
XMLCAST(XMLQUERY(...) AS CHAR(8)) IN (SELECT X FROM TABLE1)
It can generate the stack traces below:
-------------- Stack Trace -------------------------
sqlno_copy_plan_map
copy_plan_args
sqlno_copy_function_args
sqlno_copy_plan__FCP13sqlno
sqlno_crule_save_plans
sqlno_crule_access
sqlno_crule_access
sqlno_find_plan_chain
sqlno_get_best_plan
sqlno_crule_nljn_inner
sqlno_crule_nljn
sqlno_crule_join_choices
sqlno_crule_join_order
sqlno_crule_join_root
sqlno_crule_join
sqlno_gen_partitions_for_QTB
sqlno_plan_end_opr
sqlno_each_opr
sqlno_walk_qun
sqlno_each_opr
sqlno_top_qtb
sqlno_each_qur
sqlno_scan_qgm
sqlno_planning_scan
sqlno_planning_phase
sqlno_exe
sqlno_exe
sqlnn_cmpl
sqlnn_cmpl
sqlra_compile_var
sqlra_find_var
sqlra_get_var
sqlrr_prepare
sqljs_ddm_prpsqlstt
sqljsParseRdbAccessed
sqljsParse.fdpr.clone.77
@63@sqljsSqlam
@63@sqljsDriveRequests
@63@sqljsDrdaAsInnerDriver
sqljsDrdaAsDriver
RunEDU
EDUDriver
sqloEDUEntry
-------------- Stack Trace -------------------------
pthread_kill
sqloDumpEDU
sqle_panic
sqle_trap
sqlzAssertFailedValist
sqlzAssertFailed
sqlo_md_mcpy
sqlno_copy_setN
sqlno_difference_setsN
sqlno_difference_set
sqlno_prop_preds
sqlno_prop_filter
FILTER__FP13sqlno
sqlno_crule_xscan
sqlno_crule_access_root
sqlno_crule_access
sqlno_find_plan_chain
sqlno_get_best_plan
sqlno_get_best_plan
sqlno_crule_nljn_inner
sqlno_crule_nljn
sqlno_crule_join_choices
sqlno_crule_join_order
sqlno_crule_join_root
sqlno_crule_join
sqlno_gen_partitions_for_QTB
sqlno_plan_end_opr
sqlno_call_sf
sqlno_each_opr
sqlno_call_sf
sqlno_walk_qun
sqlno_call_sf
sqlno_each_opr
sqlno_call_sf
sqlno_top_qtb
sqlno_call_sf
sqlno_each_qur
sqlno_call_sf
sqlno_scan_qgm
sqlno_planning_scan
sqlno_planning_phase
sqlno_exe
sqlnn_cmpl
sqlnn_cmpl
sqlra_compile_var
sqlra_find_var
sqlra_get_var
sqlrr_prepare
sqljs_ddm_prpsqlstt
sqljsParseRdbAccessed
sqljsParse
sqljsSqlam
sqljsDriveRequests
sqljsDrdaAsInnerDriver
sqljsDrdaAsDriver
RunEDU
EDUDriver
sqlzRunEDU
qloEDUEntry
-----------------------------------
On DB2 9.7FP8 it can generat a FODC application error with the
stack below, however the DB2 instance doesn't crash.
-------------- Stack Trace -------------------------
pthread_kill
sqloDumpEDU
sqldDumpContext
sqldDumpContext
sqlrr_dump_ffdc
sqlzeDumpFFDC
sqlzeSqlCode
sqlnn_erds
sqlnn_erds
sqlno_copy_function_args
sqlno_copy_plan
sqlno_copy_plan_map
copy_plan_args
sqlno_copy_function_args
sqlno_copy_plan
sqlno_crule_save_plans
sqlno_crule_access
sqlno_crule_access
sqlno_find_plan_chain
sqlno_get_best_plan
sqlno_crule_nljn_inner
sqlno_crule_nljn
sqlno_crule_join_choices
sqlno_crule_join_order
sqlno_crule_join_root
sqlno_crule_join
sqlno_gen_partitions_for_QTB
sqlno_plan_end_opr
sqlno_each_opr
sqlno_walk_qun
sqlno_each_opr
sqlno_top_qtb
sqlno_each_qur
sqlno_scan_qgm
sqlno_planning_scan
sqlno_planning_phase
sqlno_exe
sqlno_exe
sqlnn_cmpl
sqlra_compile_var
sqlra_find_var
sqlra_get_var
sqlrr_prepare
sqljs_ddm_prpsqlstt
sqljsParseRdbAccessed
sqljsParse.fdpr.clone.0
@63@sqljsSqlam
@63@sqljsDriveRequests
@63@sqljsDrdaAsInnerDriver
RunEDU
EDUDriver
sqloEDUEntry
-----------------------------------
There is no workaround. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See problem description above. *
****************************************************************
* RECOMMENDATION: *
* First Fixed in Version 10.5 Fix Pack 3. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Solution |
First Fixed in Version 10.5 Fix Pack 3. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.08.2013
19.12.2013
19.12.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.3
|
 |
| 10.5.0.3
|
|
| 10.5.0.4
|
|
