MariaDB 10.3.0 Release Notes

The most recent release of MariaDB 10.3 is:MariaDB 10.3.39 Stable (GA) Download Now

Download | Release Notes | Changelog | Overview of 10.3

Release date: 16 Apr 2017

MariaDB 10.3 is the new development series of MariaDB. It is an evolution of MariaDB 10.2 with several entirely new features not found anywhere else.

MariaDB 10.3.0 is an Alpha release.

Do not use alpha releases in production!

For an overview of MariaDB 10.3 see theWhat is MariaDB 10.3? page.

Thanks, and enjoy MariaDB!

Notable Changes

This is the first release in the series. Alpha releases are useful for testing and planning, but should not be used in production.

Notable additions in this release include:

Syntax / General Features

• -

• and . These are both now and can no longer be used as an without being quoted -

• data type for variables - , ,

Idle Transactions

Connections with idle transactions can be automatically killed after a specified time period by means of the , and system variables.

Compatibility

When running with , the server now understands a subset of Oracle's PL/SQL language instead of the traditional MariaDB syntax for stored routines. This work is in progress. See and for the current status and subtasks. The 10.3.0 release includes:

• Providing compatibility for basic PL/SQL constructs -

• %TYPE in variable declarations -

• cursor%ROWTYPE in variable declarations -

• table%ROWTYPE in variable declarations -

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 for the current status and subtasks). Most of the task in this category do not change the server behavior. Some tasks implemented in 10.3.0 do have a good visible effect:

• An expression of the data type is not allowed any more:

  • as an argument to functions ABS(), CEILING(), FLOOR(), ROUND(), SUM(), AVG(), VARIANCE(), CAST(AS..), as well as to the unary minus operator - , , ,

  • as an argument to hybrid functions such as CASE, COALESCE, IF which have other arguments of the numeric or temporal data types -

System Variables

The following new system variables have been added:

Status Variables

The following new status variables have been added:

See the page for an overview of .

Do not use alpha releases in production!

For a complete list of changes made in , with links to detailed information on each push, see the .