|
Problem IT26528
|
Status: Closed |
SELECT SUBSTR IN IWA (WAREHOUSE ACCELERATOR) CAUSES AF IN GETTYPEEXPR WRTEXPR DWA_OFFLOAD()
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
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 Summary: |
****************************************************************
* 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: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 06.10.2018
26.09.2019
26.09.2019 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC13
|
| Problem solved according to the fixlist(s) of the following version(s) |
