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 |