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 |