You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Atanu Mishra (JIRA)" <ji...@apache.org> on 2015/08/14 01:27:45 UTC
[jira] [Commented] (TRAFODION-135) LP Bug: 1244844 - Alter table
drop column IF EXISTS syntax returns error 15001
[ 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)