Details
-
Type:
Technical task
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 10.3.0
-
Component/s: Parser
-
Labels:
-
Sprint: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.