[teiid-issues] [JBoss JIRA] (TEIID-4629) Offer a ddl solution to replace the vdb.xml

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-4629:
---------------------------------------

> So how is "schema" context established?

You need to be explicit.

CREATE DATABASE FOO;
USE DATABASE FOO;

CREATE SCHEMA X;
SET SCHEMA X;
....

Otherwise we'll need to support specifying the schema as part of the object names "CREATE VIEW X.TBL..." - but that of course conflicts with a lot of legacy.


> Offer a ddl solution to replace the vdb.xml
> -------------------------------------------
>
>                 Key: TEIID-4629
>                 URL: https://issues.jboss.org/browse/TEIID-4629
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Query Engine, Server
>            Reporter: Steven Hawkins
>            Assignee: Ramesh Reddy
>             Fix For: 9.2
>
>
> Based upon the work on TEIID-2578 we should first offer the ability to replace the vdb.xml with ddl.  We can additionally include some of the work to represent additional pieces of the vdb as api level metadata objects (instead of in the admin layer) where possible.  Ideally this should support as much alter functionality as possible.



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)