Informix - Problembeschreibung
Problem IT26528 | Status: Geschlossen |
SELECT SUBSTR IN IWA (WAREHOUSE ACCELERATOR) CAUSES AF IN GETTYPEEXPR WRTEXPR DWA_OFFLOAD() | |
Produkt: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problembeschreibung: | |
Query with SUBSTR and CONCAT expression can cause the AF: SELECT col1, col[2,3] || '-' || col[4,5] AF: x0000000011424cc0 (oninit)afstack 0x0000000011427e38 (oninit)afhandler 0x00000000114284f8 (oninit)affail_interface 0x0000000011429d44 (oninit)mt_ex_throw_sig 0x00000000113e76d0 (oninit)afsig_handler 0x00003fffb0300478 __kernel_sigtramp_rt64 0x00000000000018d5 (*nosymtab*)0x18d5 # Invalid/incorrect 0x0000000010659a48 (oninit)wrtexpr 0x0000000010659aa4 (oninit)wrtexpr 0x000000001065843c (oninit)wrtexpr 0x000000001065f85c (oninit)wrtcollist 0x0000000010656b28 (oninit)creatext 0x00000000104ce0f4 (oninit)opbldremote 0x0000000010665998 (oninit)bldremcmds 0x000000001058e6ec (oninit)dwa_offload 0x000000001058f060 (oninit)dwa_matchQuery 0x00000000104e9df0 (oninit)sqoptim 0x00000000107936dc (oninit)bldstructs 0x00000000107a6a7c (oninit)sqcmd 0x00000000107a7410 (oninit)sq_cmnd 0x00000000107a7560 (oninit)sq_prepare 0x0000000010886fd8 (oninit)sqmain 0x0000000011550e78 (oninit)spawn_thread 0x0000000011401088 (oninit)th_init_initgls 0x000000001140d4c0 (oninit)startup Actual AF should be more like: x0000000011424cc0 (oninit)afstack 0x0000000011427e38 (oninit)afhandler 0x00000000114284f8 (oninit)affail_interface 0x0000000011429d44 (oninit)mt_ex_throw_sig 0x00000000113e76d0 (oninit)afsig_handler 0x00003fffb0300478 __kernel_sigtramp_rt64 (oninit)gettypeexpr 0x00000000000018d5 (oninit)typeexpr 0x0000000010659a48 (oninit)wrtexpr 0x0000000010659aa4 (oninit)wrtexpr 0x000000001065843c (oninit)wrtexpr 0x000000001065f85c (oninit)wrtcollist 0x0000000010656b28 (oninit)creatext 0x00000000104ce0f4 (oninit)opbldremote 0x0000000010665998 (oninit)bldremcmds 0x000000001058e6ec (oninit)dwa_offload 0x000000001058f060 (oninit)dwa_matchQuery 0x00000000104e9df0 (oninit)sqoptim 0x00000000107936dc (oninit)bldstructs 0x00000000107a6a7c (oninit)sqcmd 0x00000000107a7410 (oninit)sq_cmnd 0x00000000107a7560 (oninit)sq_prepare 0x0000000010886fd8 (oninit)sqmain 0x0000000011550e78 (oninit)spawn_thread 0x0000000011401088 (oninit)th_init_initgls 0x000000001140d4c0 (oninit)startup | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Users of IDS prior to 12.10.xC13. * **************************************************************** * PROBLEM DESCRIPTION: * * In DWA environment, Assert Failure in gettypeexpr wrtexpr * * called by dwa_offload(). * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local-Fix: | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 06.10.2018 26.09.2019 26.09.2019 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
12.10.xC13 | |
Problem behoben lt. FixList in der Version |