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:
-
and . These are both now and can no longer be used as an without being quoted -
Connections with idle transactions can be automatically killed after a specified time period by means of the , and system variables.
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 -
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 -
The following new system variables have been added:
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 .
This page is licensed: CC BY-SA / Gnu FDL
data type for variables - , ,
anchored data types for variables -
with parameters -
- ,
table%ROWTYPE in variable declarations -
FOR loop statement -
Implicit cursor FOR loop -
Explicit cursor FOR LOOP -
Cursors with parameters -
Implicit cursor FOR LOOP for cursors with parameters -
Triggers: Understand :NEW.c1 and :OLD.c1 instead of NEW.c1 and OLD.c1 -
Dynamic SQL placeholders -
Allow VARCHAR and VARCHAR2 without length as a data type of routine parameters and in RETURN clause -
CAST(..AS VARCHAR(N)) -
Anonymous blocks -
GOTO statement -
Allow SELECT UNIQUE as a synonym for SELECT DISTINCT -
Do not require BEGIN..END in multi-statement exception handlers in THEN clause -
Understand optional routine name after the END keyword -
Inside routines the CALL keywoard is optional -
Make the concatenation operator ignore NULL arguments -
make the CONCAT function ignore NULL arguments -
TRUNCATE TABLE t1 [ {DROP|REUSE} STORAGE ] -
Providing compatibility for basic SQL data types -
as an argument to comparison operators in combination with numeric and temporal data types -
as an argument to operators +, -, *, /, MOD -
Wrong result for INSERT INTO t1 (datetime_field) VALUES (hybrid_function_of_TIME_data_type) -
Expect "Impossible where condition" for WHERE timestamp_field>=DATE_ADD(TIMESTAMP'9999-01-01 00:00:00',INTERVAL 1000 YEAR) -
SP variables of temporal data types do not replicate correctly -
Incorrect result for (time_expr BETWEEN timestamp_exp1 AND timestamp_expr2) -
Wrong result for CASE on a mixture of signed and unsigned expressions -
Wrong result for (int_expr IN (mixture of signed and unsigned expressions)) -
CASE with a mixture of TIME and DATETIME returns a wrong result -
SP variables of the SET data type erroneously allow values with comma -
mysql_list_field() returns wrong default values for VIEW -
Notable Changes
Syntax / General Features
Idle Transactions
Compatibility
Data Type API
System Variables
Status Variables
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.