You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@trafodion.apache.org by "Yuan Liu (JIRA)" <ji...@apache.org> on 2017/03/16 02:26:41 UTC

[jira] [Created] (TRAFODION-2540) Drop column on table with generated always as identity column fail

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)