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