INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

Consider the following select: 
select "vts_v" as tablename, * from vts_v 
  where tmstamp <> tmstamp::datetime year to second; 
 
This tries to compare a time series to the truncated part, to 
try and find 
if there are data which differ only in the micro seconds part. 
 
In 12.10 this will display all rows, even those with all "0" in 
the microsecond part. 
 
 
If you do the same result using the extend funtion it will show 
the right results i.e. those with a different micro second part. 
 
select "vts_v" as tablename, * from vts_v 
  where extend(tmstamp::datetime year to fraction(5), year to 
fraction(5)) <> tmstamp::datetime year to second;

**************************************************************** 
* USERS AFFECTED:                                              * 
* TS vti queries with cast on a column in the where clause     * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to IDS-12.10.xC5                                      * 
****************************************************************

Problem Fixed In IDS-12.10.xC5

not known / see Local fix

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

04.09.2014
16.10.2015
16.10.2015