IT10925: WRONG RESULTS POSSIBLE WITH QUERY ON A VIEW WITH UNION ALL AND IFX_FOLDVIEW ENABLED

APAR status

• Closed as program error.

Error description

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

Local fix

Problem summary

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

• Problem Fixed In IBM Informix Server 12.10.xC6
  

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