[
https://issues.jboss.org/browse/TEIID-4849?page=com.atlassian.jira.plugin...
]
Lucie Fabrikova commented on TEIID-4849:
----------------------------------------
In my case, locale of google sheet was set to 'Czechia', for double format
'15,1'.
If I switch locale to 'UK', it works correctly with teiid double format
'15.1'.
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: Bug
Affects Versions: 8.12.10.6_3
Reporter: Lucie Fabrikova
Assignee: Steven Hawkins
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)