[JBoss JIRA] (TEIID-3349) Allow column type to be altered
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-3349?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-3349:
-------------------------------------
Looks like current ALTER support is limited to adding and removing the OPTIONS, but not modifying the TYPE information. This can be accomplished with following syntax
{code}
ALTER TABLE {table-name} ALTER COLUMN {column-name} TYPE {new-type};
{code}
Note that this can be done only on source tables, not on View tables, as View table support with DDL was limited to the implicit columns based on the transformation of the View. For any column level changes (ADD, REMOVE, ALTER) , the transformation can be updated to reflect the new required change.
> Allow column type to be altered
> -------------------------------
>
> Key: TEIID-3349
> URL: https://issues.jboss.org/browse/TEIID-3349
> Project: Teiid
> Issue Type: Sub-task
> Components: Query Engine
> Reporter: Steven Hawkins
> Assignee: Ramesh Reddy
> Fix For: 9.3
>
>
> Add ddl support for alter column type to assist in importing.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 4 months
[JBoss JIRA] (TEIID-4724) Allow support for vdb.ddl in the .vdb files
by Ramesh Reddy (JIRA)
Ramesh Reddy created TEIID-4724:
-----------------------------------
Summary: Allow support for vdb.ddl in the .vdb files
Key: TEIID-4724
URL: https://issues.jboss.org/browse/TEIID-4724
Project: Teiid
Issue Type: Enhancement
Components: VDB
Reporter: Ramesh Reddy
Assignee: Ramesh Reddy
With the DDL based metadata, ".vdb" file archive should allow to contain a "vdb.ddl" file that can be deployed. Based on TEIID-4719 this needs to allow to load metadata from INDEX and DDL-FILE metadata repositories.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 4 months
[JBoss JIRA] (TEIID-4644) anonymous block dynamic issues
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4644?page=com.atlassian.jira.plugin... ]
Work on TEIID-4644 started by Steven Hawkins.
---------------------------------------------
> anonymous block dynamic issues
> ------------------------------
>
> Key: TEIID-4644
> URL: https://issues.jboss.org/browse/TEIID-4644
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 9.2
>
>
> Using execute immediate 'begin ... end'
> Has several issues. First any variable references such as rowcount will be rewritten in the outer scope and not evaluated as part of the procedure. Also the anonymous block cannot be used with targeting an into as the statement we create is insert into select ... from (begin ... end) .. - which is not valid, however the exception message does not make this clear.
> So we either need to improve these issues or disallow using anonymous blocks as dynamic sql.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 4 months