]
Steven Hawkins commented on TEIID-5851:
---------------------------------------
User is a reserved word. It must be quoted to be used as an identifier:
... FROM "User"
teiid rename table in salesforce
--------------------------------
Key: TEIID-5851
URL:
https://issues.jboss.org/browse/TEIID-5851
Project: Teiid
Issue Type: Bug
Components: Salesforce Connector
Reporter: Renat Eskenin
Assignee: Steven Hawkins
Priority: Major
In example project connected to SF i have a table named "User" in SF but
"User_" in teiid metadata.
And another strange behavior is: system tables from teiid as GEOGRAPHY_COLUMNS
GEOMETRY_COLUMNS placed in teiid server to same schema as Salesforce tables. May be
"User_" named because we have same name in teiid metadata system names?
So, select "SELECT Id, User.FirstName, User.LastName FROM Task LEFT OUTER JOIN User
ON User.Id=Task.OwnerId" do not working.