INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

When you have defined a view by a union all select on two tables 
you may achieve wrong results when IFX_FOLDVIEW ist enabled. 
 
The query this has been observed with is of the form 
 
select t1.c2[1,2], t2.c2[1,2], * 
from tab2 t2, tab1 t1, v1 v1 
where t1.c1 = v1.c1 
and t2.c2[1,2] = t1.c2[1,2]; 
 
where t1 and t2 are tables and v1 is the view. The column c2 is 
of type character(x) (with x > 2).

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users of 12.10.xC4 and 12.10.xC5.                            * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* A query may return incorrect results under the following     * 
* conditions:                                                  * 
*   - a simple UNION ALL view is referenced                    * 
*   - IFX_FOLDVIEW is set to 1 in onconfig                     * 
*   - the main query has in its where clause subscripted       * 
* column references, e.g. tab1.c1[1,2] = tab2.c2[1,2]          * 
*   - the subscripted column reference does not need to be     * 
* view column references                                       * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to IBM Informix Server 12.10.xC6                      * 
****************************************************************

Problem Fixed In IBM Informix Server 12.10.xC6

not known / see Local fix

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

26.08.2015
19.01.2016
19.01.2016

12.10.xC6