|
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 |
