MariaDB 12.0 Changes & Improvements

MariaDB 12.0 is a rolling release. It is an evolution of MariaDB 11.8 with several entirely new features.

New Features

Security

• Support for passphrase protected keys (MDEV-14091)

• New statement SET SESSION AUTHORIZATION for performing actions as another user (MDEV-20299)

• Implement SHA2 support for file_key_management.so plugin (TDE) (MDEV-34712)

Data types

• Comparison ROW(stored_func(),1)=ROW(1,1) erroneously called stored_func() twice per row. It led to a performance degradation, as well as to a double execution of the possible stored function side effects. (MDEV-36322)

Stored Routines

• Add support for the pre-defined weak SYS_REFCURSOR (MDEV-20034)

Server

• TO_CHAR FM format not recognized in SQL_MODE=Oracle (MDEV-36216)

• mariadb-check and CHECK TABLE now support SEQUENCE tables (MDEV-22491)

Optimizer

• find_order_in_list mismatch when order item needs fixing() (MDEV-36607)

• If the join_condition is specified via USING (column_list), the query plan depends on the sequence of tables in the query (MDEV-36592)

• Add support for optimizer hints (MDEV-35504)

  • QB_NAME()

  • NO_RANGE_OPTIMIZATION()

  • NO_ICP()

  • MRR(), NO_MRR()

  • BKA(), NO_BKA()

  • BNL(), NO_BNL()

• Add support for subquery optimizer hints (MDEV-34888)

  • SEMIJOIN()

  • SUBQUERY()

• Add support for join order hints (MDEV-34870)

  • JOIN_FIXED_ORDER similar to existing STRAIGHT_JOIN hint

  • JOIN_ORDER to apply the specified table order

  • JOIN_PREFIX to hint what tables should be first in the join

  • JOIN_SUFFIX to hint what tables should be last in the join

• Add support for the MAX_EXECUTION_TIME hint (MDEV-34860)

GIS

New GIS functions. These functions improve compatibility with MySQL 8.

• ST_Validate (MDEV-34137)

• MBRCoveredBy (MDEV-34138)

• ST_Simplify (MDEV-34141)

• ST_GeoHash (MDEV-34158)

• ST_LatFromGeoHash (MDEV-34159)

• ST_LongFromGeoHash (MDEV-34160)

• ST_PointFromGeoHash (MDEV-34277)

• ST_IsValid (MDEV-34276)

• ST_Collect (MDEV-34278)

Trigger

• Add support for TRIGGERS that fire on multiple events (MDEV-10164)

Replication

• Server displays if it was started with the skip-slave-start option (MDEV-27669)

Galera

• Skip FK checks in Galera during applying in IST (MDEV-34822)

Audit Plugin

• Log HOST:PORT of incoming connection instead of just the host (MDEV-1282)

• Add tls_version field for connection audit plugins (MDEV-33834)

Configuration

• Get option group suffix from $MARIADB_GROUP_SUFFIX in addition to $MYSQL_GROUP_SUFFIX (MDEV-21375)

mariadb Client

• Can set an alternative directory path for searching scripts invoked via the source command, with the --script-dir mariadb client option (MDEV-23818)

List of All MariaDB 12.0 Releases

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