[ https://issues.apache.org/jira/browse/TRAFODION-135?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14696157#comment-14696157 ]
Atanu Mishra commented on TRAFODION-135: ---------------------------------------- Weishiun Tsai (wei-shiun-tsai) wrote on 2013-11-03: #1 Verified on 11/2/2013, this bug has been fixed: >>set schema seabase.phoenix; --- SQL operation complete. >>create table t (a int not null not droppable primary key); --- SQL operation complete. >>alter table t drop column if exists blah; --- SQL operation complete. >>invoke t; -- Definition of Seabase table SEABASE.PHOENIX.T -- Definition current Sun Nov 3 01:23:30 2013 ( A INT NO DEFAULT NOT NULL NOT DROPPABLE ) PRIMARY KEY (A ASC) --- SQL operation complete. Weishiun Tsai (wei-shiun-tsai) on 2013-11-05 Changed in trafodion: status: New → Fix Released > LP Bug: 1244844 - Alter table drop column IF EXISTS syntax returns error 15001 > ------------------------------------------------------------------------------ > > Key: TRAFODION-135 > URL: https://issues.apache.org/jira/browse/TRAFODION-135 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-general > Reporter: Weishiun Tsai > Assignee: Anoop Sharma > Priority: Critical > > Alter table drop column IF EXISTS syntax is targeted to be supported, but it > returns error 15001 right now. > >>set schema seabase.phoenix; > --- SQL operation complete. > >>create table t (a int not null not droppable primary key); > --- SQL operation complete. > >>alter table t drop column if exists blah; > *** ERROR[15001] A syntax error occurred at or before: > alter table t drop column if exists blah; > ^ (29 characters from start of SQL statement) -- This message was sent by Atlassian JIRA (v6.3.4#6332)