[
https://issues.jboss.org/browse/TEIID-4849?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-4849.
-----------------------------------
Fix Version/s: (was: 10.0)
Resolution: Rejected
After reviewing this in light of TEIID-4854, this is not an issue. For the read case the
user's worksheet can be in any locale - it is not expected that the values are
formatted to SQL/Teiid literals. As long as the column is recognized as numeric, then the
Teiid user query will work as expected.
Google translator behaves unexpectedly with Double in WHERE clause of
SELECT
----------------------------------------------------------------------------
Key: TEIID-4849
URL:
https://issues.jboss.org/browse/TEIID-4849
Project: Teiid
Issue Type: Feature Request
Components: Misc. Connectors
Affects Versions: 8.12.10.6_3
Reporter: Lucie Fabrikova
Priority: Minor
Query like "SELECT DoubleNum FROM SmallA WHERE DoubleNum > 5.0" gives
unexpected results for following values in DoubleNum column:
* value like '15.1' is probably by google spreadsheet interpreted as date (in
function row in sheet appears 15.1.2017), SELECT query returns no results
* value like '150.1': SELECT returns null
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)