[teiid-issues] [JBoss JIRA] Updated: (TEIID-209) SalesForce Connector should support semi-join and anti-join pushdown upon release of 14.0 API

[Steven Hawkins (JIRA)]

     [ https://jira.jboss.org/jira/browse/TEIID-209?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins updated TEIID-209:
---------------------------------

          Component/s: Salesforce Connector
        Fix Version/s: 6.1.0
    Affects Version/s: 6.0.0


> SalesForce Connector should support semi-join and anti-join pushdown upon release of 14.0 API
> ---------------------------------------------------------------------------------------------
>
>                 Key: TEIID-209
>                 URL: https://jira.jboss.org/jira/browse/TEIID-209
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Salesforce Connector
>    Affects Versions: 6.0.0
>            Reporter: Michael Walker
>            Assignee: John Doyle
>             Fix For: 6.1.0
>
>
> SalesForce API 14.0 is adding support for semi-joins and anti-joins, e.g.:
>  SELECT Id, Name 
>  FROM Account 
>  WHERE Id IN 
> (SELECT AccountId FROM Opportunity WHERE StageName = 'Closed Lost')
> Supporting pushdown in these situations could improve query performance dramatically in some cases. 
> It appears that the API puts a number of odd restrictions on the use of these "joins", which may make the implementation difficult.
> See http://www.salesforce.com/us/developer/docs/api/index.htm for details (search the index for SOQL select).

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira