# MariaDB 5.5.23 Changelog

The most recent release in the [MariaDB 5.5](https://mariadb.com/docs/release-notes/community-server/old-releases/5.5/changes-improvements-in-mariadb-5-5) series is:[**MariaDB 5.5.68**](https://mariadb.com/docs/release-notes/community-server/old-releases/5.5/5.5.68) [Download Now](https://downloads.mariadb.org/mariadb/5.5.68/)

[Download](https://downloads.askmonty.org/mariadb/5.5.23) |[Release Notes](https://mariadb.com/docs/release-notes/community-server/old-releases/5.5/5.5.23) |**Changelog** |\[[Overview of 5.5](https://mariadb.com/docs/release-notes/mariadb-community-server-release-notes/old-releases/release-notes-mariadb-5-5-series/changes-improvements-in-mariadb-5-5)

**Release date:** 11 Apr 2012

For the highlights of this release, see the [release notes](https://mariadb.com/docs/release-notes/community-server/old-releases/5.5/5.5.23).

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 #3367](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/3367)\
  Tue 2012-04-10 08:30:20 +0200
  * tweak the test to pass, until the upstream [MySQL Bug #61209](https://bugs.mysql.com/bug.php?id=61209) is *completely* fixed\
    (see my comments starting from \[9 Apr 22:18])
* [Revision #3366](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/3366) \[merge]\
  Tue 2012-04-10 08:28:13 +0200
  * mysql 5.5.23 merge
* [Revision #3365](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/3365) \[merge]\
  Sat 2012-04-07 15:58:46 +0200
  * merge
  * [Revision #2502.546.39](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.546.39)\
    Sat 2012-04-07 02:29:04 -0700
    * Fixed [Bug #972973](https://bugs.launchpad.net/bugs/972973).
    * When the function free\_tmp\_table deletes the handler object for\
      a temporary table the field TABLE::file for this table should be\
      set to NULL. Otherwise an assertion failure may occur.
  * [Revision #2502.546.38](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.546.38) \[merge]\
    Fri 2012-04-06 16:40:39 -0700
    * Merge.
    * [Revision #2502.555.1](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.555.1)\
      Fri 2012-04-06 15:08:09 -0700
      * Fixed [Bug #915222](https://bugs.launchpad.net/bugs/915222)
      * This bug happened because the function find\_field\_in\_view formed\
        autogenerated names of view columns without a possibility to roll\
        them back. In some situation it could cause memory misuses reported\
        by valgrind or even crashes.
  * [Revision #2502.546.37](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.546.37)\
    Fri 2012-04-06 13:18:12 +0300
    * Unused method removed.
  * [Revision #2502.546.36](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.546.36) \[merge]\
    Fri 2012-04-06 14:24:00 +0500
    * merging.
    * [Revision #2502.528.29](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.528.29) \[merge]\
      Fri 2012-04-06 13:51:42 +0500
      * merging.
      * [Revision #2502.554.4](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.554.4)\
        Fri 2012-04-06 13:31:33 +0500
        * [MDEV-80](https://jira.mariadb.org/browse/MDEV-80) Memory engine table full at much less than max\_heap\_table\_size with btree index.
        * RB-tree index in the MEMORY table fails if it grews over 4G.
        * That happened because the old\_allocated variable in hp\_rb\_write\_key()\
          had the uint type. Changed with the 'size\_t' type to be same as the\
          'rb\_tree.allocated'.
        * per-file comments:
          * storage/heap/hp\_write.c
        * [MDEV-80](https://jira.mariadb.org/browse/MDEV-80) Memory engine table full at much less than max\_heap\_table\_size with btree index.
          * uint->size\_t for the 'old\_allocated'.
  * [Revision #2502.546.35](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.546.35) \[merge]\
    Thu 2012-04-05 23:07:18 +0200
    * merge
    * [Revision #2502.528.28](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.528.28) \[merge]\
      Thu 2012-04-05 12:01:52 +0200
      * merge
      * [Revision #2502.554.3](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.554.3) \[merge]\
        Thu 2012-04-05 10:49:38 +0200
        * mysql-5.1.62 merge
      * [Revision #2502.554.2](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.554.2)\
        Wed 2012-04-04 15:41:50 +0200
        * [MDEV-212](https://jira.mariadb.org/browse/MDEV-212) sporadic main.connect failures in 5.3
        * don't cast implicitly an int to a char, when a boolean value is desired.
  * [Revision #2502.546.34](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.546.34)\
    Thu 2012-04-05 23:32:57 +0300
    * Fix of [Bug #968720](https://bugs.launchpad.net/bugs/968720).
    * When a view/derived table is converted from merged to materialized the\
      items from the used\_item lists are substituted for items referring to\
      the fields of the result of the materialization. The problem appeared\
      with queries employing natural joins. Since the resolution of a natural\
      join was performed only once the used\_item list formed at the second\
      execution of the query lacked the references to the fields that were\
      used only in the equality predicates generated for the natural join.
  * [Revision #2502.546.33](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.546.33)\
    Wed 2012-04-04 21:35:34 +0400
    * Make test results stable.
  * [Revision #2502.546.32](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.546.32) \[merge]\
    Wed 2012-04-04 14:19:46 +0300
    * Merge with 5.2
    * Fixed additional changed pbxt test cases
    * [Revision #2502.528.27](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.528.27) \[merge]\
      Wed 2012-04-04 13:50:24 +0300
      * Merge with 5.1
      * [Revision #2502.554.1](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.554.1) \[merge]\
        Wed 2012-04-04 13:38:19 +0300
        * Merge in deleted fixes
        * [Revision #2502.551.2](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.551.2)\
          Wed 2012-04-04 13:20:06 +0300
          * Fixed test cases that changed as part of fixing bugs with record count and partitioning
  * [Revision #2502.546.31](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.546.31) \[merge]\
    Wed 2012-04-04 12:37:46 +0400
    * Merge
    * [Revision #2502.553.2](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.553.2)\
      Wed 2012-04-04 12:26:36 +0400
      * [Bug #913030](https://bugs.launchpad.net/bugs/913030): better comments and function names.
    * [Revision #2502.553.1](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.553.1) \[merge]\
      Mon 2012-04-02 21:47:31 +0400
      * Merge
      * [Revision #2502.552.1](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.552.1)\
        Mon 2012-04-02 21:41:54 +0400
        * [Bug #913030](https://bugs.launchpad.net/bugs/913030): Optimizer chooses a suboptimal excution plan for Q18 from DBT-3
        * When doing join optimization, pre-sort the tables so that they mimic the execution\
          order we've had with 'semijoin=off'.
        * That way, we will not get regressions when there are two query plans (the old and the\
          new) that have indentical costs but different execution times (because of factors that\
          the optimizer was not able to take into account).
  * [Revision #2502.546.30](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.546.30) \[merge]\
    Wed 2012-04-04 01:00:23 +0300
    * Merge with 5.2
    * [Revision #2502.528.26](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.528.26) \[merge]\
      Wed 2012-04-04 00:33:02 +0300
      * Merge with 5.1
      * [Revision #2502.551.1](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.551.1)\
        Wed 2012-04-04 00:14:07 +0300
        * Fixed [Bug #970528](https://bugs.launchpad.net/bugs/970528) "Server crashes in my\_strnncollsp\_simple on LEFT JOIN with CSV table, TEXT field"
        * The main problem was a bug in CSV where it provided wrong statistics (it claimed the table was empty when it wasn't)
        * I also fixed wrong freeing of blob's in the CSV handler. (Any call to handler::read\_first\_row() on a CSV table with blobs would fail)
* [Revision #3364](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/3364)\
  Thu 2012-04-05 15:57:27 +0200
  * [MDEV-208](https://jira.mariadb.org/browse/MDEV-208) thread pool breaks the server on XP
* [Revision #3363](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/3363)\
  Tue 2012-04-03 08:00:57 +0200
  * [Bug #886550](https://bugs.launchpad.net/bugs/886550) Wrong installation path for some include files.
  * Now install all includes in a flat hierarchy under\
    $PREFIX/include/mysq/, same as 5.3. User can override with\
    -DINSTALL\_INCLUDEDIR
* [Revision #3362](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/3362) \[merge]\
  Tue 2012-04-03 16:00:57 +0300
  * Merge with 5.3
  * [Revision #2502.546.29](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.546.29)\
    Tue 2012-04-03 15:42:26 +0300
    * Don't disable core on signal just becasue platform doesn't handle stack traces
* [Revision #3361](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/3361)\
  Tue 2012-04-03 15:48:56 +0300
  * Define dummy my\_init\_stacktrace() to allow one to call it without #ifdef HAVE\_STACKTRACE
  * Fixed compilation problem on windows.
* [Revision #3360](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/3360) \[merge]\
  Mon 2012-04-02 18:31:11 +0200
  * merge
  * [Revision #2502.546.28](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.546.28) \[merge]\
    Mon 2012-04-02 17:54:33 +0200
    * [MDEV-209](https://jira.mariadb.org/browse/MDEV-209)
    * merge
    * [Revision #2502.528.25](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.528.25)\
      Mon 2012-04-02 11:29:28 +0200
      * [MDEV-209](https://jira.mariadb.org/browse/MDEV-209) SET PASSWORD in 5.2 does not update user's auth plugin
* [Revision #3359](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/3359) \[merge]\
  Mon 2012-04-02 13:33:16 +0300
  * Merge of compatibility fixes
  * Fixed failing tests in sys\_vars as we have now stricter checking of setting of variables.
  * [Revision #2502.546.27](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.546.27) \[merge]\
    Mon 2012-04-02 12:27:15 +0300
    * automatic merge
    * [Revision #2502.550.2](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.550.2)\
      Mon 2012-04-02 11:45:07 +0300
      * Fixed [Bug #886479](https://bugs.launchpad.net/bugs/886479) "\[PATCH] plugin boolean result"
      * Thanks to Maarten Vanraes for the patch
      * [Revision #2502.550.1](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.550.1)\
        Fri 2012-03-30 16:00:10 +0300
        * Compatibility fixes by U Orsini
  * [Revision #2502.546.26](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.546.26) \[merge]\
    Fri 2012-03-30 16:13:41 +0200
    * merge
    * [Revision #2502.528.24](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.528.24) \[merge]\
      Fri 2012-03-30 16:12:21 +0200
      * merge
      * [Revision #2502.352.86](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.352.86)\
        Fri 2012-03-30 16:09:57 +0200
        * [MDEV-205](https://jira.mariadb.org/browse/MDEV-205) don't install libevent headers
  * [Revision #2502.546.25](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.546.25) \[merge]\
    Fri 2012-03-30 13:54:33 +0300
    * Merge from 5.2
    * [Revision #2502.528.23](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.528.23) \[merge]\
      Fri 2012-03-30 13:51:16 +0300
      * Automatic merge
      * [Revision #2502.352.85](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.352.85)\
        Fri 2012-03-30 13:42:52 +0300
        * Fixed [Bug #967914](https://bugs.launchpad.net/bugs/967914) "CHECK TABLE persistently reports table corruption after removing Aria logs"
        * Fixed that repair removes the 'table is moved' mark.
  * [Revision #2502.546.24](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.546.24) \[merge]\
    Fri 2012-03-30 08:49:57 +0200
    * merge
    * [Revision #2502.528.22](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.528.22) \[merge]\
      Thu 2012-03-29 21:15:30 +0200
      * merge
      * [Revision #2502.352.84](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.352.84)\
        Thu 2012-03-29 18:06:08 +0200
        * fix the test case for windows: replace\_result /
      * [Revision #2502.352.83](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.352.83)\
        Thu 2012-03-29 16:36:06 +0200
        * make the code compile again
  * [Revision #2502.546.23](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.546.23)\
    Thu 2012-03-29 16:32:35 +0200
    * remove race conditions from the test
  * [Revision #2502.546.22](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.546.22)\
    Thu 2012-03-29 21:58:40 +0200
    * Add missing include (fixes compile failure with gcc 4.7).
  * [Revision #2502.546.21](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.546.21) \[merge]\
    Wed 2012-03-28 13:58:14 +0300
    * Automatic merge
    * [Revision #2502.528.21](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.528.21) \[merge]\
      Wed 2012-03-28 13:49:07 +0300
      * Merge with 5.1
      * [Revision #2502.352.82](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/2502.352.82)\
        Wed 2012-03-28 13:22:21 +0300
        * Fixed [Bug #944422](https://bugs.launchpad.net/bugs/944422) "mysql\_upgrade destroys Maria tables?"
        * The issue was that check/optimize/anaylze did not zerofill the table before they started to work on it.
        * Added one more element to not often used function handler::auto\_repair() to allow handler to decide when to auto repair.
* [Revision #3358](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/3358) \[merge]\
  Mon 2012-04-02 12:31:53 +0300
  * automatic merge
  * [Revision #3354.1.4](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/3354.1.4)\
    Mon 2012-04-02 12:30:14 +0300
    * Ignore install\_manifest.txt (created by 'make install')
  * [Revision #3354.1.3](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/3354.1.3)\
    Mon 2012-04-02 12:09:22 +0300
    * Fixed [Bug #886484](https://bugs.launchpad.net/bugs/886484) "nowatch option for mysqld (allow systemd)"
    * Added a `--nowatch` (with aliases`--no-watch` and `--no-auto-restart`) option\
      to mysqld\_safe that causes it to exit after spawning mysqld. We don't need\
      mysqld\_safe to restart mysqld after a crash, because systemd can do that\
      just fine.
    * Based on code from Maarten Vanraes
  * [Revision #3354.1.2](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/3354.1.2)\
    Mon 2012-04-02 10:53:09 +0300
    * Partial fix for [Bug #886476](https://bugs.launchpad.net/bugs/886476) \[PATCH] disable tests
    * By Maarten Vanraes
  * [Revision #3354.1.1](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/3354.1.1)\
    Wed 2012-03-28 14:46:03 +0300
    * Applied patch for guard stack for PPC/IA64 by Maarten Vanraes ([Bug #886368](https://bugs.launchpad.net/bugs/886368))
* [Revision #3357](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/3357)\
  Fri 2012-03-30 22:15:44 +0200
  1. support for testing statically built oqgraph
  2. my\_new\.cc should redefine new (std:nothrow) too.
* [Revision #3356](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/3356)\
  Thu 2012-03-29 16:02:19 +0200
  * Fix race in rpl.rpl\_checksum.
* [Revision #3355](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/3355) \[
  * merge]\
    Thu 2012-03-29 14:49:22 +0200
  * merge
* [Revision #3354](https://bazaar.launchpad.net/~maria-captains/maria/5.5-release/revision/3354)\
  Wed 2012-03-28 01:11:05 +0200
  * Windows threadpool - always disassociate current thread from callback when destroying connection\
    prior to closing callbacks and calling DestroyThreadpoolEnvironment, to make sure callbacks\
    do not wait for themselves to finish.

{% hint style="info" %}
Be notified of new MariaDB Server releases automatically by [subscribing](https://lists.mariadb.org/postorius/lists/announce.lists.mariadb.org/) 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](https://app.gitbook.com/s/WCInJQ9cmGjq1lsTG91E/distributions-including-mariadb) page.
{% endhint %}

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formid="4316" formId="4316" %}