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

Posted to issues@trafodion.apache.org by "Eric Owhadi (JIRA)" <ji...@apache.org> on 2018/09/07 15:49:00 UTC

[jira] [Created] (TRAFODION-3198) section 5.11 on identity column miss parenthesis

Eric Owhadi created TRAFODION-3198:
--------------------------------------

             Summary: section 5.11 on identity column miss parenthesis
                 Key: TRAFODION-3198
                 URL: https://issues.apache.org/jira/browse/TRAFODION-3198
             Project: Apache Trafodion
          Issue Type: Documentation
          Components: documentation
    Affects Versions: 2.2.0
            Reporter: Eric Owhadi


create table tt (id int unsigned generated by default as identity (minvalue 10 maxvalue 2000 cycle), primary key (id));

 

see the opening parenthesis closing parenthesis needed in the syntax.

and compare it with DOC, user can't see parenthesis are needed.


GENERATED [ALWAYS | BY DEFAULT] AS IDENTITY

[START WITH integer]

[INCREMENT BY integer]

[MAXVALUE integer | NOMAXVALUE]

[MINVALUE integer]

[CYCLE | NO CYCLE]

[CACHE integer | NO CACHE]

[DATA TYPE]



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)