Informix - Problem description
| Problem IT05099 | Status: Closed |
QUERY USING ROWIDS BY A MULTIINDEX SCAN CAN CAUSE BLOCK HEADER CORRUPTION | |
| product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
| Problem description: | |
Running a query selecting the rowid in the selection list and
executing the query by a multi-index scan;
for example in a query like this:
select
pb_in.rowid from g_country pr_orig_country , pb_in
where
pb_in.store_date between '01/01/2014' and '09/10/2014' and
pr_orig_country.iso_a2='VA' and pb_in.dept_code = '99' and
pb_in.pb_num
>= 0 and pb_in.product_origin = pr_orig_country.id
1) informix.pr_orig_country: INDEX PATH
(1) Index Name: informix.country_uidx01
Index Keys: iso_a2 valid_till (Serial, fragments: ALL)
Lower Index Filter: informix.pr_orig_country.iso_a2 =
'720'
2) informix.pb_in: MULTI INDEX PATH (SKIP SCAN)
may case a memory block header corruption for instance in this
stack :
mt_free
rmap_close
readmidx
gettupl
scan_next
filltemp
scan_open
join_open
prepselect
open_cursor
sql_open
sq_open
sqmain | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of 12.10.xC1 through 12.10.xC4. * **************************************************************** * PROBLEM DESCRIPTION: * * A query with rowid in its projection clause may cause memory * * corruption when multi-index scan is used to access the * * underlying table (where the rowid is selected). * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC5. * **************************************************************** | |
| Local Fix: | |
| Solution | |
Problem Fixed In IBM Informix Server 12.10.xC5. | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 22.10.2014 16.10.2015 16.10.2015 |
| Problem solved at the following versions (IBM BugInfos) | |
12.10.xC5 | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 12.10.xC5 |
|
| 12.10.xC5.W1 |
|