[teiid-issues] [JBoss JIRA] (TEIID-5860) Need to properly generate SOQL for self joins

[Renat Eskenin (Jira)]

Renat Eskenin created TEIID-5860:
------------------------------------

             Summary: Need to properly generate SOQL for self joins
                 Key: TEIID-5860
                 URL: https://issues.jboss.org/browse/TEIID-5860
             Project: Teiid
          Issue Type: Enhancement
          Components: Salesforce Connector
            Reporter: Renat Eskenin
            Assignee: Steven Hawkins


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 wrong two requests to salesforce but need one.



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