You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Anoop Sharma (JIRA)" <ji...@apache.org> on 2017/04/18 23:39:41 UTC
[jira] [Assigned] (TRAFODION-2540) Drop column on table with
generated always as identity column fail
[ 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)