[teiid-issues] [JBoss JIRA] (TEIID-5851) teiid rename table in salesforce
Renat Eskenin (Jira)
issues at jboss.org
Mon Nov 18 08:11:00 EST 2019
[ https://issues.jboss.org/browse/TEIID-5851?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13814258#comment-13814258 ]
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', "NormalizeNames" 'false');
{code}
Table is still 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.
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
More information about the teiid-issues
mailing list