The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-12-25. For the latest, interactive version please visit https://mariadb.com/kb/.

MariaDB 5.5.38 Changelog

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

Download Release Notes Changelog 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
  • Revision #4213 Thu 2014-06-05 19:18:35 +0400
    • MDEV-6105: 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.
  • Revision #4212 [merge] Thu 2014-06-05 09:15:25 +0400
    • Merge 5.3->5.5
    • Revision #2502.567.232 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.
  • Revision #4211 [merge] Wed 2014-06-04 21:53:15 +0400
    • Merge 5.3->5.5
    • Revision #2502.567.231 Wed 2014-06-04 20:32:57 +0400
      • MDEV-4858 Wrong results for a huge unsigned value inserted into a TIME column MDEV-6099 Bad results for DATE_ADD(.., INTERVAL 2000000000000000000.0 SECOND) MDEV-6097 Inconsistent results for CAST(int,decimal,double AS DATETIME) MDEV-6100 No warning on CAST(9000000 AS TIME)
  • Revision #4210 Wed 2014-06-04 10:10:19 +0300
    • MDEV-6163: Error while executing an update query that has the same table in a sub-query
  • Revision #4209 Tue 2014-06-03 10:58:03 +0200
    • mark tokudb in 5.5 as MariaDB_PLUGIN_MATURITY_GAMMA, not MariaDB_PLUGIN_MATURITY_ALPHA.
  • Revision #4208 Tue 2014-06-03 10:57:57 +0200
    • cmake: mark AIO_LIBRARY, EVENT_LIBRARY, GROFF, NROFF as advanced; use -ggdb3 if supported
  • Revision #4207 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.
  • Revision #4206 [merge] Tue 2014-06-03 09:55:08 +0200
    • mysql-5.5.38 merge
  • Revision #4205 [merge] Tue 2014-06-03 09:53:10 +0200
    • merge with XtraDB 5.5.37-35.0
    • Revision #0.12.68 Mon 2014-06-02 23:25:54 +0200
      • percona-server-5.5.37-35.0.tar.gz
  • Revision #4204 [merge] Mon 2014-06-02 19:08:59 +0200
  • Revision #4203 Sun 2014-06-01 11:23:20 +0200
    • don't install ndb related .ini files, remove mysql_fix_privilege_tables.1 and mysqlman.1
  • Revision #4202 Sat 2014-05-31 13:18:56 +0200
    • MDEV-5645 MariaDB-5.5.35 - references are made to an "EXCEPTIONS-CLIENT" file but it does not exist
  • Revision #4201 Sat 2014-05-31 10:16:25 +0200
    • disable unstable tokudb tests
  • Revision #4200 Fri 2014-05-30 23:19:26 +0200
    • MDEV-5485 Minor man pages formatting issues MDEV-6281 Typo in mysql_install_db scripts and collateral changes:
  • Revision #4199 Thu 2014-05-29 02:25:37 +0400
    • MDEV-6239: 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)
  • Revision #4198 Tue 2014-05-27 21:05:44 +0200
    • MDEV-6271 update MSI installer to include latest Version of HeidiSQL (8.3.x.x)
  • Revision #4197 Tue 2014-05-27 20:57:28 +0200
    • MDEV-6273 Export my_progname symbol in libmysqlclient.so
  • Revision #4196 Wed 2014-05-28 17:32:43 +0400
    • MDEV-6263: 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.
  • Revision #4195 Wed 2014-05-28 16:51:19 +0500
    • MDEV-6216 sys_vars.completion_type_func fails in --embedded.
  • Revision #4194 Tue 2014-05-06 12:13:03 +0400
    • MDEV-6083 - 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
  • Revision #4193 Tue 2014-05-27 09:45:01 +0300
    • 2 typo fixed
  • Revision #4192 Thu 2014-05-22 16:20:56 +0300
  • Revision #4191 Wed 2014-05-21 13:14:43 +0300
  • Revision #4190 Sat 2014-05-17 10:42:59 +0300
    • MDEV-6245 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.
  • Revision #4189 Mon 2014-05-12 12:56:13 +0200
    • MDEV-4925 Wrong result - count(distinct), Using index for group-by (scanning)
  • Revision #4188 Fri 2014-05-09 11:03:39 +0300
    • MDEV-4791: Assertion range_end >= range_start fails in log0online.c on select from I_S.INNODB_CHANGED_PAGES
  • Revision #4187 Thu 2014-05-08 22:56:36 +0300
    • MDEV-6193: Problems with multi-table updates that JOIN against read-only table
  • Revision #4186 [merge] Wed 2014-05-07 09:28:12 +0300
  • Revision #4185 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..."
  • Revision #4184 Tue 2014-05-06 14:52:40 +0200
    • update test file for windows
  • Revision #4183 Tue 2014-05-06 14:40:32 +0200
    • after tokudb-7.1.6 merge
  • Revision #4182 [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
  • Revision #4181 Mon 2014-05-05 15:41:29 +0200
    • update test results
  • Revision #4180 Mon 2014-05-05 14:24:25 +0200
    • MDEV-6056 [PATCH] mysqldump writes usage to stdout even when not explicitly requested
  • Revision #4179 Mon 2014-05-05 12:51:21 +0200
    • fix broken -DWITHOUT_SERVER build: move sql-dependent unit test from mysys/ to sql/
  • Revision #4178 Mon 2014-05-05 12:51:11 +0200
    • MDEV-6131 Unable to build Connector/ODBC 5.2.5 undefined reference to `my_charset_latin1'
  • Revision #4177 Thu 2014-05-01 15:43:51 +0200
    • MDEV-6091 mysqldump goes in a loop and segfaults if --dump-slave is specified and it cannot connect to the server
  • Revision #4176 Mon 2014-04-28 12:11:35 +0200
    • fix XtraDB version to tell the truth
  • Revision #4175 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
  • Revision #4174 Fri 2014-02-28 15:46:02 +0400
    • MDEV-5081 - Simple performance improvement for MariaDB
  • Revision #4173 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.
  • Revision #4172 Tue 2014-04-29 14:38:01 +0400
    • An after-fix for MDEV-6146 Can't mix (latin1_swedish_ci,NUMERIC) and (utf8_unicode_ci,IMPLICIT) for MATCH The original patch broke "mtr --ps fulltext".
  • Revision #4171 Mon 2014-04-28 17:01:58 +0400
    • MDEV-5459 Illegal mix of collations for datetime
  • Revision #4170 Mon 2014-04-28 15:56:31 +0400
    • MDEV-5702 Incorrect results are returned with NULLIF()
  • Revision #4169 Mon 2014-04-28 09:13:53 +0300
    • MDEV-6139: 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
  • Revision #4168 Mon 2014-04-28 08:30:05 +0300
    • MDEV-6160: InnoDB: Failing assertion: page_is_comp(next_page) == page_is_comp(page)
  • Revision #4167 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
  • Revision #4166 Mon 2014-04-28 02:56:53 +0400
    • MDEV-6178 mysql_upgrade breaks databases with long user names
  • Revision #4165 Sat 2014-04-26 23:16:51 +0400
    • MDEV-6169 main.myisam-metadata fails mtr internal check
  • Revision #4164 Sat 2014-04-26 21:32:08 +0400
    • MDEV-6168 rpl.rpl_heartbeat_basic fails mtr internal check
  • Revision #4163 Sat 2014-04-26 21:29:15 +0400
    • Increment the version number
  • Revision #4162 Thu 2014-04-24 18:20:57 +0300
    • MDEV-6129: Server crashes during UNION with ORDER BY field IS NULL
  • Revision #4161 [merge] Wed 2014-04-23 17:43:20 +0400
  • Revision #4160 Wed 2014-04-23 10:28:06 +0400
    • MDEV-6146 Can't mix (latin1_swedish_ci,NUMERIC) and (utf8_unicode_ci,IMPLICIT) for MATCH
  • Revision #4159 [merge] Mon 2014-04-21 14:22:18 +0400
    • Merge from 5.3
    • Revision #2502.567.226 Mon 2014-04-21 13:19:32 +0400
      • MDEV-6045 MySQL Bug#11829861 - SUBSTRING_INDEX() RESULTS "OMIT" CHARACTER WHEN USED INSIDE LOWER()
  • Revision #4158 [merge] Mon 2014-04-21 12:19:47 +0400
    • Merge from 5.3.
    • Revision #2502.567.225 Mon 2014-04-21 11:29:50 +0400
      • An after-fix for MDEV-6134 SUBSTRING_INDEX returns wrong result for 8bit character sets when delimiter is not found
    • Revision #2502.567.224 Mon 2014-04-21 10:13:38 +0400
      • MDEV-6134 SUBSTRING_INDEX returns wrong result for 8bit character sets when delimiter is not found
  • Revision #4157 [merge] Fri 2014-04-18 13:41:15 +0400
  • Revision #4156 [merge] Fri 2014-04-18 12:16:56 +0400
    • Merge from 5.3
    • Revision #2502.567.222 Wed 2014-04-16 22:34:52 -0700
      • Fixed bugs MDEV-5927 and MDEV-6116. 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.
  • Revision #4155 Thu 2014-04-17 02:12:08 +0500
    • MDEV-6124 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.
  • Revision #4154 Tue 2014-04-15 20:41:08 +0500
    • MDEV-4856 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.
  • Revision #4153 Tue 2014-04-15 18:17:47 +0500
    • MDEV-5138 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().
  • Revision #4152 Tue 2014-04-15 18:16:47 +0500
    • MDEV-5138 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.
  • Revision #4151 Tue 2014-04-15 18:12:25 +0500
    • MDEV-5138 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.
  • Revision #4150 Tue 2014-04-15 18:09:58 +0500
    • MDEV-5138 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.
  • Revision #4149 Tue 2014-04-15 18:08:33 +0500
    • MDEV-5138 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.
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.