IT42103: -1266 FOR A COMBINATION OF DATE/INTERVAL AND INTEGER FILTERS

APAR status

• Closed as program error.

Error description

• This simple test case reproduces an undue -1266 error:
  
  CREATE TABLE td (d date);
  CREATE INDEX tdi on td (d);
  SELECT * FROM td
  WHERE
   ( d < TODAY - 1 UNITS DAY OR d = TODAY)
  AND
     d < TODAY - 1 UNITS MONTH;
  
  Variants of this simplified demo statement will do as well.
  
  Conditions for hitting the problem, per some testing:
  - Index having column d in first position (if multiple columns)
  - Those interval expressions
  - An   ... AND ( ... OR ... ) filter with two different
  date/interval comparisons
  - Those two units (MONTH and DAY) can't be the same
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of Informix Server to 12.10.xC16 and 14.10.FC9W1.      *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Informix Server 12.10.xC16 (if available) or      *
  * 14.10.FC9W1.                                                 *
  ****************************************************************
  

Problem conclusion

• Fixed in Informix Server 12.10.xC16 and 14.10.FC9W1.
  

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