[teiid-issues] [JBoss JIRA] (TEIID-5860) Salesforce translator should support self joins

[Steven Hawkins (Jira)]

    [ https://issues.redhat.com/browse/TEIID-5860?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13968756#comment-13968756 ] 

Steven Hawkins commented on TEIID-5860:
---------------------------------------

A pr has been opened with the changes.  Self-join support bleeds into results processing - we need to be aware of the structure, not just the sobject types.  So that further complicates supporting arbitrary join trees.  That means the nested join support will need to wait for another release.

> Salesforce translator should support self joins
> -----------------------------------------------
>
>                 Key: TEIID-5860
>                 URL: https://issues.redhat.com/browse/TEIID-5860
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: Salesforce Connector
>            Reporter: Renat Eskenin
>            Assignee: Steven Hawkins
>            Priority: Major
>             Fix For: 13.1
>
>   Original Estimate: 3 hours
>          Time Spent: 3 hours
>  Remaining Estimate: 0 minutes
>
> In this query 
> {code}
> SELECT originalLicense.Id,originalLicense.Status__c,originalLicense.ReplacementLicenseID__c,originalLicense.LicenseId__c,originalLicense.vlic_Contract_Number__c,replacementLicense.LicenseId__c as replacementLicenseId ,replacementLicense.LicenseId__c as replacementLicenseLicenseId FROM Product_License__c originalLicense LEFT OUTER JOIN /*+ MAKEDEP */ Product_License__c replacementLicense ON originalLicense.ReplacementLicenseID__c = replacementLicense.Id where originalLicense.vlic_Contract_Number__c = :contractNumber
> {code}
> We have two requests to salesforce, but could generate a single SOQL query.



--
This message was sent by Atlassian Jira
(v7.13.8#713008)