Mark Tawk created TEIID-3391: -------------------------------- Summary: Double value is truncated in Where clause Key: TEIID-3391 URL: https://issues.jboss.org/browse/TEIID-3391 Project: Teiid Issue Type: Feature Request Reporter: Mark Tawk Assignee: Steven Hawkins Priority: Blocker I'm using Teiid 8.10.0 Final over H2 Database. I have an H2 table containing a field of Type Double. When i add a where condition over this field with a double value, this value is truncated by Teiid and the query returns no records. You find below the query executed with Teiid and the execution plan: select "Locations"."Sheet0_EPr_090315_Lat" as "LAT_MapCalculatedField","Locations"."Sheet0_EPr_090315_Long" as "LNG_MapCalculatedField","Locations"."Sheet0_EPr_090315_SDView_INC" as "Locations_Sheet0_EPr_090315_1",COUNT( distinct "IM123View"."SDView_INCIDENTSM1_INCIDENT_") as "IM123View_SDView_INCIDENTSM1" from "implifyBusinessModel"."IM123View" "IM123View" LEFT JOIN "implifyBusinessModel"."Locations" "Locations" ON "IM123View"."SDView_INCIDENTSM1_LOCATION_" = "Locations"."Sheet0_EPr_090315_SDView_INC" where ("Locations"."Sheet0_EPr_090315_Lat" IN (31.953582763671875) ) group by "Locations"."Sheet0_EPr_090315_Lat","Locations"."Sheet0_EPr_090315_Long","Locations"."Sheet0_EPr_090315_SDView_INC" -----Teiid Show Plan ---- <?xml version='1.0' encoding='UTF-8'?><node name="AccessNode"><property name="Relational Node ID"><value>1</value></property><property name="Output Columns"><value>LAT_MapCalculatedField (float)</value><value>LNG_MapCalculatedField (float)</value><value>Locations_Sheet0_EPr_090315_1 (string)</value><value>IM123View_SDView_INCIDENTSM1 (integer)</value></property><property name="Statistics"><value>Node Output Rows: 0</value><value>Node Next Batch Process Time: 0</value><value>Node Cumulative Next Batch Process Time: 0</value><value>Node Cumulative Process Time: 16</value><value>Node Next Batch Calls: 2</value><value>Node Blocks: 1</value></property><property name="Cost Estimates"><value>Estimated Node Cardinality: -1.0</value></property><property name="Query"><value> SELECT g_1.Sheet0_EPr_090315_Lat, g_1.Sheet0_EPr_090315_Long, g_1.Sheet0_EPr_090315_SDView_INC, COUNT(DISTINCT g_0.SDView_INCIDENTSM1_INCIDENT_) FROM implify_viewModel.implify_view.IM123View AS g_0, implify_viewModel.implify_view.Locations AS g_1 WHERE (g_0.SDView_INCIDENTSM1_LOCATION_ = g_1.Sheet0_EPr_090315_SDView_INC) AND (g_1.Sheet0_EPr_090315_Lat = 31.953583) GROUP BY g_1.Sheet0_EPr_090315_Lat, g_1.Sheet0_EPr_090315_Long, g_1.Sheet0_EPr_090315_SDView_INC</value></property><property name="Model Name"><value>implify_viewModel</value></property><property name="Data Bytes Sent"><value>0</value></property></node> -- This message was sent by Atlassian JIRA (v6.3.11#6341)