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

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-4713:
---------------------------------------

[~lfabriko] I don't see anywhere in the translator that we could possibly be creating the wrong source query.  Can you run queries directly against Hana to confirm that this is their issue?

[~tejones] Can you confirm if this a known issue.

If both equality and ordered comparisons have issues that will severely impact performance.  Perhaps this could be narrowed down to a particular type, such as just floats?

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