[JBoss JIRA] (TEIID-4713) HANA translator evaluates > as >=
- First Post
- Replies
- Stats
-
Go to
- ----- 2025 -----
- March
- February
- January
- ----- 2024 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2023 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2022 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2021 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2020 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2019 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2018 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2017 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2016 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2015 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2014 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2013 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2012 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2011 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2010 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2009 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
[
https://issues.jboss.org/browse/TEIID-4713?page=com.atlassian.jira.plugin...
]
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)
2960
days inactive
2960
days old
0 comments
1 participants
tags (0)
participants (1)
-
Lucie Fabrikova (JIRA)