Bug 1265772 (TEIID-3564)

Summary: float field gets converted to scientific notation when query is submitted to source
Product: [JBoss] JBoss Data Virtualization 6 Reporter: dsteigne
Component: TeiidAssignee: jolee
Status: CLOSED CURRENTRELEASE QA Contact: Filip Elias <felias>
Severity: high Docs Contact:
Priority: unspecified    
Version: 6.2.0CC: aszczucz, drieden, jolee, jstastny
Target Milestone: ---Keywords: QA-Closed
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2016-02-10 08:52:13 UTC Type: Support Patch
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 1242071    

Description dsteigne 2015-09-23 17:40:48 UTC 
Description of problem:
See https://issues.jboss.org/browse/TEIID-3564



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?

Version-Release number of selected component (if applicable):


How reproducible:


Steps to Reproduce:
1.
2.
3.

Actual results:


Expected results:


Additional info:
Comment 2 jolee 2015-09-29 20:42:47 UTC 
git:jboss-integration/teiid.git : 8.7.x-prod-ipv6.2 : 246d68f

git:teiid/teiid.git : 62-8.7.x : 246d68f
Comment 3 JBoss JIRA Server 2015-10-13 12:06:05 UTC 
Steven Hawkins <shawkins> updated the status of jira TEIID-3564 to Closed
Comment 4 JBoss JIRA Server 2015-11-06 14:13:06 UTC 
Johnathon Lee <jolee> updated the status of jira TEIID-3564 to Reopened
Comment 5 JBoss JIRA Server 2015-11-06 14:13:22 UTC 
Johnathon Lee <jolee> updated the status of jira TEIID-3564 to Closed