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)