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

APAR status

• Closed as program error.

Error description

• 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
  

Local fix

• avoid using multi-index scan
  

Problem summary

• ****************************************************************
  * 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.                     *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IBM Informix Server 12.10.xC5.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  INFORMIX SERVER

• Fixed component ID

  5725A3900

Applicable component levels

• RC10 PSN

     UP