|
Problem IT10305
|
Status: Closed |
A CORRELATED SUBQUERY IS IGNORED WHEN RUN INSIDE A STORED PROCEDURE |
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
Running a query with a correlated sub query inside a stored
procedure returns an unexpected number of rows, however the same
query run outside the procedure returns the number of rows
expected.
The number of wrong rows returned should have been excluded with
a NOT EXISTS correlated sub query. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* 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 :
| 23.07.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
|
 |
