MariaDB 10.3 is the current major development version.
Do not use alpha releases in production!
The following lists the major new features in MariaDB 10.3:
Syntax / general features
- CREATE SEQUENCE - MDEV-10139
- DROP SEQUENCE
- NEXT VALUE FOR
- PREVIOUS VALUE FOR
- INTERSECT and EXCEPT - MDEV-10141
- ROW data type for stored routine variables - MDEV-10914, MDEV-12007, MDEV-12291
- TYPE OF and ROW TYPE OF anchored data types for stored routine variables - MDEV-12461
- Cursors with parameters - MDEV-12457
- DDL Fast Fail - WAIT/NOWAIT - MDEV-11379, MDEV-11388
When running with sql_mode=ORACLE, the server now understands a subset of Oracle's PL/SQL language instead of the traditional MariaDB syntax for stored routines. See MDEV-10142, MDEV-10764 and MariaDB-10.3.0 release notes to know the current status.
Data type API
10.3 continues refactoring for the data type API started in 10.2, which will make it possible to have user data type plugins. This work is still in progress (see MDEV-4912 for the current status and subtasks). Most of the task in this category do not change the server behavior. Some tasks do have a visible effect.
Connections with idle transactions can be automatically killed after a specified time period by means of the idle_transaction_timeout, idle_readonly_transaction_timeout and idle_readwrite_transaction_timeout system variables.