|
Problem IT12934
|
Status: Closed |
QUERY RETURNS INCORRECT RESULTS WHEN SELECTING IN A SUBQUERY WITH A NOT IN CLAUSE
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
Query returns incorrect results when doing a select in a
subquery with a not in clause. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of 12.10.xC1 through 12.10.xC6. *
****************************************************************
* PROBLEM DESCRIPTION: *
* A query with correlated NOT EXISTS subquery may return *
* incorrect results under the following conditions: *
* - the correlated NOT EXISTS subquery is executed multiple *
* times during execution *
* - the correlation variable is of CHAR or VARCHAR type *
* - one execution uses valid value for correlation variable *
* - next execution uses a 0-length string (a null string) as *
* correlation value *
* - third execution uses the same value for correlation *
* variable as the first execution *
****************************************************************
* RECOMMENDATION: *
* Update to IBM Informix Server 12.10.xC7 *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 24.12.2015
28.06.2016
28.06.2016 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC7
|
| Problem solved according to the fixlist(s) of the following version(s) |
