]
Steven Hawkins resolved TEIID-5280.
-----------------------------------
Fix Version/s: 10.0.4
10.2
10.1.2
Resolution: Done
Removed translator support for in as the engine will create the appropriate conjunct or
disjunct.
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
Fix For: 10.0.4, 10.2, 10.1.2
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.