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

supportsInCriteria is ignored

XMLWordPrintable

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

      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')

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

              Created:
              Updated:
              Resolved: