You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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;
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.
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.
The text was updated successfully, but these errors were encountered: