INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

A complex query (typically originated by Cognos) consisting of 
ansi joins and nested selects results in multiple assert 
failures and eventually crashes the engine. 
 
The most common assert failure which usually comes first has 
failure stack similar to the one below: 
afstack 
afhandler 
afcrash_interface 
mt_lock 
sapi_drain_mem 
sapi_destroy_mem 
relsdbmem 
doreleasesdb 
sqcmd 
sq_cmnd 
sq_prepare 
sqmain 
spawn_thread 
th_init_initgls 
startup

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users of 12.10.xC4.                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* A complex query may result in server crash under the         * 
* following conditions:                                        * 
*   - main query has one view (e.g. view1) or derived table    * 
* that has UNION ALL in it, this view is folded                * 
*   - main query has another view (e.g. view2) or derived      * 
* table that has UNION ALL in it, this view is materialized    * 
* (e.g, used as subservient table in outer join)               * 
*   - the definition of the materialized view (view2 above)    * 
* has in its definition a nested view(e.g. view3) or derived   * 
* table, which is also materialized                            * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to IDS-12.10.xC5                                      * 
****************************************************************

Problem Fixed In IDS-12.10.xC5

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

20.10.2014
16.10.2015
16.10.2015