|
Problem IT38829
|
Status: Closed |
DB2 MIGHT ABEND WHEN RUNNING QUERIES CONTAINING CASE EXPRESSIONSAND SCALAR AGGREGATIONS
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem description: |
DB2 might trap when users run a query that has the following
characteristics:
1. the query has multiple levels of SELECT
2. one of the lower level select lists has at least one CASE
expression
3. the CASE expression contains scalar aggregations
4. the CASE expression is not referenced in higher level SELECT
lists
-------Frame------ ------Function + Offset------
0x09000000467D194C sqlnd_qtb_pda__FRP9sqlnq_qtbT1iT3 + 0xAC
0x09000000467D2700 sqlnd_qtb_pda__FRP9sqlnq_qtbT1iT3 + 0xE60
0x09000000467D2700 sqlnd_qtb_pda__FRP9sqlnq_qtbT1iT3 + 0xE60
0x09000000467D2700 sqlnd_qtb_pda__FRP9sqlnq_qtbT1iT3 + 0xE60
0x09000000467D2700 sqlnd_qtb_pda__FRP9sqlnq_qtbT1iT3 + 0xE60
0x09000000467D2700 sqlnd_qtb_pda__FRP9sqlnq_qtbT1iT3 + 0xE60
0x09000000467D2700 sqlnd_qtb_pda__FRP9sqlnq_qtbT1iT3 + 0xE60
0x09000000467D1700 sqlnd_qtb_pda__FRP9sqlnq_qtbi + 0x80
0x09000000467D01F8 sqlnd_main__FP9sqlnq_quri + 0x378
0x0900000046D85308
sqlnr_after_prep1__FP10sqlnr_qrwaPiP14sqlnr_progress + 0x228
0x09000000468DB198
sqlnr_comp__FPiiP16sqlnr_rule_stateP10sqlnr_qrwaP14sqlnr_progres
s + 0x218
0x09000000468DB544
sqlnr_seq__FPiP10sqlnr_qrwaP14sqlnr_progressP12sqlnr_rclass +
0xC4
0x09000000468DBA48 sqlnr_rcc__FiP10sqlnr_qrwaPiP14sqlnr_progress
+ 0x308
0x0900000046D86ADC sqlnr_exe__FP9sqlnq_qur + 0x6FC
0x09000000475DD3E4
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
lrr_cmpl_enviT7PP9sql
nq_qur + 0x7404
0x09000000475D5F68
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
lrr_cmpl_env + 0x28
0x0900000046422F5C
sqlra_compile_var__FP8sqlrr_cbP14sqlra_cmpl_envPUciUsN54P14SQLP_
LOCK_INFOP16sqlra_cac
hed_varPiT11_Pb + 0xBDC
0x0900000043DF4400
sqlra_find_var__FP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idUi
T4PUcT4UsUcP14sqlra_c
mpl_env15sqlra_fill_modePiiT12_N313_T12_P14SQLP_LOCK_INFOPP16sql
ra_cached_varT12_bT19_Pb + 0xA60
0x090000004653329C sqlra_get_var__FP8sqlrr_cbiT2bPbT5 + 0xBFC
0x09000000453134FC
sqlrr_prepare__FP14db2UCinterfaceP16db2UCprepareInfo + 0x57C
0x090000004A038DB0
sqljs_ddm_prpsqlstt__FP14db2UCinterfaceP13sqljDDMObject + 0x12B0
0x0900000049FC5610
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface + 0x2B0
0x0900000049FC8664
sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
0x2264
0x0900000049F94F9C
IPRA.$sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0xE9C
0x0900000049F9D6B4
sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xB4
0x0900000049F93060
IPRA.$sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x13E0
0x0900000049F904B4 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T +
0x334
0x090000004325DBC0 RunEDU__8sqeAgentFv + 0xB60
0x0900000043240640 EDUDriver__9sqzEDUObjFv + 0x300
0x090000004312F614 sqloEDUEntry + 0x374 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 11.5 FP7 or later *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 11.5 FP7 or later *
**************************************************************** |
| Comment |
Upgrade to 11.5 FP7 or later |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.10.2021
22.11.2021
22.11.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
