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

[Juraj Duráni (JIRA)]

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

Juraj Duráni commented on TEIID-4713:
-------------------------------------

[~shawkins] In this case I think it's not a problem. FloatNum is of type float, i.e. floating point number. So _FloatNum = 11814.4_ might not be evaluated to true for any value even if respective value seems to be in the table.
We will check this again and let you know.

> 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)