|
Problem IT16124
|
Status: Closed |
QUERY WITH 2 OR MORE LEFT OUTER JOINS WILL RETURN WRONG RESULTS
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
A query with 2 or more left outer joins will return wrong
results. If only one outer join is used, the results are
correct.
It does return the correct results if the --+avoid_hash
directive is used. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of 12.10.xC1 through 12.10.xC7. *
****************************************************************
* PROBLEM DESCRIPTION: *
* An ANSI OUTER JOIN query may return incorrect results under *
* the following conditions: *
* - a hash join is being used to handle an outer join *
* - the subservient table (which is the build side of the *
* hash join) is large such that the hash join build overflows *
* - the subservient table is significantly larger than the *
* dominant side table(s) for this join *
* - a WHERE clause exists for the ANSI OUTER JOIN query, and *
* it references a dominant side table *
****************************************************************
* RECOMMENDATION: *
* Update to IBM Informix Server 12.10.xC8 *
**************************************************************** |
| Local Fix: |
Use the +avoid_hash directive. |
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 14.07.2016
09.12.2016
09.12.2016 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC8
|
| Problem solved according to the fixlist(s) of the following version(s) |
