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

Additional aggregates and grouping should be supported by salesforce

    XMLWordPrintable

Details

    • Enhancement
    • Resolution: Done
    • Major
    • 7.7
    • 7.5
    • Salesforce Connector
    • None
    • Release Notes
    • Low

    Description

      Hi,

      I noticed the following strange behaviour with the salesforce connector. In the below example, Bugzilla is normal JDBC datasource to a mysqldb, while SFDC is a salesforce.com datasource

      EngVDBR=> select count(*) from Bugzilla.bugs;
 count  
--------
 604680
(1 row)

EngVDBR=> select count(*) from SFDC.salesforce.Case_;
 count  
--------
 455487
(1 row)

EngVDBR=> select count(1) from SFDC.salesforce.Case_;
ERROR:  SalesforceAPI: The number of result rows has exceeded the maximum result rows "100,000"
DETAIL:  org.teiid.jdbc.TeiidSQLException: SalesforceAPI: The number of result rows has exceeded the maximum result rows "100,000"
EngVDBR=> select count(1) from Bugzilla.bugs;
 count  
--------
 604680
(1 row)

EngVDBR=>

      I would have expected count(1) on salesforce to work the same as count, but it returns the maxrows error even though it should only return one row.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            graeme.gillies Graeme Gillies (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: