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

ConvertVDB incorrectly converts older style chained imports

    XMLWordPrintable

Details

    • Quality Risk
    • Resolution: Done
    • Major
    • 12.3
    • None
    • Tooling
    • 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}";
      

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            rhn-engineering-shawkins Steven Hawkins
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: