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
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 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  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.