MariaDB 5.5.38 Changelog

The most recent release in the MariaDB 5.5 series is:MariaDB 5.5.68 Download Now

DownloadRelease NotesChangelog[Overview of 5.5

Release date: 9 Jun 2014

For the highlights of this release, see the release notes.

The revision number links will take you to the revision's page on Launchpad. On Launchpad you can view more details of the revision and view diffs of the code modified in that revision.

• Revision #4214 Thu 2014-06-05 19:25:51 +0200

  • fix range.test

• Thu 2014-06-05 19:18:35 +0400

  • : Emoji unicode character string search query makes mariadb performance down - When range optimizer cannot the lookup value into [VAR]CHAR(n) column, it should produce: = "Impossible range" for equality = "no range" for non-equalities.

• [merge] Thu 2014-06-05 09:15:25 +0400

  • Merge 5.3->5.5

  • Thu 2014-06-05 09:01:05 +0400

    • Fixing a valgrind warning introduced in the previous changeset: "have_warnings" was set to an uninialized value when converting a negative number to datetime.

• [merge] Wed 2014-06-04 21:53:15 +0400

  • Merge 5.3->5.5

  • Wed 2014-06-04 20:32:57 +0400

    • Wrong results for a huge unsigned value inserted into a TIME column Bad results for DATE_ADD(.., INTERVAL 2000000000000000000.0 SECOND)

• Wed 2014-06-04 10:10:19 +0300

  • : Error while executing an update query that has the same table in a sub-query

• Tue 2014-06-03 10:58:03 +0200

  • mark tokudb in 5.5 as MariaDB_PLUGIN_MATURITY_GAMMA, not MariaDB_PLUGIN_MATURITY_ALPHA.

• Tue 2014-06-03 10:57:57 +0200

  • cmake: mark AIO_LIBRARY, EVENT_LIBRARY, GROFF, NROFF as advanced; use -ggdb3 if supported

• Tue 2014-06-03 10:52:36 +0200

  • Add a test case for MySQL's: Bug #18167356: EXPLAIN W/ EXISTS(SELECT* UNION SELECT*) WHERE ONE OF SELECT* IS DISTINCT FAILS.

• [merge] Tue 2014-06-03 09:55:08 +0200

  • mysql-5.5.38 merge

• [merge] Tue 2014-06-03 09:53:10 +0200

  • merge with XtraDB 5.5.37-35.0

  • Mon 2014-06-02 23:25:54 +0200

    • percona-server-5.5.37-35.0.tar.gz

• [merge] Mon 2014-06-02 19:08:59 +0200

  • 5.3 merge

  • [merge] Mon 2014-06-02 17:38:58 +0200

    • 5.2 merge
• Sun 2014-06-01 11:23:20 +0200

  • don't install ndb related .ini files, remove mysql_fix_privilege_tables.1 and mysqlman.1

• Sat 2014-05-31 13:18:56 +0200

  • MariaDB-5.5.35 - references are made to an "EXCEPTIONS-CLIENT" file but it does not exist

• Sat 2014-05-31 10:16:25 +0200

  • disable unstable tokudb tests

• Fri 2014-05-30 23:19:26 +0200

  • Minor man pages formatting issues Typo in mysql_install_db scripts and collateral changes:

• Thu 2014-05-29 02:25:37 +0400

  • : Partition pruning is not working as expected in an inner query - Make partition pruning work for tables inside semi-join nests (the new condition is the same that range optimizer uses so it should be ok)

• Tue 2014-05-27 21:05:44 +0200

  • update MSI installer to include latest Version of HeidiSQL (8.3.x.x)

• Tue 2014-05-27 20:57:28 +0200

  • Export my_progname symbol in libmysqlclient.so

• Wed 2014-05-28 17:32:43 +0400

  • : Wrong result when using IN subquery with order by - When the optimizer chose LooseScan, make_join_readinfo() should use the index that was chosen for LooseScan, and should not try to find a better (shortest) index.

• Wed 2014-05-28 16:51:19 +0500

  • sys_vars.completion_type_func fails in --embedded.

• Tue 2014-05-06 12:13:03 +0400

  • - Assertion `! (&(&LOCK_open)->m_mutex)->count || ! pthread_equal(pth read_self(), (&(&LOCK_open)->m_mutex)->thread)' fails in intern_sys_var_ptr on server shutdown after uninstalling TokuDB plugin at runtime

• Tue 2014-05-27 09:45:01 +0300

  • 2 typo fixed

• Thu 2014-05-22 16:20:56 +0300

  • : fails to start with 10.0 InnoDB log files

• Wed 2014-05-21 13:14:43 +0300

  • : fails to start with 10.0 InnoDB log files

• Sat 2014-05-17 10:42:59 +0300

  • Certain compressed tables with myisampack are corrupted by "CHECK TABLE" - Fixed bug that we where using wrong checksum algorithm when using VARCHAR with fixed lenth rows - Ensure in myisampack that HA_OPTION_NULL_FIELDS is set for tables with null fields.

• Mon 2014-05-12 12:56:13 +0200

  • Wrong result - count(distinct), Using index for group-by (scanning)

• Fri 2014-05-09 11:03:39 +0300

  • : Assertion range_end >= range_start fails in log0online.c on select from I_S.INNODB_CHANGED_PAGES

• Thu 2014-05-08 22:56:36 +0300

  • : Problems with multi-table updates that JOIN against read-only table

• [merge] Wed 2014-05-07 09:28:12 +0300

  • merge 5.5->5.3

  • Thu 2014-05-01 17:19:17 +0300

    • : name resolution issues with views and multi-update in ps-protocol

• Tue 2014-05-06 23:44:02 +0300

  • Fixed bug where CHECK TABLE for a MYISAM table before 5.5.38 wrongly gave warning: "Table upgrade required..."

• Tue 2014-05-06 14:52:40 +0200

  • update test file for windows

• Tue 2014-05-06 14:40:32 +0200

  • after tokudb-7.1.6 merge

• [merge] Mon 2014-05-05 22:59:44 +0200

  • merge: git://github.com/Tokutek/ft-index.git git://github.com/Tokutek/ft-engine.git at the tag tokudb-7.1.6

• Mon 2014-05-05 15:41:29 +0200

  • update test results

• Mon 2014-05-05 14:24:25 +0200

  • [PATCH] mysqldump writes usage to stdout even when not explicitly requested

• Mon 2014-05-05 12:51:21 +0200

  • fix broken -DWITHOUT_SERVER build: move sql-dependent unit test from mysys/ to sql/

• Mon 2014-05-05 12:51:11 +0200

  • Unable to build Connector/ODBC 5.2.5 undefined reference to `my_charset_latin1'

• Thu 2014-05-01 15:43:51 +0200

  • mysqldump goes in a loop and segfaults if --dump-slave is specified and it cannot connect to the server

• Mon 2014-04-28 12:11:35 +0200

  • fix XtraDB version to tell the truth

• Mon 2014-04-28 11:11:16 +0200

  • rename handler::ha_set_lock_type() -> handler::set_lock_type(), because it's not a handler convenience wrapper

• Fri 2014-02-28 15:46:02 +0400

  • - Simple performance improvement for MariaDB

• Sat 2014-05-03 19:12:17 +0300

  • Added new states to be able to better diagnose where server hangs. - Table locks now ends with state "After table lock" - Open table now ends with state "After opening tables" - All calls to close_thread_tables(), not only from mysql_execute_command(), has state "closing tables" - Added state "executing" for mysql admin commands, like CACHE INDEX, REPAIR TABLE etc. - Added state "Finding key cache" for CACHE INDEX - Added state "Filling schema table" when we generate temporary table for SHOW commands and information schema.

• Tue 2014-04-29 14:38:01 +0400

  • An after-fix for Can't mix (latin1_swedish_ci,NUMERIC) and (utf8_unicode_ci,IMPLICIT) for MATCH The original patch broke "mtr --ps fulltext".

• Mon 2014-04-28 17:01:58 +0400

  • Illegal mix of collations for datetime

• Mon 2014-04-28 15:56:31 +0400

  • Incorrect results are returned with NULLIF()

• Mon 2014-04-28 09:13:53 +0300

  • : UPDATE w/ join against MRG_MyISAM table with read-only sub-table failsUPDATE w/ join against MRG_MyISAM table with read-only sub-table fails

• Mon 2014-04-28 08:30:05 +0300

  • : InnoDB: Failing assertion: page_is_comp(next_page) == page_is_comp(page)

• Mon 2014-04-28 03:37:53 +0400

  • Modified the condition for skipping innodb.innodb-autoinc to exclude the part which was defined by MariaDB version and thus caused a wrong check result

• Mon 2014-04-28 02:56:53 +0400

  • mysql_upgrade breaks databases with long user names

• Sat 2014-04-26 23:16:51 +0400

  • main.myisam-metadata fails mtr internal check

• Sat 2014-04-26 21:32:08 +0400

  • rpl.rpl_heartbeat_basic fails mtr internal check

• Sat 2014-04-26 21:29:15 +0400

  • Increment the version number

• Thu 2014-04-24 18:20:57 +0300

  • : Server crashes during UNION with ORDER BY field IS NULL

• [merge] Wed 2014-04-23 17:43:20 +0400

  • Merge 5.3->5.5

  • Wed 2014-04-23 15:53:47 +0400

    • XML parser accepts malformed data

• Wed 2014-04-23 10:28:06 +0400

  • Can't mix (latin1_swedish_ci,NUMERIC) and (utf8_unicode_ci,IMPLICIT) for MATCH

• [merge] Mon 2014-04-21 14:22:18 +0400

  • Merge from 5.3

  • Mon 2014-04-21 13:19:32 +0400

    • MySQL Bug#11829861 - SUBSTRING_INDEX() RESULTS "OMIT" CHARACTER WHEN USED INSIDE LOWER()

• [merge] Mon 2014-04-21 12:19:47 +0400

  • Merge from 5.3.

  • Mon 2014-04-21 11:29:50 +0400

    • An after-fix for SUBSTRING_INDEX returns wrong result for 8bit character sets when delimiter is not found
• [merge] Fri 2014-04-18 13:41:15 +0400

  • Merge from 5.3

  • Fri 2014-04-18 12:19:51 +0400

    • Inserting a TIME with hour>24 into a DATETIME column produces a wrong value

• [merge] Fri 2014-04-18 12:16:56 +0400

  • Merge from 5.3

  • Wed 2014-04-16 22:34:52 -0700

    • Fixed bugs and . Both bugs are caused by the same problem: the function optimize_cond() should update the value of *cond_equal rather than the value of join->cond_equal, because it is called not only for the WHERE condition, but for the HAVING condition as well.

• Thu 2014-04-17 02:12:08 +0500

  • Audit plugin fails with the Percona-Server 5.6. Some lines of code in file_logger.c were lost while moving to the general MariaDB tree. Adding them.

• Tue 2014-04-15 20:41:08 +0500

  • SQL_ERROR_LOG shows 1146 errors which didnt appear in mysql client. The fill_schema_table() function used to call get_table_share() for a table name in WHERE then clear the error list. That way plugins receive the superfluous error notification if it happens in it. Also the problem was that error handler didn't prevent the suppressed error message from logging anyway as the logging happens in THD::raise_condition before the handler call. Trigger_error_handler is remade into Warnings_only_error_handler, so it stores the error message in all cases in the thd->stmt_da. Then later the stored error is raised.

• Tue 2014-04-15 18:17:47 +0500

  • Numerous test failures in "mtr --ps --embedded". If a prepared statement calls an stored procedure, the thd->server_status out of the SP goes up to the PS and then to the client. So that the client gets the SERVER_STATUS_CURSOR_EXISTS status if the SP uses a cursor. Which makes the embedded server fail. Fixed by saving/restoring the upper-level server_status in sp_head::execute().

• Tue 2014-04-15 18:16:47 +0500

  • Numerous test failures in "mtr --ps --embedded". Thread can be disconnected internally for example after COMMIT statements. So we should check this for the statement execution.

• Tue 2014-04-15 18:12:25 +0500

  • Numerous test failures in "mtr --ps --embedded". mysqltest in the 'embedded-server' mode runs queries in a separate thread, but it didn't do so for the prepared statements - they were run in the main thread. That leads to inconsistencies. When a test sets SESSION 'dbug' variable like SET SESSION debug_dbug="+d,warn_during_ha_commit_trans"; it is run as a plain query in that separate thread, so the main thread remains unaffected. After that the prepared statement run in the main thread doesn't produce expected 'dbug' errors, so the test fails. To fix that I made prepared statement to be run in that special thread along with the plain queries. That makes the environment consistent.

• Tue 2014-04-15 18:09:58 +0500

  • Numerous test failures in "mtr --ps --embedded". As Davi added code like sav_protocol= thd->protocol thd->protocol= &thd->protocol_binary ... thd->protocol= sav_protocol the fucntions like emb_store_querycache_result() cannot determine the used protocol testing thd->protocol == &thd->protocol_binary. Fixed by additional check thd->command == COM_STMT_EXECUTE.

• Tue 2014-04-15 18:08:33 +0500

  • Numerous test failures in "mtr --ps --embedded". The function Protocol::net_store_data(a, b, CHARSET_A, CHARSET_B) should be adapted to be working in the embedded server as it's done with the Protocol::net_store_data(a, b). That new function renamed as net_store_data_cs, so we can make it virtual.