OData4 translator doesn't handle IS NOT NULL condition properly --------------------------------------------------------------- Key: TEIID-5275 URL: https://issues.jboss.org/browse/TEIID-5275 Project: Teiid Issue Type: Bug Components: OData Affects Versions: 8.12.11.6_4 Reporter: Jan Martiska Assignee: Steven Hawkins Given that {{BQT1.SmallA}} is a view backed by Odata4 translator, both of these queries fail: {noformat} SELECT intnum FROM BQT1.SmallA WHERE intnum IS NOT NULL SELECT intnum FROM BQT1.SmallA WHERE NOT(intnum IS NULL) {noformat} The problem is that this is translated to a OData request like this: {noformat} http://localhost:8080/odata4/csv/bqt1/SmallA?%24select=intnum&%24filt... {noformat} This request fails with: {noformat} The property 'not', used in a query expression, is not defined in type 'csv.1.bqt1.SmallA'. {noformat} A working URL which would return the correct rows would be: {noformat} http://localhost:8080/odata4/csv/bqt1/SmallA?%24select=intnum&%24filt... {noformat}