Informix - Problem description
Problem IT27530 | Status: Closed |
WRONG RESULTS RETURNED FROM SELECT WITH LEFT JOIN | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
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) ); | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of IDS 12.10.xC10 and earlier versions. * **************************************************************** * PROBLEM DESCRIPTION: * * Wrong results returned from select with LEFT JOIN. * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 24.12.2018 07.10.2019 07.10.2019 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC11 | |
Problem solved according to the fixlist(s) of the following version(s) |