Yuan Liu created TRAFODION-2540:
-----------------------------------

             Summary: Drop column on table with generated always as identity 
column fail
                 Key: TRAFODION-2540
                 URL: https://issues.apache.org/jira/browse/TRAFODION-2540
             Project: Apache Trafodion
          Issue Type: Bug
          Components: -exe
    Affects Versions: any
            Reporter: Yuan Liu


SQL>create table test_drop_p2(eid largeint generated always as identity, p 
varchar(64),primary key (eid));
alter table test_drop_p2 drop column p;

--- SQL operation complete.

SQL>
*** ERROR[3428] IDENTITY column EID defined as GENERATED ALWAYS cannot accept 
values specified by the user. [2017-03-15 15:37:49]




--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Reply via email to