[teiid-issues] [JBoss JIRA] (TEIID-4849) Google translator behaves unexpectedly with Double in WHERE clause of SELECT

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-4849?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

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)