|
Problem IC61452
|
Status: Closed |
SQL FUNCTION MULTISET IN SELECT STATEMENT ASSERT FAILS IN ALLOC_CHANGELOG() OR FREELST_FIND() |
| product: |
IBM IDS ENTRP E / 5724L2304 / B15 - IDS 11.50 |
| Problem description: |
The following SQL:
select multiset(select tabname::nvarchar(100)||'; ' from
table(set{0})) from systables
is causing AF with the following error in online.log:
(-9791): ERROR: Routine execution trap --
procname=<collectionoutput> procid=18
reason: mem
Here are the AF stacks:
From 11.50FC4 on AIX:
14:55:53 IBM Informix Dynamic Server Version 11.50.FC4
Software Serial Number AAA#B000000
14:55:53 Assert Failed: Exception Caught. Type: MT_EX_OS,
Context: mem
14:55:53 Who: Session(21, informix@xxxxx, 520254, 5031a598)
Thread(41, sqlexec, 502db268, 1)
File: mtex.c Line: 417
14:55:53 Action: Please notify IBM Informix Technical
Support.14:55:53 Raw hex dump of stack located in
/opt/IBM/informix_v1150fc4/tmp/af.411e079.rawstk
14:55:53 Stack for thread: 41 sqlexec
base: 0x0000000060704000
len: 69632
pc: 0x00000001000c178c
tos: 0x0000000060710a20
state: running
vp: 1
(oninit)afstack
(oninit)afhandler
(oninit)mt_ex_throw_sig
(oninit)afsig_handler
(oninit)freelst_find
(*nosymtab*)
(oninit)new_changelog
(oninit)cursor_insert
(oninit)ifx_coll_insert
(oninit)geval
(oninit)clscan_open
(oninit)prepselect
(oninit)collsubq_open
(oninit)ifx_coll_open_with_options
(oninit)mi_collection_open_with_options
(oninit)collectionoutput_internal
(oninit)udrlm_clang_execute_internal
(oninit)udrlm_clang_execute
(oninit)udrlm_exec_routine
(oninit)udr_execute
(oninit)evaloutput
(oninit)convcol
(oninit)evalcols
(oninit)getrow
(oninit)fetchrow
(oninit)exfetch
(oninit)sql_nfetch
(oninit)sq_nfetch
(oninit)sqmain
(oninit)listen_verify
(oninit)spawn_thread
(oninit)startup |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users using a dervied table selecting a constant value *
* involving a collection subquery *
****************************************************************
* PROBLEM DESCRIPTION: *
* The server crashes when using a constant derived table *
* inside is collection subquery. *
* Ex. select multiset(select tabname::nvarchar(100)||'; ' from *
* table(set{0})) from systables *
****************************************************************
* RECOMMENDATION: *
* Upgrade to IDS 11.50.xC5 and above. *
**************************************************************** |
| Local Fix: |
|
| Solution |
Problem first fixed in IDS 11.50.xC5. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 10.06.2009
21.01.2010
21.01.2010 |
| Problem solved at the following versions (IBM BugInfos) |
11.50.xC5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 11.50.xC5
|
 |
