|
Problem IT10925
|
Status: Closed |
WRONG RESULTS POSSIBLE WITH QUERY ON A VIEW WITH UNION ALL AND IFX_FOLDVIEW ENABLED |
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem 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). |
| 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 *
**************************************************************** |
| Local Fix: |
|
| Solution |
Problem Fixed In IBM Informix Server 12.10.xC6 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 26.08.2015
19.01.2016
19.01.2016 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 12.10.xC6
|
 |
