[teiid-issues] [JBoss JIRA] (TEIID-5280) OData4 translator: disappearing negation when using 'in' predicate

[Jan Martiska (JIRA)]

Jan Martiska created TEIID-5280:
-----------------------------------

             Summary: OData4 translator: disappearing negation when using 'in' predicate
                 Key: TEIID-5280
                 URL: https://issues.jboss.org/browse/TEIID-5280
             Project: Teiid
          Issue Type: Bug
          Components: OData
    Affects Versions: 8.12.11.6_4
            Reporter: Jan Martiska
            Assignee: Steven Hawkins


Suppose this query against an OData4-backed view:
{noformat}
SELECT intkey FROM bqt1.smalla WHERE NOT (intkey IN (1, 2, 3))
{noformat}

This is translated to a filter:
{noformat}
filter=intkey eq 1 or intkey eq 2 or intkey eq 3
{noformat}

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



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)