[JBoss JIRA] (TEIID-4713) HANA translator evaluates > as >=
- First Post
- Replies
- Stats
-
Go to
- ----- 2025 -----
- 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...
]
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)
2893
days inactive
2893
days old
0 comments
1 participants
tags (0)
participants (1)
-
Juraj Duráni (JIRA)