Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-3564

float field gets converted to scientific notation when query is submitted to source

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 8.7.1
    • Fix Version/s: 8.12, 8.11.5, 8.7.2.6_2
    • Component/s: Query Engine
    • Labels:
      None
    • 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

      Description

      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?

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                jorge.herrera Jorge Herrera
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: