Details
-
Technical task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
10.2.2-3, 10.2.2-1, 10.2.2-2, 10.2.2-4, 10.1.18
Description
MariaDB uses BEGIN NOT ATOMIC to start anonymous blocks that can be used directly, outside of an SP context:
MariaDB:
delimiter ;;
|
BEGIN NOT ATOMIC |
...
|
END;; |
When running with sql_mode=ORACLE, MariaDB will understand this syntax for anonymous blocks.
DECLARE
|
...
|
BEGIN
|
...
|
END;; |
In ORACLE mode, BEGIN is same as BEGIN NOT ATOMIC
BEGIN
|
...
|
END;; |
This change will disallow BEGIN and BEGIN WORK as a transaction start for sql_mode=ORACLE. But one can still use START TRANSACTION if needed.