[TRAFODION-3198] section 5.11 on identity column miss parenthesis

• Type: Documentation
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.2.0
• Component/s: documentation
• Assignee: Unassigned
• Reporter: Eric Owhadi
• Created: 07/Sep/18 15:48
• Updated: 07/Sep/18 15:48

Description

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]