Details
-
Documentation
-
Status: Open
-
Major
-
Resolution: Unresolved
-
2.2.0
-
None
-
None
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]