Changeset: 5a666cbf0289 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/5a666cbf0289
Modified Files:
clients/mapiclient/mhelp.c
Branch: Dec2025
Log Message:
Improve mhelp; add syntax for ALTER TABLE [ IF EXISTS ] qname ALTER [ COLUMN ]
column_name data_type,
add new data types: INET4 and INET6
correct refs to sql-manual/data-definition/sequence-definition/
diffs (74 lines):
diff --git a/clients/mapiclient/mhelp.c b/clients/mapiclient/mhelp.c
--- a/clients/mapiclient/mhelp.c
+++ b/clients/mapiclient/mhelp.c
@@ -49,11 +49,11 @@ SQLhelp sqlhelp1[] = {
// major commands
{"ALTER MERGE TABLE",
"",
- "ALTER TABLE [ IF EXISTS ] qname ADD TABLE qname [ AS PARTITION
partition_spec ]\n"
- "ALTER TABLE [ IF EXISTS ] qname DROP TABLE qname [ RESTRICT | CASCADE
]\n"
- "ALTER TABLE [ IF EXISTS ] qname SET TABLE qname AS PARTITION
partition_spec",
+ "ALTER TABLE [ IF EXISTS ] qname ADD TABLE qname [ AS PARTITION
partition_spec ]\n"
+ "ALTER TABLE [ IF EXISTS ] qname SET TABLE qname AS PARTITION
partition_spec\n"
+ "ALTER TABLE [ IF EXISTS ] qname DROP TABLE qname [ RESTRICT | CASCADE
]",
"qname,partition_spec",
- "See also
https://www.monetdb.org/documentation/admin-guide/distributed-query-processing/"},
+ "See also
https://www.monetdb.org/documentation/user-guide/sql-manual/data-definition/merge-tables/"},
{"ALTER SCHEMA",
"",
"ALTER SCHEMA [ IF EXISTS ] ident RENAME TO ident",
@@ -61,16 +61,22 @@ SQLhelp sqlhelp1[] = {
"See also
https://www.monetdb.org/documentation/user-guide/sql-manual/data-definition/schema-definitions/"},
{"ALTER SEQUENCE",
"",
- "ALTER SEQUENCE [ IF EXISTS ] qname [AS seq_int_datatype] [RESTART
[WITH {bigint|subquery}] ] [INCREMENT BY bigint]\n"
- " [MINVALUE bigint | NO MINVALUE] [MAXVALUE bigint | NO MAXVALUE]
[CACHE bigint] [[NO] CYCLE]",
+ "ALTER SEQUENCE [ IF EXISTS ] qname [AS seq_int_datatype]\n"
+ " [RESTART [WITH {bigint|subquery}] ]\n"
+ " [INCREMENT BY bigint]\n"
+ " [MINVALUE bigint | NO MINVALUE]\n"
+ " [MAXVALUE bigint | NO MAXVALUE]\n"
+ " [CACHE bigint]\n"
+ " [[NO] CYCLE]",
"seq_int_datatype",
- "See also
https://www.monetdb.org/documentation/user-guide/sql-manual/data-types/serial-types/"},
+ "See also
https://www.monetdb.org/documentation/user-guide/sql-manual/data-definition/sequence-definition/"},
{"ALTER TABLE",
"",
"ALTER TABLE [ IF EXISTS ] qname ADD [ COLUMN ] column_def\n"
"ALTER TABLE [ IF EXISTS ] qname ADD [ CONSTRAINT ident ]
table_constraint\n"
+ "ALTER TABLE [ IF EXISTS ] qname ALTER [ COLUMN ] ident data_type\n"
+ "ALTER TABLE [ IF EXISTS ] qname ALTER [ COLUMN ] ident SET [NOT]
NULL\n"
"ALTER TABLE [ IF EXISTS ] qname ALTER [ COLUMN ] ident SET DEFAULT
value\n"
- "ALTER TABLE [ IF EXISTS ] qname ALTER [ COLUMN ] ident SET [NOT]
NULL\n"
"ALTER TABLE [ IF EXISTS ] qname ALTER [ COLUMN ] ident DROP DEFAULT\n"
"ALTER TABLE [ IF EXISTS ] qname ALTER [ COLUMN ] ident SET STORAGE
{string | NULL}\n"
"ALTER TABLE [ IF EXISTS ] qname DROP [ COLUMN ] ident [ RESTRICT |
CASCADE ]\n"
@@ -221,10 +227,15 @@ SQLhelp sqlhelp1[] = {
"See also
https://www.monetdb.org/documentation/user-guide/sql-manual/data-definition/schema-definitions/"},
{"CREATE SEQUENCE",
"Define a new integer number sequence generator",
- "CREATE SEQUENCE [ IF NOT EXISTS ] qname [AS seq_int_datatype] [START
WITH bigint] [INCREMENT BY bigint]\n"
- " [MINVALUE bigint | NO MINVALUE] [MAXVALUE bigint | NO MAXVALUE]
[CACHE bigint] [[NO] CYCLE]",
+ "CREATE SEQUENCE [ IF NOT EXISTS ] qname [AS seq_int_datatype]\n"
+ " [START WITH bigint]\n"
+ " [INCREMENT BY bigint]\n"
+ " [MINVALUE bigint | NO MINVALUE]\n"
+ " [MAXVALUE bigint | NO MAXVALUE]\n"
+ " [CACHE bigint]\n"
+ " [[NO] CYCLE]",
"seq_int_datatype",
- "See also
https://www.monetdb.org/documentation/user-guide/sql-manual/data-types/serial-types/"},
+ "See also
https://www.monetdb.org/documentation/user-guide/sql-manual/data-definition/sequence-definition/"},
{"CREATE TABLE",
"Create a new table",
"CREATE TABLE [ IF NOT EXISTS ] qname table_source [STORAGE ident
string]\n"
@@ -669,7 +680,7 @@ SQLhelp sqlhelp2[] = {
" { VARCHAR | CHARACTER VARYING } '(' nonzero ')' |\n"
" { CHAR | CHARACTER [ LARGE OBJECT ] | CLOB | TEXT | STRING | JSON |
URL } [ '(' nonzero ')' ] |\n"
" { BINARY LARGE OBJECT | BLOB } [ '(' nonzero ')' ] |\n"
- " UUID | INET | datetime_type | interval_type | geometry_type",
+ " UUID | INET | INET4 | INET6 | datetime_type | interval_type |
geometry_type",
"datetime_type,interval_type,geometry_type",
"See also
https://www.monetdb.org/documentation/user-guide/sql-manual/data-types/"},
{"default_char_set",
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
