]
Steven Hawkins resolved TEIID-3128.
-----------------------------------
Resolution: Done
Moved the inner join handling into the translator. This will then appropriately handle
both the parent to child (converted to child to parent) and child to parent to cases.
Issue while querying Salesforce.
---------------------------------
Key: TEIID-3128
URL:
https://issues.jboss.org/browse/TEIID-3128
Project: Teiid
Issue Type: Bug
Components: Salesforce Connector
Affects Versions: 8.4
Reporter: Pranav K
Assignee: Steven Hawkins
Fix For: 8.9
(I am using Teiid Embedded 8.8.0.Final)
Please refer to this forum thread for exact analysis/details:
https://developer.jboss.org/thread/248796
Steps to reproduce at my end:
1) Use tables Account and Contact where AccountId in Contact is the child field for Id in
Account.
2) Execute the queries as shown in the steps below
3)Execute the query: SELECT Account.Phone, Account.Name, Account.Type, Contact.LastName
FROM Account, Contact WHERE Account.Id = Contact.AccountId (GIVES ERROR)
-Changing the order of the From part makes it run fine