MariaDB 10.0.18 Release Notes

You are viewing an old version of this article. View the current version here.

Note: This page describes features in the source repository for MariaDB 10.0. There are currently no official packages or binaries available for download which contain the features. If you want to try out any of the new features described here you will need to get and compile the code yourself.

MariaDB 10.0 is the current stable series of MariaDB. It is an evolution of the MariaDB 5.5 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6.

MariaDB 10.0.18 will be a Stable (GA) release.

For an overview of MariaDB 10.0 see the What is MariaDB 10.0? page.

Thanks, and enjoy MariaDB!

Notable Changes

Parser

  • Column was quoted with backticks in a function, in a HAVING clause, and it wasn't recognised - fixed now (MDEV-7301).
  • ALTER TABLE with conflicting CHARACTER SET and CONVERT TO CHARACTER SET arguments now reports error (MDEV-7386).
  • Fixed Regression (from 10.0.14): Bit and hex string literals changed column names (MDEV-7629).

Optimizer

Alter Table

  • Some symbols in table name can cause to Error Code: 1050 when created FK. Table name is on filename charset but foreign key identifiers are not. This lead incorrect foreign key identifier number to be used (MDEV-7627).
  • ALTER [ONLINE] TABLE with no options no longer requires a table copy (MDEV-7390).

Other SQL Commands

Innodb

  • In Debug builds, an assertion could be triggered on really large blobs (MDEV-7754).
  • Fixed segfault when a virtual column used on a innodb table and an index was created on a field after the virtual column (MDEV-7367).
  • Fixed server crash when inserting more rows than available space on disk (MDEV-7685).
  • Make it possible to get innodb internal primary key for wrapper type storage engines (MDEV-7714).

Replication

  • Starting with this release, commits in certain instances in parallel replication complete immediately, avoiding losing throughput when many transactions need conflicting locks. See binlog_commit_wait_count (MDEV-7847 / MDEV-7882).
  • Fixed parallel replication worker threads can hang in some cases with non-transactional event groups (MDEV-7929).
  • Fixed parallel replication error where deadlock was incorrectly handled (MDEV-8031).
  • Fixed replication aborting on DROP /*!40005 TEMPORARY */ TABLE IF EXISTS (MDEV-8016).
  • Fixed replication of temporary tables in statement mode that are grouped - fix MDEV-7668 wasn't sufficient (MDEV-7936).
  • Fixed ANALYZE TABLE which was ordered incorrectly in the binlog (MDEV-7888).
  • Added more detailed information about errors when GTID mode IO threads fail to connect (MDEV-7975).
  • Fixed temporary tables lost at STOP SLAVE in GTID mode if master has not rotated binlog since restart (MDEV-6403).
  • Incorrect relay log start position when restarting SQL thread after error in parallel replication (MDEV-6589).
  • Slave is 10x slower to execute set of statements compared to master when using RBR (MDEV-7578).
  • Parallel replication worker threads are not spawned until needed (when an SQL thread is started), and they will be de-spawned if all SQL threads are stopped (MDEV-5289).
  • Multilevel slaves with parallel replication - better logic resulted in performance increase to group more transactions at the first slave level resulting in increased parallelism at the second replication level (MDEV-7249).
  • Intermediate master groups using CREATE TEMPORARY with INSERT, can cause the INSERT to occur before the TEMPORARY TABLE it operates on, causing parallel replication failure (MDEV-7668).
  • Fixed errorneous -> erroneous spelling mistake in replication error message (MDEV-7785).
  • Slave SQL: stopping replication on a non-last RBR event with annotations no longer in segfaults (MDEV-7864).
  • : MASTER_POS_WAIT(log_name,log_pos,timeout,"connection_name") when connection name is specified now respects the timeout (MDEV-7130).
  • New status variables binlog_group_commit_trigger_count, binlog_group_commit_trigger_timeout, and binlog_group_commit_trigger_lock_wait used to examine which triggers caused a group commit to be made (MDEV-7802).

Platforms

  • PowerPC - fixed Innodb locking issue under high load - (MDEV-7148).
  • BigEndian fails to build in cassandra storage engine (MDEV-7839).
  • Crash when running MariaDB Debug with InnoDB on Windows (MDEV-8079).

Connect Engine

  • CONNECT Engine Column names are not retrieved properly when field values are not latin1 characters (MDEV-7521).
  • Connecting to missing remote table caused error that was re-reported when SHOW TABLE STATUS on a correctly formed table (MDEV-7636).
  • CONNECT returns error 174 on query to MS SQL Server 2012 involving timestamp column when the condition is given as a date literal (MDEV-7840).
  • CONNECT does not work with if(exists(select * from test)) statement in procedures (MDEV-7852).
  • test connect.json fails with valgrind warnings (MDEV-7879)
  • Same query cannot be executed using CONNECT Engine (MDEV-7890).
  • User variable assignment with SET @var = results in ERROR 1148 (42000): CONNECT Unsupported command (MDEV-7616).

OQ Graph Engine

Other

  • SSL connections increased from 512 to 1024 bits to support fips (MDEV-7794).
  • Tell OpenSSL to use MD5 even if FIPS prohibits it (previously crashed). This is fine as long as we do not use MD5 for cryptographical purposes (md5 is used internally for P_S message digests and for view checksums) (MDEV-7788).
  • initialization of status variables was not invoked for embedded - no corrected (no bug reference. code change)

Test

  • mysql-test-run creates nested links when tests are run with --mem (MDEV-7643).
  • buildbot may leave stale mysqld (MDEV-7659).
  • Fixed test suite failure - mysql-test - SUITE:percona - percona.innodb_sys_index 'xtradb' fails - @@version_comment (MDEV-7692)
  • Fixed test failure in multi_source.multisource (MDEV-7107).
  • Fixed test perfschema.aggregate fails sporadically in buildbot (MDEV-7187)
  • fips: some ssl tests with cipher specified failing as older ciphers removed from libraries (MDEV-7794).

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 Distributions which Include MariaDB page.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.