[JBoss JIRA] (TEIID-4849) Google translator behaves unexpectedly with Double in WHERE clause of SELECT
by Steven Hawkins (JIRA)
[ 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 …
[View More]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)
[View Less]
7 years, 11 months