Informix - Problem description
| Problem IT02876 | Status: Closed |
768: INTERNAL ERROR IN ROUTINE OPJOIN() WITH MULTIPLE JOINS AND LEFT OUTER JOIN | |
| product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
| Problem description: | |
768: Internal error in routine opjoin() | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * users of 12.10.xC1 through 12.10.xC4. * **************************************************************** * PROBLEM DESCRIPTION: * * A complex ANSI JOIN query involving views may return -768 * * error under the following conditions: * * - a view with multiple tables (>5) and has only inner * * joins in its definition * * - a main query with ANSI OUTER JOIN, where the view * * reference is used as a dominant table in the query * * - there exists multiple join predicates among the multiple * * tables used in the view definition * **************************************************************** * RECOMMENDATION: * * Update to IDS-12.10.xC5 * **************************************************************** | |
| Local Fix: | |
| Solution | |
Problem Fixed In IDS-12.10.xC5 | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 30.06.2014 16.10.2015 16.10.2015 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 12.10.xC4.W1 |
|
| 12.10.xC5 |
|
| 12.10.xC5.W1 |
|