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

Add additional detection for conflicting criteria to help optimize query plan

    XMLWordPrintable

Details

    • Feature Request
    • Resolution: Done
    • Major
    • 7.3
    • 6.0.0
    • Query Engine
    • None

    Description

      Add additional detection for conflicting criteria such as "(column1=1 OR column1=2) AND column1=3". The attempted use case was a case of a UNION that was using the column as a measure of selecting a specific datasource, with each query joined by the UNION having a specific set of column1 values (such as "column1=1 OR column1=2"). In the case of the end user application submitting criteria such as "column1=3", the query planner should prune any branches of the UNION with a conflicting set of values for column1. It would also be helpful if other operators such as <, >, <>, IN, etc. could be accounted for.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            rhn-support-mshirley Marc Shirley (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: