home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
14.10.xC11 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