MariaDB uses BEGIN NOT ATOMIC to start anonymous blocks that can be used directly, outside of an SP context:
When running with sql_mode=ORACLE, MariaDB will understand this syntax for anonymous blocks.
In ORACLE mode, BEGIN is same as BEGIN NOT ATOMIC
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.