[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 commented on TEIID-5851:
--------------------------------------
{code}
CREATE DATABASE db;
USE DATABASE db;
CREATE FOREIGN DATA WRAPPER salesforce;
CREATE SERVER salesforce FOREIGN DATA WRAPPER salesforce OPTIONS
("resource-name" 'salesforce');
CREATE SCHEMA sf SERVER salesforce;
IMPORT FROM SERVER salesforce INTO sf OPTIONS("importer.useFullSchemaName"
'false', "importer.NormalizeNames" 'false');
{code}
Do not working
Request
{code:sql}
SELECT Task.Id, User.FirstName, User.LastName FROM Task LEFT OUTER JOIN User ON
User.Id=Task.OwnerId WHERE User.FirstName LIKE 'B%' LIMIT 1
{code}
Error
{code:java}
org.teiid.jdbc.TeiidSQLException: TEIID31100 Parsing error: Encountered "LEFT OUTER
JOIN [*]User[*] ON User.Id" at line 1, column 73.
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)