Create table with identity doesn't support minvalue, maxvalue, cycle

Bug #1025346 reported by Thomas Jones-Low
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Akiban SQL Parser
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 ColumnDefinitionNode. It should generate a CreateSequenceNode and attach it.

Revision history for this message
Mike McMahon (mmcm) wrote :

Also the NO variants of 2).

Changed in akiban-sql-parser:
status: New → Confirmed
importance: Undecided → Medium
milestone: none → future
information type: Private → Public
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers