[JBoss JIRA] (TEIID-4912) DDL VDB doesn't support CREATE GLOBAL TEMPORARY TABLE
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4912?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-4912.
-----------------------------------
Fix Version/s: (was: 10.0)
Resolution: Rejected
Marking as rejected. Although we will need more examples to show full ddl vdbs.
> 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
>
> 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)
8 years, 10 months
[JBoss JIRA] (TEIID-4914) Create seperate CLI script for installing into ha and full-ha profiles
by Van Halbert (JIRA)
Van Halbert created TEIID-4914:
----------------------------------
Summary: Create seperate CLI script for installing into ha and full-ha profiles
Key: TEIID-4914
URL: https://issues.jboss.org/browse/TEIID-4914
Project: Teiid
Issue Type: Bug
Components: Build/Kits
Affects Versions: 8.12.x-6.4
Reporter: Van Halbert
Assignee: Steven Hawkins
When installing into ha or full-ha profiles, the infinspan resultset-repl cache isn't being defined as replicated. In order to do this, the current CLI script needs to be duplicated and then updated according. This will enable installation to use the appropriate script.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 10 months