DB2 - Problembeschreibung
Problem IT08897 | Status: Geschlossen |
A QUERY WITH IDENTICAL SCALAR SUBQUERY(S) REFERENCED BY MULTIPLE PREDICATES WITHIN THE SAME SELECT QUERY BLOCK CAN TRAP | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
The query needs the identical (or exactly matched) scalar subquery(s) referenced by multiple predicates within the same SELECT query block. The query rewrite will trap and have the call stack shown below: <StackTrace> ------RBP--------------RIP--------------ARGS------- 000000008AA24410 0000000002D13693 0000000007B70810 offset: 000000000000002F in <sqlnr_pidIsScalarSubquery> <sqlnr_rule2.C:3513> 000000008AA24710 0000000002D11EFE 000000008AB65DA8 offset: 0000000000000258 in <sqlnr_add_pushed_prd> <sqlnr_rule2.C:15814> 000000008AA24B40 0000000002D0E25C 0000000000000000 offset: 00000000000010BC in <sqlnr_local_magic_detail> <sqlnr_rule2.C:9522> 000000008AA24B90 0000000002D0D0EA 000000008AC02D60 offset: 0000000000000040 in <sqlnr_localmagic_action> <sqlnr_rule2.C:10899> 000000008AA24C40 0000000002C476BD 000000008AB40080 offset: 00000000000001DD in <sqlnr_seq> <sqlnr_sys.C:642> 000000008AA24CC0 0000000002C473D2 0000000000000000 offset: 0000000000000072 in <sqlnr_rcc> <sqlnr_sys.C:808> 000000008AA24D10 0000000002D16845 0000000000000038 offset: 0000000000000035 in <sqlnr_magic_detail_action> <sqlnr_rule2.C:10754> 000000008AA24DC0 0000000002C476BD 0000000000000000 offset: 00000000000001DD in <sqlnr_seq> <sqlnr_sys.C:642> 000000008AA24E40 0000000002C473D2 000000008AB65DA8 offset: 0000000000000072 in <sqlnr_rcc> <sqlnr_sys.C:808> 000000008AA24E90 0000000002C6CEDB 00000000000000A0 offset: 000000000000003F in <sqlnr_endqtb_action> <sqlnr_rule.C:2811> 000000008AA24F40 0000000002C476BD 000000008AAB0080 offset: 00000000000001DD in <sqlnr_seq> <sqlnr_sys.C:642> 000000008AA24FC0 0000000002C473D2 0000000007B13598 offset: 0000000000000072 in <sqlnr_rcc> <sqlnr_sys.C:808> 000000008AA25040 0000000002C6D309 000000008A785500 offset: 0000000000000105 in <sqlnr_start_action> <sqlnr_rule.C:2648> 000000008AA250F0 0000000002C476BD 0000000000000000 offset: 00000000000001DD in <sqlnr_seq> <sqlnr_sys.C:642> 000000008AA25170 0000000002C473D2 00000000087D1538 offset: 0000000000000072 in <sqlnr_rcc> <sqlnr_sys.C:808> 000000008AA254B0 0000000002C16340 000000008AB64B80 offset: 0000000000001488 in <sqlnr_exe> <sqlnr_exe.C:11107> 000000008AA26C80 0000000002484A78 00099138552FA937 offset: 00000000000047DC in <sqlnn_cmpl> <sqlnn_cmpl.C:3548> 000000008AA26CE0 0000000002480296 00000000087D12A8 offset: 000000000000003C in <sqlnn_cmpl> <sqlnn_cmpl.C:531> 000000008AA28240 000000000326D26D 00000000DB2CAFE0 offset: 0000000000000CD7 in <sqlra_compile_var> <sqlra_cmpl.C:1060> 000000008AA28D00 000000000327B2EA 0000000004832F54 offset: 000000000000078E in <sqlra_find_var> <sqlra_dyn.C:4389> 000000008AA295D0 000000000328E487 0000000000001800 offset: 000000000000088D in <sqlra_get_var> <sqlra_var.C:1838> 000000008AA29660 00000000030B5812 000000008AA297A0 offset: 000000000000015E in <sqlrr_prepare> <sqlrr_req_sql.C:2993> 000000008AA29800 000000000225553A 0000000009A49F10 offset: 0000000000000936 in <sqljs_ddm_prpsqlstt> <sqljspds.C:633> 000000008AA29AD0 000000000222A15D 0000000009A69EB8 offset: 0000000000002FAD in <sqljsParse> <sqljspar.C:887> 000000008AA29D50 00000000021F3DA3 000000008A461CA0 offset: 00000000000002C7 in <sqljsSqlam> <sqljsqam.C:2189> 000000008AA29DC0 00000000021FA5DB 0000000000000000 offset: 00000000000000A5 in <sqljsDriveRequests> <sqljsqam.C:3075> 000000008AA29F10 00000000021F7C9F 0000000000000000 offset: 000000000000033F in <sqljsDrdaAsInnerDriver> <sqljsqam.C:1277> 000000008AA2F830 00000000021F77BD 000000000973ECF8 offset: 000000000000012B in <sqljsDrdaAsDriver> <sqljsqam.C:1052> 000000008AA2FBB0 000000000200EF8A 000000008AA2FB00 offset: 000000000000079C in <sqeAgent::RunEDU> <sqle_agent.C:4064> 000000008AA2FC40 0000000003AD2D11 0000000000000000 offset: 000000000000010F in <sqlzRunEDU> <sqlz_edu_obj.C:35> 000000008AA2FF50 00000001800EA172 00000000133CEEB8 offset: 000000000000038E in <sqloEDUEntry> <sqloedu.C:3456> 000000008AA2FF80 00000000776659ED 0000000000000000 000000008AA2FFD0 000000007779C541 0000000000000000 ></StackTrace> | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All Platforms * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 LUW v9.7 Fixpack 11 or Later. * **************************************************************** | |
Local-Fix: | |
Lösung | |
First Fixed in DB2 LUW v9.7 Fixpack 11. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 13.05.2015 08.10.2015 08.10.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP11 | |
Problem behoben lt. FixList in der Version | |
9.7.0.11 |