]
Work on TEIID-5280 started by Steven Hawkins.
---------------------------------------------
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.