[teiid-issues] [JBoss JIRA] (TEIID-5851) teiid rename table in salesforce

[Renat Eskenin (Jira)]

    [ https://issues.jboss.org/browse/TEIID-5851?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13814244#comment-13814244 ] 

Renat Eskenin commented on TEIID-5851:
--------------------------------------

Used ddl


{code}
CREATE DATABASE db;
USE DATABASE db;
CREATE FOREIGN DATA WRAPPER salesforce;
CREATE FOREIGN DATA WRAPPER mysalesforce type salesforce OPTIONS (supportsOrderBy true, NormalizeNames false);
CREATE SERVER salesforce FOREIGN DATA WRAPPER mysalesforce OPTIONS ("resource-name" 'salesforce');
CREATE SCHEMA sf SERVER salesforce;
IMPORT FROM SERVER salesforce INTO sf OPTIONS("importer.useFullSchemaName" 'false');
{code}

{code}
[2019-11-18 15:48:39,320 MSK] DEBUG [salesforce-failover-facade,,,] org.teiid.spring.autoconfigure.TeiidServer                   [restartedMain]: XML Form of VDB:
<?xml version="1.0" encoding="UTF-8"?>
<vdb name="db" version="1">
  <connection-type>BY_VERSION</connection-type>
  <property name="full-ddl" value="CREATE DATABASE db; USE DATABASE db; CREATE FOREIGN DATA WRAPPER salesforce; CREATE FOREIGN DATA WRAPPER mysalesforce type salesforce OPTIONS (supportsOrderBy true, NormalizeNames false); CREATE SERVER salesforce FOREIGN DATA WRAPPER mysalesforce OPTIONS (&quot;resource-name&quot; 'salesforce'); CREATE SCHEMA sf SERVER salesforce; IMPORT FROM SERVER salesforce INTO sf OPTIONS(&quot;importer.useFullSchemaName&quot; 'false');  --SET SCHEMA sf;  --ALTER TABLE User_ --RENAME TO User_1;"/>
  <model name="sf" type="PHYSICAL" visible="true">
    <source connection-jndi-name="salesforce" name="salesforce" translator-name="mysalesforce"/>
    <metadata type="DDL"/>
  </model>
  <translator name="mysalesforce" type="salesforce">
    <property name="NormalizeNames" value="false"/>
    <property name="supportsOrderBy" value="true"/>
  </translator>
</vdb>
{code}

Table name 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)