[teiid-issues] [JBoss JIRA] Updated: (TEIID-1000) Dependent Join in Virtual Model not pushing criteria to both sources

Dependent Join in Virtual Model not pushing criteria to both sources -------------------------------------------------------------------- Key: TEIID-1000 URL: https://jira.jboss.org/browse/TEIID-1000 Project: Teiid Issue Type: Bug Components: Query Engine Reporter: Steven Hawkins Fix For: 8.0 Sample models are attached. User query is: SELECT * FROM v_TV_SHOWS.v_SHOWS_ACTORS2 WHERE SHOW_NAME LIKE '%E%' AND NOT ACTOR_SHOW_ID IN (SELECT ACTOR_SHOW_ID FROM v_TV_SHOWS.v_SHOWS_ACTORS2 WHERE ACTOR_NAME = 'MALCOLM JAMAL-WARNER') OPTION DEBUG and MMProcess.log are attached. Customer complaint is that the query contains criteria on ACTOR_NAME and ACTOR_SHOW_ID which is coming from Oracle and on SHOW_NAME which is coming from SQL Server. In the query plan, there is a SELECT node that does not have criteria to Oracle. Instead it is SELECT * which pulls all records. Customer tables are huge so this is an issue for them.