Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-1000

Dependent Join in Virtual Model not pushing criteria to both sources

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Do
    • Major
    • None
    • None
    • Query Engine
    • None

    Description

      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.

      Attachments

        Activity

          People

            Unassigned Unassigned
            rhn-engineering-shawkins Steven Hawkins
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: