[
https://issues.apache.org/jira/browse/TRAFODION-1994?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15284891#comment-15284891
]
Anoop Sharma commented on TRAFODION-1994:
-----------------------------------------
Support for alter col attributes has already been added to Traf 2.1.
See example below on altering default value:
Apache Trafodion Conversational Interface 2.1.0
Copyright (c) 2015-2016 Apache Software Foundation
>>create table altert3 (c1 int, c2 int, c3 int);
--- SQL operation complete.
>>invoke altert3;
-- Definition of Trafodion table TRAFODION.SCH.ALTERT3
-- Definition current Mon May 16 17:16:09 2016
(
SYSKEY LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
NOT SERIALIZED
, C1 INT DEFAULT NULL SERIALIZED
, C2 INT DEFAULT NULL SERIALIZED
, C3 INT DEFAULT NULL SERIALIZED
)
--- SQL operation complete.
>>alter table altert3 alter column c3 int default 1;
--- SQL operation complete.
>>invoke altert3;
-- Definition of Trafodion table TRAFODION.SCH.ALTERT3
-- Definition current Mon May 16 17:16:50 2016
(
SYSKEY LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
NOT SERIALIZED
, C1 INT DEFAULT NULL SERIALIZED
, C2 INT DEFAULT NULL SERIALIZED
, C3 INT DEFAULT 1 SERIALIZED /*altered_col*/
)
--- SQL operation complete.
>>
> enable alter table support change column default value
> ------------------------------------------------------
>
> Key: TRAFODION-1994
> URL: https://issues.apache.org/jira/browse/TRAFODION-1994
> Project: Apache Trafodion
> Issue Type: Improvement
> Components: sql-cmu
> Reporter: liu ming
> Assignee: liu ming
> Fix For: 2.1-incubating
>
>
> Enhance the 'ALTER TABLE' DDL to support change column DEFAULT setting
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
