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

supportsInCriteria is ignored

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 7.7.1, 8.0
    • 7.7.1
    • None
    • None

    Description

      SQL query whose WHERE clause contains ORed conditions is sent down to custom translator as IN clause even when the custom translator doesn' support IN clause.

      public class EWSExecutionFactory extends
      ExecutionFactory<ConnectionFactory, EWSConnection> {
      ...

      @Override
      public boolean supportsInCriteria()

      { return false; }

      @Override
      public boolean supportsInCriteriaSubquery()
      { return false; }

      }

      SELECT COUNT FROM Storage.MVDETAIL WHERE Storage.MVDETAIL.CUA = '2D03' OR Storage.MVDETAIL.CUA = '2D07'
      is translated to
      SELECT COUNT FROM Storage.MVDETAIL WHERE Storage.MVDETAIL.CUA IN ('2D03', '2D07')

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            navmi02 Michal Navrkal (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: