Sequence type errors

[monetdb-team]

Date: 2014-02-19 15:46:41 +0100
From: @mlkersten
To: SQL devs <>
Version: 11.17.9 (Jan2014)
CC: @njnes

Last updated: 2015-08-28 13:42:53 +0200

Comment 19588

Date: 2014-02-19 15:46:41 +0100
From: @mlkersten

User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:26.0) Gecko/20100101 Firefox/26.0
Build Identifier:

Unexpected syntax error while the language would allow it.

Reproducible: Always

Steps to Reproduce:

CREATE SEQUENCE ancilfiles_aid_seq AS INTEGER
START WITH 1
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE;

Actual Results:

sql>CREATE SEQUENCE ancilfiles_aid_seq AS INTEGER
more> START WITH 1
more> INCREMENT BY 1
more> NO MAXVALUE
more> NO MINVALUE;
syntax error, unexpected NOMINVALUE, expecting SCOLON in: "create sequence ancilfiles_aid_seq as integer
start with 1
increment by 1
no maxvalue
no minvalue"
sql>

Expected Results:

sql>CREATE SEQUENCE ancilfiles_aid_seq AS INTEGER
more> START WITH 1
more> INCREMENT BY 1
more> NO MAXVALUE
more> NO MINVALUE;

Comment 19628

Date: 2014-02-21 10:18:21 +0100
From: @njnes

2003 sql definition is indeed a lot more flexible then our current parser allows. It now has a fixed order of options while all (except the AS type) can be in any order.

Comment 21107

Date: 2015-08-08 17:05:58 +0200
From: @njnes

improved the handling of sequence number creation. This will be available in the release after the Jul2015 one.

Comment 21220

Date: 2015-08-28 13:42:53 +0200
From: @sjoerdmullender

Jul2015 has been released.