[teiid-issues] [JBoss JIRA] (TEIID-5851) teiid rename table in salesforce
[
https://issues.jboss.org/browse/TEIID-5851?page=com.atlassian.jira.plugin...
]
Renat Eskenin edited comment on TEIID-5851 at 11/18/19 8:43 AM:
----------------------------------------------------------------
Yes, name of table is User, but request do not working, its so strange.
I call "Select Name From Tables" and get "User" name of table User in
sf. But request do not working.
And simple check do not working with this name
{code:sql}
Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error:
Encountered "SELECT Id FROM [*]User[*] LIMIT 1" at line 1, column 16.
Was expecting: "table" | "lateral" | "xmltable" | id |
<ESCAPEDJOIN> | "("
{code}
"Select name from tables" get
"
UndecidedEventRelation
User
UserAppInfo
"
was (Author: i3draven):
Yes, name of table is User, but request do not working, its so strange.
I call "Select Name From Tables" and get "User" name of table User in
sf. But request do not working.
And simple check do not working with this name
{code:sql}
Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error:
Encountered "SELECT Id FROM [*]User[*] LIMIT 1" at line 1, column 16.
Was expecting: "table" | "lateral" | "xmltable" | id |
<ESCAPEDJOIN> | "("
{code}
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.
--
This message was sent by Atlassian Jira
(v7.13.8#713008)