[teiid-issues] [JBoss JIRA] (TEIID-3732) Enable Infinispan-cache translator to negate intNum <> 1 returning true when column is null

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13370893#comment-13370893 ] 

Steven Hawkins commented on TEIID-3732:
---------------------------------------

Google spreadsheets had a similar issue. It affected even ordered comparisons there since null was treated as a low value, so that may need to be checked here.  Since Teiid does normalize / flatten the predicates prior to pushdown, this is valid workaround.

> Enable Infinispan-cache translator to negate  intNum <> 1 returning true when column is null
> --------------------------------------------------------------------------------------------
>
>                 Key: TEIID-3732
>                 URL: https://issues.jboss.org/browse/TEIID-3732
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: JDG Connector
>            Reporter: Van Halbert
>            Assignee: Van Halbert
>
> This is related to TEIID-3573.     To add a support option so that when the translator  sees criteria like intNum<>1 it would need to produce "intNum<>1 and intNum IS NOT NULL". 
> This would negate the issue in JDG where it resolves intNum <> 1 to true when the column is null.



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)