Informix - Problembeschreibung
| Problem IT05099 | Status: Geschlossen |
QUERY USING ROWIDS BY A MULTIINDEX SCAN CAN CAUSE BLOCK HEADER CORRUPTION | |
| Produkt: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
| Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * 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: | |
| Lösung | |
Problem Fixed In IBM Informix Server 12.10.xC5. | |
| Workaround | |
keiner bekannt / siehe Local-Fix | |
| Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 22.10.2014 16.10.2015 16.10.2015 |
| Problem behoben ab folgender Versionen (IBM BugInfos) | |
12.10.xC5 | |
| Problem behoben lt. FixList in der Version | |
| 12.10.xC5 |
|
| 12.10.xC5.W1 |
|