home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
15.0.xC1.2 FixList
14.10.xC13.3 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

Informix - Problembeschreibung

Problem IT09447 Status: Geschlossen

WRONG RESULTS RETURNED BY A QUERY WITH DISTINCT AND LEFT JOIN

Produkt:
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10
Problembeschreibung:
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-Zusammenfassung:
**************************************************************** 
* 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:
Lösung
Problem Fixed In IBM Informix Server 12.10.xC6
Workaround
see CQ remarks
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
12.06.2015
30.12.2015
30.12.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
12.10.xC6
Problem behoben lt. FixList in der Version
12.10.xC6 FixList