All pages
Powered by GitBook
1 of 1

Loading...

MariaDB 10.4.0 Release Notes

The most recent release of MariaDB 10.4 is:MariaDB 10.4.34 Stable (GA) Download Now

Download | Release Notes | Changelog | Overview of 10.4

Release date: 9 Nov 2018

MariaDB 10.4 is the current development series of MariaDB. It is an evolution of MariaDB 10.3 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.4.0 is an Alpha release.

Do not use alpha releases in production!

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

Thanks, and enjoy MariaDB!

Notable Changes

This will be the first alpha release in the series.

Notable changes of this release include:

InnoDB

  • Added instant and changing of the order of columns ()

  • Reduced redo log volume for undo tablespace initialization ()

  • Removed crash-upgrade support for pre-10.2.19 TRUNCATE TABLE ()

  • Added key rotation for ()

Optimizer

  • ()

Variables

  • Added the system variable ()

  • Removed the global status variable ().

General

  • IF NOT EXISTS clause added to and IF EXISTS clause added to and ()

  • The obsolete is no longer created ()

  • Support of brackets (parentheses) for specifying precedence in // operations ()

Changelog

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

Contributors

For a full list of contributors to , see the .

Do not use alpha releases in production!

Crash safe Aria-based (MDEV-16421)

  • Added Linux abstract socket support (MDEV-15655)

  • Enabled C++11 (MDEV-16410)

  • support for and other (MDEV-12321)

  • Performance improvements in collations (MDEV-17534, MDEV-17511, MDEV-17502, MDEV-17474)

  • User data type plugins (MDEV-4912, in progress)

  • Improvements with SQL standard INTERVAL support to help functions and return more predictable results.

    • Historically, MariaDB uses the TIME data type for both "time of the day" values and "duration" values. In the first meaning the natural value range is from '00:00:00' to '23:59:59.999999', in the second meaning the range is from '-838:59:59.999999' to '+838:59:59.999999'.

    • To remove this ambiguity and for the SQL standard conformance we plan to introduce a dedicated data type INTERVAL that will be able to store values in the range at least from '-87649415:59:59.999999' to '+87649415:59:59.999999', which will be enough to represent the time difference between TIMESTAMP'0001-01-01 00:00:00' and TIMESTAMP'9999-12-31 23:59:59.999999'.

    • As a first step we support this range of values for intermediate calculations when TIME-alike string and numeric values are used in INTERVAL (i.e. duration) context, e.g. as the second argument of SQL functions TIMESTAMP(ts,interval) and ADDTIME(ts,interval), so the following can now be calculated:

  • MariaDB 10.4
    MDEV-15562
    MDEV-17138
    MDEV-13564
    innodb_encrypt_log
    MDEV-12041
    MDEV-12387
    MDEV-16277
    MDEV-15705
    MDEV-16294
    MDEV-15851
    MDEV-11953
    MariaDB 10.4.0
    changelog
    MariaDB 10.4.0
    MariaDB Foundation release announcement
    SELECT ADDTIME(TIMESTAMP'0001-01-01 00:00:00', '87649415:59:59.999999');
    -> '9999-12-31 23:59:59.999999'  
    
    SELECT TIMESTAMP(DATE'0001-01-01', '87649415:59:59.999999')
    -> '9999-12-31 23:59:59.999999'  
    
    SELECT ADDTIME(TIME'-838:59:59.999999', '1677:59:59.999998');
    -> '838:59:59.999999'

    Be notified of new MariaDB Server releases automatically by subscribing 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.

    Distributions which Include MariaDB
    DROP COLUMN
    Push conditions into materialized IN subqueries
    tcp_nodelay
    Innodb_pages0_read
    INSTALL PLUGIN
    UNINSTALL PLUGIN
    UNINSTALL SONAME
    mysql.host table
    UNION
    EXCEPT
    INTERSECT
    system tables
    SET PASSWORD
    ed25519
    authentication plugins
    Unicode
    TIMESTAMP()
    ADDTIME()

    This page is licensed: CC BY-SA / Gnu FDL