Changeset: 45bab9993870 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/45bab9993870
Modified Files:
clients/mapiclient/mhelp.c
Branch: Aug2024
Log Message:
Extend mclient help info with new UNIQUE NULLS [ NOT ] DISTINCT constraint
syntax
diffs (22 lines):
diff --git a/clients/mapiclient/mhelp.c b/clients/mapiclient/mhelp.c
--- a/clients/mapiclient/mhelp.c
+++ b/clients/mapiclient/mhelp.c
@@ -622,7 +622,8 @@ SQLhelp sqlhelp2[] = {
NULL},
{"column_constraint",
NULL,
- "[ CONSTRAINT ident ] { NOT NULL | NULL | UNIQUE | PRIMARY KEY | CHECK
'(' search_condition ')' |\n"
+ "[ CONSTRAINT ident ] { NOT NULL | NULL | CHECK '(' search_condition
')' |\n"
+ " PRIMARY KEY | UNIQUE | UNIQUE NULLS [ NOT ] DISTINCT |\n"
" REFERENCES qname [ column_list ] [ match_options ] [
reference_action ] }\n",
"column_list,search_condition,match_options,reference_action",
"See also
https://www.monetdb.org/documentation/user-guide/sql-manual/data-definition/table-elements/"},
@@ -911,7 +912,7 @@ SQLhelp sqlhelp2[] = {
{"table_constraint",
NULL,
"[ CONSTRAINT ident ] { CHECK '(' search_condition ')' |\n"
- " PRIMARY KEY column_list | UNIQUE column_list |\n"
+ " PRIMARY KEY column_list | UNIQUE column_list | UNIQUE NULLS [ NOT
] DISTINCT column_list |\n"
" FOREIGN KEY column_list REFERENCES qname [ column_list ] [
match_options ] [ reference_action ] }",
"column_list,search_condition,match_options,reference_action",
"See also
https://www.monetdb.org/documentation/user-guide/sql-manual/data-definition/table-elements/"},
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
