|
Problem IT14675
|
Status: Closed |
OPTIMIZER ASSERT FAIL AND ERROR -874 WHEN REOPENING A CURSOR DEFINED WITH HOST VARIABLES THAT SELECTS FROM A VIEW WITH SUBQUERY
|
| product: |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 |
| Problem description: |
ENV : 12.10.FC8W1 on AIX
There are two stacks being seen :
(oninit)afstack
(oninit)afhandler
(oninit)affail_interface
(oninit)mt_ex_throw_sig@AF11_4
(oninit)afsig_handler
(oninit)sqoptim
(oninit)sqoptim
(oninit)sqbind
(oninit)sq_common_bind
(oninit)sq_bind
(oninit)sqmain
and
(oninit)remove_cblist
(*nosymtab*)0x42000
(oninit)sqoptim
(oninit)exsubqm
(oninit)subqcmp
(oninit)ev_anyall
(oninit)new_eval
(oninit)gettupl
(oninit)scan_next
(oninit)join_next
(oninit)join_next
(oninit)join_next
(oninit)join_next
(oninit)join_next
(oninit)join_next
(oninit)join_next
(oninit)filltemp
(oninit)scan_open
(oninit)IPRA.$materialize_viewtmp
(oninit)IPRA.$materialize_viewtmp
(oninit)IPRA.$materialize_viewtmp
(oninit)IPRA.$materialize_viewtmp
(oninit)materialize_viewtmp
(oninit)prepselect
(oninit)open_cursor
(oninit)sql_open
(oninit)sq_open
(oninit)sqmain |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of 11.70.xC8W1 *
****************************************************************
* PROBLEM DESCRIPTION: *
* A query may trigger -874 error and assertion failure under *
* the following conditions: *
* - query references a complex view, which is materialized *
* into a temp table during query execution *
* - query references a subquery in the form of "col IN *
* " or "col = ANY ", where col references *
* a view column *
* - query has a predicate that uses a host variable *
* - a cursor defined on the query, and the cursor is closed *
* and reopened *
****************************************************************
* RECOMMENDATION: *
* Update to IBM Informix Server 11.70.xC9 *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 06.04.2016
09.06.2017
09.06.2017 |
| Problem solved at the following versions (IBM BugInfos) |
11.70.xC9
|
| Problem solved according to the fixlist(s) of the following version(s) |
