Changeset: 8aa2cac97c2f for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/8aa2cac97c2f
Modified Files:
clients/mapiclient/mhelp.c
Branch: Aug2024
Log Message:
Improve the REFERENCES match_option and reference_actions syntax help.
diffs (64 lines):
diff --git a/clients/mapiclient/mhelp.c b/clients/mapiclient/mhelp.c
--- a/clients/mapiclient/mhelp.c
+++ b/clients/mapiclient/mhelp.c
@@ -624,8 +624,8 @@ SQLhelp sqlhelp2[] = {
NULL,
"[ 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",
+ " REFERENCES qname [ column_list ] [ match_option ] [
reference_actions ] }\n",
+ "column_list,search_condition,match_option,reference_actions",
"See also
https://www.monetdb.org/documentation/user-guide/sql-manual/data-definition/table-elements/"},
{"control_statement",
NULL,
@@ -749,9 +749,9 @@ SQLhelp sqlhelp2[] = {
"C | CPP | R | PYTHON | PYTHON3",
NULL,
NULL},
- {"match_options",
+ {"match_option",
NULL,
- "MATCH { FULL | PARTIAL | SIMPLE }",
+ "MATCH [ FULL | PARTIAL | SIMPLE ]",
NULL,
NULL},
{"merge_list",
@@ -869,9 +869,24 @@ SQLhelp sqlhelp2[] = {
"ident [ '.' ident ['.' ident]]",
NULL,
NULL},
- {"reference_action",
+ {"ref_action",
+ NULL,
+ "RESTRICT | CASCADE | NO ACTION | SET NULL | SET DEFAULT",
+ NULL,
+ NULL},
+ {"ref_on_delete",
+ NULL,
+ "ON DELETE ref_action",
NULL,
- "ON { UPDATE | DELETE } { NO ACTION | CASCADE | RESTRICT | SET NULL |
SET DEFAULT }",
+ NULL},
+ {"ref_on_update",
+ NULL,
+ "ON UPDATE ref_action",
+ NULL,
+ NULL},
+ {"reference_actions",
+ NULL,
+ "ref_on_delete | ref_on_update | ref_on_delete ref_on_update |
ref_on_update ref_on_delete",
NULL,
NULL},
{"return_statement",
@@ -913,8 +928,8 @@ SQLhelp sqlhelp2[] = {
NULL,
"[ CONSTRAINT ident ] { CHECK '(' search_condition ')' |\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",
+ " FOREIGN KEY column_list REFERENCES qname [ column_list ] [
match_option ] [ reference_actions ] }",
+ "column_list,search_condition,match_option,reference_actions",
"See also
https://www.monetdb.org/documentation/user-guide/sql-manual/data-definition/table-elements/"},
{"table_element",
NULL,
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
