Details

    • Type: Bug
    • Status: Resolved (View Workflow)
    • Priority: Major
    • Resolution: Explained
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Salesforce Connector
    • Labels:
      None
    • Steps to Reproduce:
      Hide

      I used DDL

      CREATE DATABASE db;
      USE DATABASE db;
      CREATE FOREIGN DATA WRAPPER salesforce;
      CREATE FOREIGN DATA WRAPPER mysalesforce type salesforce OPTIONS (supportsOrderBy true);
      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');

      Show
      I used DDL CREATE DATABASE db; USE DATABASE db; CREATE FOREIGN DATA WRAPPER salesforce; CREATE FOREIGN DATA WRAPPER mysalesforce type salesforce OPTIONS (supportsOrderBy true); 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');

      Description

      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.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                i3draven Renat Eskenin
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: