[teiid-issues] [JBoss JIRA] (TEIID-4912) DDL VDB doesn't support CREATE GLOBAL TEMPORARY TABLE

[Kylin Soong (JIRA)]

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

Kylin Soong commented on TEIID-4912:
------------------------------------

Why I has this kinds of requirements? because, as per my thought, the translator/connector are auto-detected and setup automatically, so the only left is create a virtual database, and create Views, Tables, etc.

If deploy with xml as bellow, it works fine.
{code}
<vdb name="Portfolio" version="1">

    <model name="Sample" type="VIRTUAL">
        <metadata type="DDL"><![CDATA[
        CREATE GLOBAL TEMPORARY TABLE GTEMP (id SERIAL, name string, PRIMARY KEY (id)) OPTIONS (UPDATABLE 'true');
]]> </metadata>
    </model>

</vdb>
{code}

> DDL VDB doesn't support CREATE GLOBAL TEMPORARY TABLE
> -----------------------------------------------------
>
>                 Key: TEIID-4912
>                 URL: https://issues.jboss.org/browse/TEIID-4912
>             Project: Teiid
>          Issue Type: Quality Risk
>    Affects Versions: 9.3
>            Reporter: Kylin Soong
>            Assignee: Steven Hawkins
>             Fix For: 10.0
>
>
> I tried to deploy VDB via ddl via embedded server, my ddl looks
> {code}
> CREATE DATABASE Portfolio;
> CREATE GLOBAL TEMPORARY TABLE GTEMP (id SERIAL, name string, PRIMARY KEY (id)) OPTIONS (UPDATABLE 'true');
> {code}
> But the deployment failed with trace:
> {code}
> Exception in thread "main" org.teiid.metadata.ParseException: TEIID31259 In the statement ending with token GTEMP on line 2 column 31 the ddl is not valid: TEIID31246 No database in context; Try using "create database ..." or "use database ..." first.
> 	at org.teiid.query.parser.QueryParser.parseDDL(QueryParser.java:567)
> 	at org.teiid.metadatastore.DeploymentBasedDatabaseStore.getVDBMetadata(DeploymentBasedDatabaseStore.java:79)
> 	at org.teiid.runtime.EmbeddedServer.deployVDB(EmbeddedServer.java:738)
> 	at org.teiid.test.teiid4911.TEIID4911.main(TEIID4911.java:32)
> Caused by: org.teiid.metadata.MetadataException: TEIID31246 No database in context; Try using "create database ..." or "use database ..." first.
> 	at org.teiid.query.metadata.DatabaseStore.getCurrentDatabase(DatabaseStore.java:405)
> 	at org.teiid.query.metadata.DatabaseStore.createMF(DatabaseStore.java:844)
> 	at org.teiid.query.parser.SQLParser.createTable(SQLParser.java:14002)
> 	at org.teiid.query.parser.SQLParser.ddlStmt(SQLParser.java:12596)
> 	at org.teiid.query.parser.SQLParser.parseMetadata(SQLParser.java:12577)
> 	at org.teiid.query.parser.QueryParser.parseDDL(QueryParser.java:561)
> 	... 3 more
> {code}



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