[teiid-issues] [JBoss JIRA] (TEIID-3349) Allow column type to be altered

[Ramesh Reddy (JIRA)]

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

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)