home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
15.0.xC1.2 FixList
14.10.xC13.3 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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 FixList
12.10.xC5.W1 FixList