[
https://issues.jboss.org/browse/TEIID-1903?page=com.atlassian.jira.plugin...
]
Graeme Gillies commented on TEIID-1903:
---------------------------------------
Hi,
That sounds ok to me, thanks for the explanation, are you able to create an enhancement
for the salesforce adaptor to be upgraded to salesforce api version 18?
Regards,
Graeme
count() function with salesforce adaptor not behaving correctly
---------------------------------------------------------------
Key: TEIID-1903
URL:
https://issues.jboss.org/browse/TEIID-1903
Project: Teiid
Issue Type: Bug
Components: Salesforce Connector
Affects Versions: 7.5
Environment: java version "1.6.0_20"
OpenJDK Runtime Environment (IcedTea6 1.9.10) (rhel-1.23.1.9.10.el5_7-x86_64)
OpenJDK 64-Bit Server VM (build 19.0-b09, mixed mode)
on
Red Hat Enterprise Linux Server release 5.7 (Tikanga)
Reporter: Graeme Gillies
Assignee: Steven Hawkins
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
{noformat}
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=>
{noformat}
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.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see:
http://www.atlassian.com/software/jira