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

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

    XMLWordPrintable

    Details

      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

            Assignee:
            shawkins Steven Hawkins
            Reporter:
            mike_higgins Mike Higgins (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: