Informix - Problem description
Problem IT09447 | Status: Closed |
WRONG RESULTS RETURNED BY A QUERY WITH DISTINCT AND LEFT JOIN | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
The following query with DISTINCT and LEFT JOIN returns wrong results : select distinct t1.c_2, t2.c_2, t1.id_1, t2.c_2 is not null or (t1.c_2 <> '') from gt_test t1 left join gt_test t2 on t1.id_1 = t2.id_1 and t1.c_2 <> t2.c_2 where t2.c_2 is not null or (t1.c_2 <> ''); It returns rows, however in version 11.70 the same query returns no rows. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * SQL QUERY with ANSI LEFT OUTER JOIN * **************************************************************** * 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 | |
see CQ remarks | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 12.06.2015 30.12.2015 30.12.2015 |
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 |