[jira] [Commented] (TRAFODION-1994) enable alter table support change column default value
[ https://issues.apache.org/jira/browse/TRAFODION-1994?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15285790#comment-15285790 ] liu ming commented on TRAFODION-1994: - I tried in latest git pull code but it reports: *** ERROR[4222] The ALTER feature is not supported in this software version. But I know what you mean, this will be added into R2.1. I will close this when related code merged. > 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)
[jira] [Commented] (TRAFODION-1994) enable alter table support change column default value
[ 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)
[jira] [Commented] (TRAFODION-1994) enable alter table support change column default value
[ https://issues.apache.org/jira/browse/TRAFODION-1994?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15283833#comment-15283833 ] liu ming commented on TRAFODION-1994: - Sometimes after table created, one want to change the table column definition to have different default value. It will be good to have this implemented. create table altert3 (c1 int, c2 int, c3 int); alter table altert3 alter column c3 default 1; --set the default value of column c3 to 1 > 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)
