|
Problem IT13727
|
Status: Closed |
ASSERT FAILURE POSSIBLE IN CLOSE_PREFILL_RMAP_SORTS() WITH UNION ALL AND MULTI-INDEX SCAN PATH USED
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
You may observe an Assertion Failure with stack:
afstack
mt_ex_throw_sig
afsig_handler
close_prefill_rmap_sorts
scan_close
join_close
merge_close
sort_close
close_cb_subtree_r
close_cb_subtree
closesdb
close_cursor
sq_close
sqmain
spawn_thread
th_init_initgls
startup
for an SQL statement with UNION ALL for which the optimizer
chooses a multi-index scan path. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of 12.10.xC1 through 12.10.xC6. *
****************************************************************
* PROBLEM DESCRIPTION: *
* A UNION ALL query using multi-index scan may result in *
* assertion failure and incorrect results under the following *
* conditions: *
* - SSC is turned on *
* - the UNION ALL query uses host variables, and the last *
* arm of the UNION ALL uses some of the host variables *
* - one or more of the host variables is used for fragment *
* elimination purpose *
* - the last arm of the UNION ALL query uses multi-index *
* scan *
* - query is run multiple times within each invocation of *
* the application program utilizing different sets of values *
* for host variables *
* - application program is invoked multiple times *
****************************************************************
* RECOMMENDATION: *
* Update to IBM Informix Server 12.10.xC7 *
**************************************************************** |
| Local Fix: |
Switching off multi-index scan can serve as a temporary relief. |
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 10.02.2016
28.06.2016
28.06.2016 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC7
|
| Problem solved according to the fixlist(s) of the following version(s) |
