]
Steven Hawkins reassigned TEIID-5761:
-------------------------------------
Assignee: Steven Hawkins (was: Barry LaFond)
ConvertVDB incorrectly converts older style chained imports
-----------------------------------------------------------
Key: TEIID-5761
URL:
https://issues.jboss.org/browse/TEIID-5761
Project: Teiid
Issue Type: Quality Risk
Components: Tooling
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Priority: Major
Fix For: 12.3
{code}
<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>
{code}
Results in:
{code}
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}";
{code}