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

OData4 translator: disappearing negation when using 'in' predicate

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 10.0.4, 10.2, 10.1.2
    • 8.12.11.6_4
    • OData
    • None

      Suppose this query against an OData4-backed view:

      SELECT intkey FROM bqt1.smalla WHERE NOT (intkey IN (1, 2, 3))
      

      This is translated to a filter:

      filter=intkey eq 1 or intkey eq 2 or intkey eq 3
      

      The NOT operator disappeared and this will return rows where intkey is equal to 1, 2 or 3.

              rhn-engineering-shawkins Steven Hawkins
              jmartisk@redhat.com Jan Martiska
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: