Create table with identity doesn't support minvalue, maxvalue, cycle
Bug #1025346 reported by
Thomas Jones-Low
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Akiban SQL Parser |
Confirmed
|
Medium
|
Unassigned |
Bug Description
CREATE TABLE t (c1 integer GENERATED BY DEFAULT AS IDENTITY (MAXVALUE 12 MINVALUE 1 CYCLE)
There are three issues in the processing of GENERATED ... IDENTITY that need to be fixed in the parser:
1) The requirement of the comma between the STARTS WITH and INCREMENT BY clauses which isn't in the standard.
2) The non-support of the MINVALUE, MAXVALUE, and CYCLE clauses.
3) The internal processing of the GENERATED ... IDENTITY ends up setting special fields on the ColumnDefinitio
information type: | Private → Public |
To post a comment you must log in.
Also the NO variants of 2).