IFMX ULT WHSE E / IM0019BOS / C10 - IDS 12.10

When you attempt to offload a query to the Informix Warehouse 
Accelerator including an expression like 
 
 cast(max(x0.time_value) as date) < TODAY - 2 
 
you will receive an error 26402 for the offload attempt. 
Depending on the setting of use_dwa a fallback to the Informix 
server will be attempted or the query execution will be aborted. 
 
There will be an assertion shown in the messages file of the 
server running the Informix Warehouse Accelerator which will 
include this information: 
 
A query parsing error with description 'An assertion 'false' 
failed. Additional info: Cast not possible at TEMPORAL_SUBTRACT: 
{TEMPORAL_SUBTRACT:T0:     {CAST:T10: 
819:10:02/26/2015:T2(10,819): }   SINT16:2:T7: }  '

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users of Informix Server up to 12.10.xC4. Fixed in           * 
* 12.10.xC5.                                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Informix Server and Informix Warehouse            * 
* Accelerator Version 12.10.xC5 or newer.                      * 
****************************************************************

When you specify UNITS for 2 in this example then you can 
prevent this offload failure. So with 
 
cast(max(x0.time_value) as date) < TODAY - 2 UNITS DAY 
 
the query should again be successfully offloaded.

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

27.02.2015
16.10.2015
16.10.2015

12.10.xC5