Informix - Problem description
Problem IT16522 | Status: Closed |
WRONG RESULTS IN QUERY WITH SUBQUERY WITH CASE WHICH INCLUDES SUBQUERY AND WHERE CLAUSE ON CASE COLUMN IF ORDER BY IS USED OR NO | |
product: | |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 | |
Problem description: | |
A query with a subquery with a case statement which includes a subquery and where clause on the case column with return the wrong results if an order by is used or not. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of 11.70.xC1 through 11.70.xC8. * **************************************************************** * PROBLEM DESCRIPTION: * * A query referencing a view or derived table may return * * incorrect results under the following conditions: * * - the view or derived table definition contains Informix * * outer joins * * - the view or derived table definition does not include * * ORDER BY or GROUP BY clauses * * - the view or derived table definition contains in its * * projection clause a correlated subquery * * - the main query contains a single view or derived table * * only, with no ORDER BY or GROUP BY clause * * - the main query contains in its WHERE clause a predicate * * referencing the correlated subquery column in the view * * definition * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 11.70.xC9 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 08.08.2016 09.06.2017 09.06.2017 |
Problem solved at the following versions (IBM BugInfos) | |
11.70.xC9 | |
Problem solved according to the fixlist(s) of the following version(s) |