Changeset: 0e447dd3c5a4 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=0e447dd3c5a4 Modified Files: clients/mapiclient/mhelp.c Branch: Nov2019 Log Message:
Improve syntax of ALTER SEQUENCE and CREATE SEQUENCE. They allow a qualified name and support only a limited number of integer data types. Corrected definition of column_ref. Also updated https://www.monetdb.org/Documentation/Manuals/SQLreference/SerialTypes diffs (52 lines): diff --git a/clients/mapiclient/mhelp.c b/clients/mapiclient/mhelp.c --- a/clients/mapiclient/mhelp.c +++ b/clients/mapiclient/mhelp.c @@ -72,9 +72,9 @@ SQLhelp sqlhelp1[] = { "See also https://www.monetdb.org/Documentation/SQLreference/Alter"}, {"ALTER SEQUENCE", "", - "ALTER SEQUENCE ident [ AS data_type] [ RESTART [WITH start]] [INCREMENT BY increment]\n" - "[MINVALUE minvalue | NO MINVALUE] [MAXVALUE maxvalue | NO MAXVALUE] [CACHE cachevalue] [[NO] CYCLE]", - "ident,data_type", + "ALTER SEQUENCE qname [ AS int_datatype] [ RESTART [WITH intval]] [INCREMENT BY intval]\n" + "[MINVALUE intval | NO MINVALUE] [MAXVALUE intval | NO MAXVALUE] [CACHE intval] [[NO] CYCLE]", + "int_datatype,intval", "See also https://www.monetdb.org/Documentation/Manuals/SQLreference/SerialTypes"}, {"ALTER USER", "Change a user's login name or password or default schema", @@ -209,9 +209,9 @@ SQLhelp sqlhelp1[] = { "See also https://www.monetdb.org/Documentation/SQLreference/Schema"}, {"CREATE SEQUENCE", "Define a new integer number sequence generator", - "CREATE SEQUENCE ident [ AS data_type] [ START [WITH start]] [INCREMENT BY increment]\n" - "[MINVALUE minvalue | NO MINVALUE] [MAXVALUE maxvalue | NO MAXVALUE] [CACHE cachevalue] [[NO] CYCLE]", - "ident,data_type", + "CREATE SEQUENCE qname [ AS int_datatype] [ START [WITH intval]] [INCREMENT BY intval]\n" + "[MINVALUE intval | NO MINVALUE] [MAXVALUE intval | NO MAXVALUE] [CACHE intval] [[NO] CYCLE]", + "int_datatype,intval", "See also https://www.monetdb.org/Documentation/Manuals/SQLreference/SerialTypes"}, {"CREATE STREAM TABLE", "Temporary table, locked during updates/ continues query processing", @@ -548,8 +548,8 @@ SQLhelp sqlhelp2[] = { NULL}, {"column_def", NULL, - "COLUMN { data_type [ column_option ... ] | SERIAL | BIGSERIAL }", - "data_type,column_option", + "ident { data_type [ column_option ... ] | SERIAL | BIGSERIAL }", + "ident,data_type,column_option", NULL}, {"column_list", NULL, @@ -646,6 +646,11 @@ SQLhelp sqlhelp2[] = { "ident [',' ...]", "ident", NULL}, + {"int_datatype", + NULL, + "BIGINT | INTEGER | INT | SMALLINT | TINYINT", + NULL, + NULL}, {"interval", NULL, "INTERVAL [ '+' | '-' ] string start_field TO end_field", _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
