INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

Query could return wrong results

SELECT
{+explain,ordered,use_nl(d),use_nl(dda),use_nl(ds),use_nl(va),us
e_nl(e),use_nl(ts)}
       d.id delegation_id,p.status_id, dda.delegation_id,
d.addr_nr,d.owner_fl,dda.delegation_id
FROM
     test_abs_process p
     JOIN (test_abs_delegation d
     JOIN test_abs_domestic_delegation_account dda ON
d.id=dda.delegation_id) ON p.id=dda.process_id
     JOIN test_abs_delegation_signature ds ON
ds.id=d.delegation_signature_id
     JOIN test_v_address va ON va.addr_nr=d.addr_nr
     LEFT JOIN test_pn_employ e ON e.addr_nr = va.addr_nr AND
today BETWEEN e.date_from AND e.date_to
     LEFT JOIN test_v_trans2fk_status ts ON
ts.id_doc=dda.delegation_id AND ts.status_fl=1
WHERE 1=1
     AND p.status_id = 1
     AND dda.delegation_id IN (SELECT t.id FROM
test_abs_delegation t WHERE t.addr_nr = 3399 AND t.owner_fl IN
(0, 1) );

****************************************************************
* USERS AFFECTED:                                              *
* Users of IDS 12.10.xC10 and earlier versions.                *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* Wrong results returned from select with LEFT JOIN.           *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

24.12.2018
07.10.2019
07.10.2019

12.10.xC11