[jira] [Created] (TRAFODION-135) LP Bug: 1244844 - Alter table drop column IF EXISTS syntax returns error 15001

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-135:
------------------------------------

             Summary: 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)