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

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 Fix For: 10.0 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