Changeset: 9e8d9212e2de for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9e8d9212e2de
Modified Files:
clients/mapiclient/mhelp.c
sql/server/sql_parser.y
Branch: default
Log Message:
Added BEGIN TRANSACTION syntax for compability with other databases
diffs (36 lines):
diff --git a/clients/mapiclient/mhelp.c b/clients/mapiclient/mhelp.c
--- a/clients/mapiclient/mhelp.c
+++ b/clients/mapiclient/mhelp.c
@@ -495,7 +495,7 @@ SQLhelp sqlhelp1[] = {
NULL},
{"START TRANSACTION",
"Change transaction mode from auto-commit to user controlled
commit/rollback",
- "START TRANSACTION transactionmode",
+ "{ START | BEGIN } TRANSACTION transactionmode",
"transactionmode,isolevel",
"See also
https://www.monetdb.org/Documentation/Manuals/SQLreference/Transactions"},
{"TABLE JOINS",
diff --git a/sql/server/sql_parser.y b/sql/server/sql_parser.y
--- a/sql/server/sql_parser.y
+++ b/sql/server/sql_parser.y
@@ -2883,6 +2883,11 @@ transaction_statement:
m->type = Q_TRANS; }
;
+start_transaction:
+ START
+ | BEGIN
+ ;
+
transaction_stmt:
COMMIT opt_work opt_chain
{ $$ = _symbol_create_int( TR_COMMIT, $3); }
@@ -2894,7 +2899,7 @@ transaction_stmt:
{ $$ = _symbol_create_list( TR_ROLLBACK,
append_string(
append_int(L(), $3), $4 )); }
- | START TRANSACTION transaction_mode_list
+ | start_transaction TRANSACTION transaction_mode_list
{ $$ = _symbol_create_int( TR_START, $3); }
| SET LOCAL TRANSACTION transaction_mode_list
{ $$ = _symbol_create_int( TR_MODE, $4); }
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
