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

Combining multiple 'in' criteria can prevent pushing criteria to database

    XMLWordPrintable

Details

    • Feature Request
    • Resolution: Done
    • Major
    • 8.8, 8.7.2.6_2
    • 8.7
    • Query Engine
    • None

    Description

      When two 'in' criteria containing constant values on the same field are combined with an 'or', Teiid will combine the two into a single 'in' operation.

      Since Oracle (for example) has a 1000 item limit on the 'in' values, if the resulting combined list contains more than 1000 values, it can no longer be pushed down into Oracle for execution.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            mike.higgins@certara.com Mike Higgins (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: