Informix - Problem description
Problem IT16468 | Status: Closed |
QUERY DOES NOT RETURN IN 11.70.FC8W1, BUT RAN QUICKLY IN 11.70.FC4 | |
product: | |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 | |
Problem description: | |
A query that ran quickly in IDS 11.70.xC4 does not return in 11.70.xC8W1. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of 11.70.xC5 through 11.70.xC8 * **************************************************************** * PROBLEM DESCRIPTION: * * A query may have sub-optimal performance under the following * * conditions: * * - query is in ANSI JOIN syntax, e.g. FROM t1 INNER JOIN t2 * * on t1.c1 = t2.c2 ..... * * - there is an inner join (see example above) * * - one of the columns involved in the inner join also has a * * subquery predicate in the WHERE clause, e.g., t1.c1 IN * * * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 11.70.xC9 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 04.08.2016 09.06.2017 09.06.2017 |
Problem solved at the following versions (IBM BugInfos) | |
11.70.xC9 | |
Problem solved according to the fixlist(s) of the following version(s) |