Changeset: f9c57033d2c1 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/f9c57033d2c1
Modified Files:
clients/mapiclient/mhelp.c
Branch: Mar2025
Log Message:
Merge syntax of SET TRANSACTION and SET LOCAL TRANSACTION into START
TRANSACTION.
Add SET CURRENT_SCHEMA syntax.
diffs (49 lines):
diff --git a/clients/mapiclient/mhelp.c b/clients/mapiclient/mhelp.c
--- a/clients/mapiclient/mhelp.c
+++ b/clients/mapiclient/mhelp.c
@@ -515,14 +515,9 @@ SQLhelp sqlhelp1[] = {
"SET ident '=' simple_atom",
"simple_atom",
"See also
https://www.monetdb.org/documentation/user-guide/sql-programming/variable-definitions/"},
- {"SET LOCAL TRANSACTION",
- "",
- "SET LOCAL TRANSACTION [ transactionmode [',' ...] ]",
- "transactionmode",
- "See also
https://www.monetdb.org/documentation/user-guide/sql-manual/transactions/"},
{"SET OPTIMIZER",
"Change current optimizer pipeline",
- "SET sys.optimizer '=' optimizer_pipe_name",
+ "SET sys.optimizer '=' optimizer_pipeline_name",
NULL,
"See also
https://www.monetdb.org/documentation/admin-guide/performance-tips/optimizer-pipelines/"},
{"SET ROLE",
@@ -532,7 +527,7 @@ SQLhelp sqlhelp1[] = {
NULL},
{"SET SCHEMA",
"Change current schema",
- "SET SCHEMA ident",
+ "SET { SCHEMA | CURRENT_SCHEMA } ident",
NULL,
NULL},
{"SET SESSION AUTHORIZATION",
@@ -545,11 +540,6 @@ SQLhelp sqlhelp1[] = {
"SET TIME ZONE [ interval | LOCAL ]",
"interval",
NULL},
- {"SET TRANSACTION",
- "",
- "SET TRANSACTION [ transactionmode [',' ...] ]",
- "transactionmode",
- "See also
https://www.monetdb.org/documentation/user-guide/sql-manual/transactions/"},
{"SET USER",
"Change current user",
"SET USER '=' ident",
@@ -557,7 +547,7 @@ SQLhelp sqlhelp1[] = {
NULL},
{"START TRANSACTION",
"Change transaction mode from auto-commit to user controlled
commit/rollback",
- "{ START | BEGIN } TRANSACTION [ transactionmode ]",
+ "{ START | BEGIN | SET [ LOCAL ] } TRANSACTION [ transaction_mode [','
...] ]",
"transactionmode",
"See also
https://www.monetdb.org/documentation/user-guide/sql-manual/transactions/"},
{"TABLE JOINS",
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
