Not in with subquery does not work correctly -------------------------------------------- Key: TEIID-4802 URL: https://issues.jboss.org/browse/TEIID-4802 Project: Teiid Issue Type: Bug Affects Versions: 9.1.4 Reporter: Bram Gadeyne Assignee: Steven Hawkins Priority: Critical Attachments: query_plan_not_in.txt Hi, This query does not return any results where it should. {code:sql} select cl.* from izalert_clientstatus cl where cl.hostname not in ( select WSidentifier from prod_U_PV_PClist ) {code} This query is more or less equivalent to the one above but does return 23 results. {code:sql} select cl.hostname from izalert_clientstatus cl left join prod_U_PV_PClist pl on cl.hostname = pl.WSidentifier where pl.WSidentifier is null {code} hostname and wsidentifier are both String fields. In the clientstatus table it has a length of 255, in the other table 63. The values for hostname and wsidentifier are e.g. 'COSARA4' and 'PC-10360'