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 |
![]() |
12.10.xC5.W1 |
![]() |