[teiid-issues] [JBoss JIRA] (TEIID-5275) OData4 translator doesn't handle IS NOT NULL condition properly

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-5275?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-5275.
-----------------------------------
    Fix Version/s: 10.0.4
                   10.2
                   10.1.2
       Resolution: Done


Addressed this on the Teiid side by switching to ne null instead.  However it will be good to have https://issues.apache.org/jira/browse/OLINGO-1245 resolved as well [~rareddy] is that something you will take?

> 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
>             Fix For: 10.0.4, 10.2, 10.1.2
>
>
> 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&%24filter=not(intnum%20eq%20null)
> {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&%24filter=intnum%20ne%20null
> {noformat}



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