[ https://issues.apache.org/jira/browse/TRAFODION-2540?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Anoop Sharma reassigned TRAFODION-2540: --------------------------------------- Assignee: Anoop Sharma > 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 > Assignee: Anoop Sharma > > 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)