float field gets converted to scientific notation when query is submitted to source ----------------------------------------------------------------------------------- Key: TEIID-3564 URL: https://issues.jboss.org/browse/TEIID-3564 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 8.7.1 Environment: RHEL 6, AWS Virtual Machine, salesforce.com soap api 23.0,JBoss EAP (standalone) 6.3.2.GA JBoss Data Virtualization 6.1.0.ER4 Reporter: Jorge Herrera Assignee: Steven Hawkins Fix For: 8.12, 8.11.5, 8.7.2.6_2 When submitting the following query: SELECT COUNT(*) FROM salesforce_sales.salesforce.Opportunity where amount > 100000000; to a salesforce instance with the shown filter it returns the following error: org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidProcessingException: TEIID30504 SalesForce_Sales: com.sforce.soap.partner.MalformedQueryFault: MALFORMED_QUERY: Opportunity WHERE Opportunity.Amount > 1.0E8 ^ ERROR at Row:1:Column:64 unexpected token: 'E8' Elapsed Time: 0 hr, 0 min, 1 sec, 109 ms. why is the quantity modified when the field is declared as float?