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

OData4 translator: disappearing negation when using 'in' predicate

    XMLWordPrintable

Details

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

    Description

      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.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: