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 IT06168 Status: Geschlossen

ERROR 768:INTERNAL ERROR IN ROUTINE MINDEXP: MISSING RANGE FILTER; WHEN YOU
USE MULTI-INDEX SCAN AND SET MULTI-BYTE LOCALE

Produkt:
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10
Problembeschreibung:
When you use multi-index scan and set multi-byte local, you 
receive "768: Internal error in routine mindexp: missing range 
filter." 
 
The stack tracing is as follows when you receive this error. 
 
(oninit) afstack 
(oninit) afhandler 
(oninit) affail_interface 
(oninit) check_traperror 
(oninit) sqerr 
(oninit) sqerr1 
(oninit) mindexp 
(oninit) opidxp 
(oninit) opscanp 
(oninit) op_opinit 
(oninit) sqoptim 
(oninit) bldstructs 
(oninit) sqcmd 
(oninit) sq_cmnd 
(oninit) sq_prepare 
(oninit) sqmain 
(oninit) spawn_thread 
(oninit) th_init_initgls 
(oninit) startup
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users of 12.10.xC1 through 12.10.xC4.                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* A query may return -768 error under the following            * 
* conditions:                                                  * 
*   - a pair of range predicates on the same column, e.g. col1 * 
*   - one side of the range pair contains a correlated         * 
* subquery, e.g. col1 <  <correlated_subquery>                 * 
*   - the other side of the range pair contains constants,     * 
* host variables, etc. e.g. col1 >= <const>                    * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to IBM Informix Server 12.10.xC5.                     * 
****************************************************************
Local-Fix:
avoid using multi-index scan
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:
18.12.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