[teiid-issues] [JBoss JIRA] (TEIID-4713) HANA translator evaluates > as >=

[Lucie Fabrikova (JIRA)]

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

Lucie Fabrikova commented on TEIID-4713:
----------------------------------------

I re-tested query both directly against Hana and via sap hana translator, and in both cases both > and >= worked as expected (ie > didn't delete also = rows). 
I am sorry,  there seems to be problem only in our test data...

> HANA translator evaluates > as >=
> ---------------------------------
>
>                 Key: TEIID-4713
>                 URL: https://issues.jboss.org/browse/TEIID-4713
>             Project: Teiid
>          Issue Type: Bug
>          Components: Misc. Connectors
>    Affects Versions: 9.2
>            Reporter: Lucie Fabrikova
>            Assignee: Ted Jones
>             Fix For: 9.2
>
>         Attachments: sap-hana_crud-vdb.xml
>
>
> HANA translator evaluates > as >= in following query:
> DELETE FROM SmallA WHERE FloatNum > 11814.4
> I observed rows where FloatNum = 11814.4 were also deleted.
> Next observations:
> - query DELETE FROM SmallA WHERE FloatNum = 11814.4 deleted no rows.
> - <= was evaluated as <



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