[teiid-issues] [JBoss JIRA] (TEIID-4536) Support create schema with multiple statements

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-4536:
---------------------------------------

Made some of the parsing changes to support this, but did not yet commit.  For full round-tripping it would require that the ddl generation logic can optionally omit the semi-colons to directly associate the ddl to the schema.  If we do this though, then we should have a direct correlation to the vdb.xml in ddl - as the biggest weakspot left is the handling of mixed metadata tags under a model element:

<model...
   <metadata type="DDL">ddl</metadata>
   <metadata ... other
</model>

will now translate to

create schema x;

import other ...

set schema x;

ddl

Note that the ddl is forced to logically happen after the other imports regardless of the tag ordering.

With this JIRA worked, we would instead have:

create schema x
  ddl
  import other tags ...
  ;

Such that the order is preserved and all schema scoped more concisely associated with the create.

> Support create schema with multiple statements
> ----------------------------------------------
>
>                 Key: TEIID-4536
>                 URL: https://issues.jboss.org/browse/TEIID-4536
>             Project: Teiid
>          Issue Type: Sub-task
>          Components: Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>            Priority: Critical
>             Fix For: 9.3
>
>
> Create schema can support following create statements being directly associated rather than requiring an intermediate use schema
> create schema x
> create view ...
> ...
> ;



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