[JBoss JIRA] (TEIID-5860) Salesforce translator should support self joins
- First Post
- Replies
- Stats
-
Go to
- ----- 2025 -----
- January
- ----- 2024 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2023 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2022 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2021 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2020 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2019 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2018 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2017 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2016 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2015 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2014 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2013 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2012 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2011 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2010 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2009 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
[
https://issues.redhat.com/browse/TEIID-5860?page=com.atlassian.jira.plugi...
]
Steven Hawkins commented on TEIID-5860:
---------------------------------------
I was able to update the visitor logic to use named tables rather than source names so
that it can differentiate between the sides of a self join. However the execution/results
logic is not equipped to handle the self join scenario as it only finds results by object
type. So this will take longer than expected.
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
Remaining Estimate: 3 hours
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)
1800
days inactive
1800
days old
0 comments
1 participants
tags (0)
participants (1)
-
Steven Hawkins (Jira)