[teiid-issues] [JBoss JIRA] (TEIID-2578) add/remove schema elements
Ramesh Reddy (JIRA)
issues at jboss.org
Tue Aug 30 12:12:01 EDT 2016
[ https://issues.jboss.org/browse/TEIID-2578?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13286222#comment-13286222 ]
Ramesh Reddy commented on TEIID-2578:
-------------------------------------
IMO, Teiid should have limited DDL language for definition of the VIEW to
{code}
CREATE VIEW <view-name> OPTIONS (...) AS <stmt>
ALTER VIEW <view-name> OPTIONS(...) AS <stmt>
{code}
as it defined other database view definitions, not allow the user to define the column definitions inline. This would have solved the above issue. I am leaning towards limiting the functionality that, we allow only to change the transformation of the view (which Teiid already does) which covers all the cases.
> add/remove schema elements
> --------------------------
>
> Key: TEIID-2578
> URL: https://issues.jboss.org/browse/TEIID-2578
> Project: Teiid
> Issue Type: Feature Request
> Components: Query Engine
> Reporter: Ramesh Reddy
> Assignee: Ramesh Reddy
> Fix For: 9.1
>
>
> Schemas are currently static after load. Modifications can only happen with restarts or new versions. We should allow add/drop at runtime.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
More information about the teiid-issues
mailing list