Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-5761

ConvertVDB incorrectly converts older style chained imports

    Details

    • Type: Quality Risk
    • Status: Resolved (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 12.3
    • Component/s: Tooling
    • Labels:
      None

      Description

      <vdb name="{vdb-name}" version="1">
          <model name="{model-name}" type="PHYSICAL">
              <source name="AccountsDB" translator-name="oracle" connection-jndi-name="java:/oracleDS"/>
              <metadata type="NATIVE,DDL"><![CDATA[
                 CREATE FOREIGN FUNCTION SCORE (val integer) RETURNS integer;
               ]]>
              </metadata>
          </model>
      </vdb>
      

      Results in:

      CREATE DATABASE "{vdb-name}" VERSION '1';
      USE DATABASE "{vdb-name}" VERSION '1';
      
      --############ Translators ############
      CREATE FOREIGN DATA WRAPPER oracle;
      
      --############ Servers ############
      CREATE SERVER AccountsDB FOREIGN DATA WRAPPER oracle OPTIONS ("jndi-name" 'java:/oracleDS');
      
      --############ Schemas ############
      CREATE SCHEMA "{model-name}" SERVER AccountsDB;
      
      
      --############ Schema:{model-name} ############
      SET SCHEMA "{model-name}";
      
      IMPORT FROM REPOSITORY "NATIVE,DDL" INTO "{model-name}";
      

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                shawkins Steven Hawkins
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: