[teiid-issues] [JBoss JIRA] (TEIID-4849) Google translator behaves unexpectedly with Double in WHERE clause of SELECT
Steven Hawkins (JIRA)
issues at jboss.org
Wed Apr 5 11:50:00 EDT 2017
[ https://issues.jboss.org/browse/TEIID-4849?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13389535#comment-13389535 ]
Steven Hawkins commented on TEIID-4849:
---------------------------------------
This is not reproducible for me. It may be a locale difference as to why 15.1 is treated as a number for me. This may require you to turn off auto typing/formatting.
> 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)
More information about the teiid-issues
mailing list