[
https://issues.apache.org/jira/browse/TRAFODION-135?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Atanu Mishra closed TRAFODION-135.
----------------------------------
Resolution: Fixed
Assignee: (was: Anoop Sharma)
Fix Version/s: 1.0 (pre-incubation)
> 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
> Priority: Critical
> Fix For: 1.0 (pre-incubation)
>
>
> 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)
