[
https://issues.jboss.org/browse/TEIID-4713?page=com.atlassian.jira.plugin...
]
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)