MariaDB Galera 5.5.29 Changelog

The most recent MariaDB Galera Cluster 5.5 release is:
MariaDB Galera Cluster 5.5.63 Download Now

Download | Release Notes | Changelog | Overview of Galera

Release date: 5 Mar 2013

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 #3390 Tue 2013-03-05 00:01:20 +0200
- References: Bug #1144911 - merged fix for prepared statement processing from upstream. Merged fix is revision 3853 in lp:codership/codership-mysql/5.5-23
Revision #3389 Mon 2013-03-04 23:01:36 +0200
- References: MDEV-4211 - appended format description event for TOI replication write set, FD carries binlog checksum algorithm
Revision #3388 Sun 2013-03-03 03:22:48 +0400
- MDEV-4232 : percona.innodb_sys_index fails due to a wrong version_comment
Revision #3387 Sat 2013-03-02 12:23:08 +0200
- References: Bug #1136303 - adapting wsrep status variable usage according to wsrep provider version 2.2 behavior
Revision #3386 Thu 2013-02-28 21:25:56 -0500
- Removed the obsolete instructions from the MySQL 5.1 manual. Instead provide a link to https://kb.askmonty.org/en/compiling-mariadb-from-source/
Revision #3385 Thu 2013-02-28 21:25:04 -0500
- Added a MariaDB Galera Cluster section to the beginning of the README.
Revision #3384 Tue 2013-02-26 22:19:54 +0200
- References: Bug #1084702, Bug #1019473
- Merged revisions 3851-3852 from lp:codership/codership-mysql/5.5-23
Revision #3383 Tue 2013-02-26 01:03:21 +0200
- References: MDEV-4179, Bug #1130888, Bug #1019473 Merged revisions 3847-3850 from lp:codership/codership-mysql/5.5-23
Revision #3382 Mon 2013-02-25 23:05:31 +0400
- MDEV-4202: innodb.innodb-autoinc fails due to missing wsrep-specific variable in the result file
Revision #3381 Thu 2013-02-21 10:16:47 +0200
- References MDEV-4185 - thread terminate was blocked for non-wsrep threads
Revision #3380 Sun 2013-02-17 00:22:40 +0200
- References MDEV-4176 Avoiding ha_kill_query for aborts initiated by replicator
Revision #3379 Fri 2013-02-15 15:51:02 +0200
- References MDEV-4136 Fixes to stop wsrep replicator when thread pool scheduler is in use
Revision #3378 Thu 2013-02-07 19:01:19 +0100
- restore changes that were lost in the merge
Revision #3377 Thu 2013-02-07 17:40:32 +0200
- References: MDEV-4142 Merged revision 3846 from lp:codership-mysql/5.5-23
Revision #3376 Wed 2013-02-06 00:46:10 +0200
- wsrep build scripts
Revision #3375 Wed 2013-02-06 00:10:54 +0200
- References Bug #1115708 - merged innodb wsrep changes to xtradb between revisions 3809...3845
Revision #3374 Tue 2013-02-05 22:48:40 +0200
- References Bug #1115708 - merged with wsrep branch, revision 3845 bzr merge -r3840..3845 lp:codership/codership-mysql/5.5-23
Revision #3373 [merge] Tue 2013-02-05 20:19:47 +0200
- References Bug #1115708 - merged with lp:mariadb/5.5 revision 3657
- Revision #3334.1.323 Mon 2013-02-04 15:43:26 +0100
  - MDEV-4127 : Export additional symbols when building RPM, to enable both recompiling mysqli or odbc from sources in addition to drop-in replacement functionality.
  - The case in question is compiling mysqli from sources, that needs client_errors via ER() macro.
  - Previously, we exported it as mysql_client_errors (compatibly to Fedora's style symbol renaming, see MDEV-3842). However, if MariaDB header files are used when compiling mysqli, client_errors needs to be exported with its original name.
- Revision #3334.1.322 Sun 2013-02-03 02:53:57 +0400
  - MDEV-4028 - Converted rdiff files to uniform MDEV-11 - Modifed tests and result files to use explicit column lists in INSERT and SELECT statements
- Revision #3334.1.321 Wed 2013-01-30 17:25:02 +0100
  - MDEV-4113: Assertion (group->connection_count > 0) fails with Percona server in replication test.
  - Assertion happens in replication thread during THD destruction, when thread calls my_sync(), which in turn calls thd_wait_begin() callback. Connection count can be 0, because the counter was decremented before THD destructor. This assertion currently reproducible only in Percona server and not in MariaDB, due to differences in replication code.
  - Fixed by moving code to decrement connection counter after the THD destructor.
- Revision #3334.1.320 Tue 2013-01-29 12:27:31 +0100
  - more changes for fedora18
- Revision #3334.1.319 Tue 2013-01-29 10:46:05 +0100
  - fix 'compat' rpm for fedora18
- Revision #3334.1.318 Mon 2013-01-28 17:24:50 +0100
  - fix embedded build with for cmake 2.6.2 (older cmake could not handle IF(NOT MATCHES)
- Revision #3334.1.317 Mon 2013-01-28 15:13:39 +0200
  - Fix for MDEV-3948, and backport of the following collection of fixes and backports from MariaDB 10.0.
  - The bug in MDEV-3948 was an instance of the problem fixed by Sergey's patch in 10.0 - namely that the range optimizer could change table->[read | write]_set, and not restore it.
```
revno: 3471
committer: Sergey Petrunya <[email protected]>
branch nick: 10.0-serg-fix-imerge
timestamp: Sat 2012-11-03 12:24:36 +0400
message:
  - MDEV-3817: Wrong result with index_merge+index_merge_intersection, InnoDB table, join, AND and OR conditions
  Reconcile the fixes from:
  -
  - [email protected]
  - Fix for BUG#12698916 - "JOIN QUERY GIVES WRONG RESULT AT 2ND EXEC. OR
  - AFTER FLUSH TABLES [-INT VS NULL]"
  -
  - [email protected]
  - Fix for BUG#12912171 - ASSERTION FAILED: QUICK->HEAD->READ_SET == SAVE_READ_SET
  - and
  -
  and related fixes from: BUG#1006164, MDEV-376:
  .
  Now, ROR-merged QUICK_RANGE_SELECT objects make no assumptions about the values
  of table->read_set and table->write_set.
  Each QUICK_ROR_SELECT has (and had before) its own column bitmap, but now, all 
  QUICK_ROR_SELECT's functions that care: reset(), init_ror_merged_scan(), and 
  get_next()  will set table->read_set when invoked and restore it back to what 
  it was before the call before they return.
  .
  This allows to avoid the mess when somebody else modifies table->read_set for 
  some reason.
```
- Revision #3334.1.316 [merge] Mon 2013-01-28 13:36:05 +0100
  - 5.3 merge
  - Revision #2502.567.65 [merge] Mon 2013-01-28 09:12:23 +0100
    - 5.2 merge
    - Revision #2502.566.42 Mon 2013-01-28 09:10:01 +0100
      - compilation error with -Wuninitialized -Werror
    - Revision #2502.566.41 [merge] Fri 2013-01-25 17:22:21 +0100
      - 5.1 merge
      - Revision #2502.565.29 Fri 2013-01-25 14:29:46 +0100
        MDEV-729 Bug #998028 - Server crashes on normal shutdown in closefrm after executing a query from MyISAM table
        don't write a key value into the record buffer - a key length can be larger then the record length.
      - Revision #2502.565.28 Fri 2013-01-25 12:26:35 +0100
        MDEV-759 Bug #998340 - Valgrind complains on simple selects containing expression DAY(FROM_UNIXTIME(-1))
        check item->null_value before using the result of item->val_int()
  - Revision #2502.567.64 Sat 2013-01-26 22:33:18 +0100
    - MDEV-3875 Wrong result (missing row) on a DISTINCT query with the same subquery in the SELECT list and GROUP BY
    - fix remove_dup_with_hash_index() and remove_dup_with_compare() to take NULLs into account
  - Revision #2502.567.63 Fri 2013-01-25 16:56:57 +0200
    - The problem was that expression with field after transformation (on the first execution) reached by fix_fields() (via reference) before row which it belongs to (on the second execution) and fix_field for row did not follow usual protocol for Items with argument (first check that the item fixed then call fix_fields).
    - Item_row::fix_field fixed.
- Revision #3334.1.315 Mon 2013-01-28 13:49:14 +0200
  - MDEV-4091: Dynamic columns C functions should be included in libmysqlclient
- Revision #3334.1.314 [merge] Sat 2013-01-26 22:23:27 +0100
  - Merge MDEV-3842, MDEV-3923, MDEV-3971
  - Revision #3334.31.4 Fri 2013-01-25 23:34:46 +0100
    - fix embedded
  - Revision #3334.31.3 Fri 2013-01-25 18:59:30 +0100
    - Fix embedded build
  - Revision #3334.31.2 Fri 2013-01-25 17:26:10 +0100
    - MDEV-3842, MDEV-3923 :
    - Miscellaneous workarounds for drop-in compatibility problems with Linux distributions, arounf versioning of the MySQL 5.5 client shared library. There seems to be 3 different ways major distributions handle versioning
      1. Fedora (also Mageia, and likely other Redhat descendants) way old, 5.1 API functions are given version libmysqlclient_16 new API functions (client plugins, mysql_stmt_next ) are given version libmysqlclient_18 some extra functions beyond API are exported. some functions are renamed.
      2. Debian Wheezy way all functions are given libmysqlclient_18 version
      3. Ubuntu way (or MySQL/MariaDB download packages) no versioning
    - UIp to this fix, MariaDB distributions did not have any versioning in the libraries, this rendered client library incompatible to distributions thus exchanging distribution's libmysqlclient.so.18.0.0 with MariaDB's did not work nicely (anywhere but on Ubuntu)
    - THE FIX is to build libraries the same way as distributions do it - when building RPMs, use same version script as Fedora does, Make sure to export extra-symbols, the same as Fedora exports. - when building DEBs, use the same version script as Debian Wheezy - do not use version scripts otherwise
    - Also, makes sure that extensions of MySQL APIs (asynchronous client functionality) is exported by the shared libraries.
  - Revision #3334.31.1 Fri 2013-01-25 16:50:14 +0100
    - MDEV-3971 : problems installing MariaDB packages (conflicts with mysql-libs-5.5) FIx : make "shared" RPM obsolete/provide mysql-libs
- Revision #3334.1.313 [merge] Sat 2013-01-26 01:59:27 +0200
  - Automatic merge
  - Revision #3334.30.1 Fri 2013-01-25 21:40:42 +0200
    - Fixed MDEV-3890: Server crash inserting record on a temporary table after truncating it The problem was that a temporary table was re-created as a non-temporary table.
- Revision #3334.1.312 [merge] Fri 2013-01-25 11:24:42 +0100
  - 5.3 merge
  - Revision #2502.567.62 [merge] Fri 2013-01-25 10:20:45 +0100
    - 5.2 merge
    - Revision #2502.566.40 Fri 2013-01-25 10:19:35 +0100
      - MDEV-4040 Replace deprecated SET OPTION syntax in mysqldump
      - mysqldump.c: s/SET OPTION/SET/ (OPTION was, hm, optional since 3.21, so there's no need to use SET OPTION even in the old compatibility modes)
    - Revision #2502.566.39 Fri 2013-01-25 09:41:26 +0100
      - MDEV-3909 remote user enumeration
      - instead of returning Access denied on the incorrect user name, emulate the complete failed logic procedure, possibly with the change plugin packet.
    - Revision #2502.566.38 Fri 2013-01-25 00:20:53 +0100
      - report "using password: YES/NO" correctly for the COM_CHANGE_USER failures
    - Revision #2502.566.37 Fri 2013-01-25 00:17:39 +0100
      - MDEV-3915 COM_CHANGE_USER allows fast password brute-forcing
      - allow only three failed change_user per connection. successful change_user do NOT reset the counter
- Revision #3334.1.311 [merge] Wed 2013-01-23 15:18:05 -0800
  - Merge 5.3->5.5
  - Revision #2502.567.61 [merge] Mon 2013-01-21 21:29:19 -0800
    - Merge 5.2->5.3
    - Revision #2502.566.36 [merge] Mon 2013-01-21 15:23:40 -0800
      - Merge 5.1->5.2
      - Revision #2502.565.27 [merge] Mon 2013-01-21 13:48:34 -0800
        Merge.
        Revision #2502.571.1 Mon 2013-01-21 11:47:45 -0800
        Fixed bug MDEV-4063 (bug #56927). This bug could result in returning 0 for the expressions of the form <aggregate_function>(distinct field) when the system variable max_heap_table_size was set to a small enough number. It happened because the method Unique::walk() did not support the case when more than one pass was needed to merge the trees of distinct values saved in an external file.
        Backported a fix in grant_lowercase.test from mariadb 5.5.
      - Revision #2502.565.26 Mon 2013-01-21 10:52:39 +0100
        MDEV-4029 SELECT on information_schema using a subquery locks up the information_schema table due to incorrect mutexes handling
        Early evaluation of subqueries in the WHERE conditions on I_S.*_STATUS tables, otherwise the subquery on this same table will try to acquire LOCK_status twice.
    - Revision #2502.566.35 Sat 2013-01-19 23:40:53 -0800
      - Corrected the test case for bug MDEV-3938.
    - Revision #2502.566.34 Wed 2013-01-16 11:17:58 -0800
      - Corrected the fix for bug MDEV-3938.
    - Revision #2502.566.33 Tue 2013-01-15 16:46:27 -0800
      - Fixed bug MDEV-3938. The original patch with the implementation of virtual columns did not support INSERT DELAYED into tables with virtual columns. This patch fixes the problem.
  - Revision #2502.567.60 Wed 2013-01-16 21:07:26 +0200
    - MDEV-4056 fix.
    - The problem was that maybe_null of Item_row and its componetes was unsynced after update_used_tables() (and so pushed_cond_guards was not initialized but then requested).
    - Fix updates Item_row::maybe_null on update_used_tables().
  - Revision #2502.567.59 Thu 2013-01-17 16:08:05 +0200
    - MDEV-3900 Optimizer difference between MySQL and MariaDB with stored functions in WHERE clause of UPDATE or DELETE statements
    - Analysis The reason for the less efficient plan was result of a prior design decision - to limit the eveluation of constant expressions during optimization to only non-expensive ones. With this approach all stored procedures were considered expensive, and were not evaluated during optimization. As a result, SPs didn't participate in range optimization, which resulted in a plan with table scan rather than index range scan.
    - Solution Instead of considering all SPs expensive, consider expensive only those SPs that are non-deterministic. If an SP is deterministic, the optimizer will checj if it is constant, and may eventually evaluate it during optimization.
  - Revision #2502.567.58 Thu 2013-01-17 13:53:15 +0200
    - backport of: Don't reset maybe_null in update_used_tables(); This breaks ROLLUP This fixed failing test in group_by.test
  - Revision #2502.567.57 Wed 2013-01-16 15:11:13 +0200
    - MDEV-3988 fix.
    - Subquery turned into constant too late to be excluded from grouping list so test for constant added to the create_temp_table().
  - Revision #2502.567.56 Fri 2013-01-11 20:26:34 -0800
    - Fixed bug MDEV-4025. The bug could lead to a wrong estimate of the number of expected rows in the output of the EXPLAIN commands for queries with GROUP BY. This could be observed in the test case for LP bug 934348.
  - Revision #2502.567.55 Fri 2013-01-11 12:44:21 +0100
    - MDEV-4020 : Make sure strmov symbol is exported by client library on Linux (even if the server and libraries itself use stpcpy instead of it)
    - It is a workaround that allows myodbc built by certain distributions' (CentOS,Fedora) to peacefully coexist with mariadb client libraries. The problem is that MyODBC in these distros needs strmov() to be exported by mysql client shared library, or else myodbc fails to load.
- Revision #3334.1.310 Wed 2013-01-23 14:58:05 +0100
  - remove one particularly stupid test
- Revision #3334.1.309 Mon 2013-01-21 12:20:54 +0100
  - MDEV-4069 thd_wait_end does not called in some cases in buf_page_read_low in XtraDB engine
- Revision #3334.1.308 Tue 2013-01-22 13:29:59 +0200
  - Fixed typo in the function name. test suite added.
- Revision #3334.1.307 Mon 2013-01-21 14:34:39 +0200
  - MDEV-3873: fixed functions absend in 5.3.
- Revision #3334.1.306 Sun 2013-01-20 21:43:11 +0100
  - fix a strict aliasing warning - remove a meaningless cast.
- Revision #3334.1.305 Sun 2013-01-20 21:42:01 +0100
  - MDEV-3952 Incompatible change in MariaDB-5.5.28a-client rpm adds mytop when not in MariaDB-5.5.23-client (CentOS 5)
  - Same as for deb: don't add mytop to the client rpm.
- Revision #3334.1.304 Sun 2013-01-20 14:06:33 +0100
  - MDEV-3934 Assertion `((keypart_map+1) & keypart_map) == 0' failed in _mi_pack_key with an index on a POINT column
  - sel_arg_range_seq_next(): set keypart map also for GEOM_FLAG keys
- Revision #3334.1.303 Sun 2013-01-20 00:46:51 +0100
  - MDEV-4029 SELECT on information_schema using a subquery locks up the information_schema table due to incorrect mutexes handling
  - Early evaluation of subqueries in the WHERE conditions on I_S.*_STATUS tables, otherwise the subquery on this same table will try to acquire LOCK_status twice.
- Revision #3334.1.302 Sat 2013-01-19 14:03:33 +0100
  - MDEV-3832 MariaDB conflicts with packages filesystem-3.1-2.fc18.i686 and jre-1.7.0_09-fcs.i586 on Fedora 18
  - fix the rpm packaging to work on Fedora18. Two problems: * conflicts on common directories with other packages. * more auto-generated requirements for mariadb-test.rpm
- Revision #3334.1.301 Fri 2013-01-18 19:10:20 +0100
  - MDEV-633 Bug #1024058 - mysqld XA crash in replication slave
  - initialize cache_mngr and write the Xid into binlog even if binlog is disabled with SQL_LOG_BIN=0 or no --log-slave-updates in the slave thread
- Revision #3334.1.300 Fri 2013-01-18 19:07:59 +0100
  - simplify THD::binlog_setup_trx_data() usage
- Revision #3334.1.299 Fri 2013-01-18 19:04:51 +0100
  - MDEV-3908 crash in multi-table delete and mdl
  - Add a test case. The fix comes with MySQL bug#15948123: SERVER WORKS INCORRECT WITH LONG TABLE ALIASES
- Revision #3334.1.298 Fri 2013-01-18 19:04:23 +0100
  - MDEV-4065 thd_kill_statement service
- Revision #3334.1.297 Fri 2013-01-18 18:49:07 +0100
  - Fix Windows installers' bootstrapper scripts , after mysql_performance_tables.sql was split off mysql_system_tables.sql
- Revision #3334.1.296 Thu 2013-01-17 02:27:10 +0200
  - Don't reset maybe_null in update_used_tables(); This breaks ROLLUP This fixed failing test in group_by.test
- Revision #3334.1.295 Thu 2013-01-17 01:08:49 +0200
  - Fixed compiler warning
- Revision #3334.1.294 [merge] Wed 2013-01-16 11:13:08 +0100
  - xtradb merge. Percona-Server-5.5.28-rel29.3
  - Revision #0.12.59 Tue 2013-01-15 22:22:49 +0100
    - Percona-Server-5.5.28-rel29.3
- Revision #3334.1.293 Tue 2013-01-15 19:16:29 +0100
  - Test case and a different fix for MySQL bug#14485479
- Revision #3334.1.292 Tue 2013-01-15 19:16:18 +0100
  - small cleanups
- Revision #3334.1.291 Tue 2013-01-15 19:15:51 +0100
  - backport a test case for a 5.5 bug fix from the 5.6 tree
- Revision #3334.1.290 [merge] Tue 2013-01-15 19:13:32 +0100
  - mysql-5.5.29 merge
  - Revision #3077.166.19 [merge] Tue 2012-09-11 17:42:22 +0300
    - merge
  - Revision #3077.166.18 Mon 2012-08-27 15:30:58 +0300
    - Bug #13548161: MYSQLD_SAFE IMPROVEMENTS FOR 5.5 ALLWAYS SETS PLUGIN_DIR TO DEFAULT IGNOR
    - The test in mysqld_safe for the presence of the --plugin-dir and assigning a default value to it were performed before the actual argument parsing. This is wrong, as PLUGIN_DIR mysqld_safe code also uses MY_BASEDIR_VERSION to look for version specific plugin directory if present. Fixed by moving the PLUGIN_DIR logic after the parse_arguments() call.
  - Revision #3077.166.17 Fri 2012-08-24 15:01:31 +0300
    - Bug #14181049: MYSQL_INSTALL_DB.PL CREATES EMPTY SYSTEM TABLES FOR MYSQL
    - The script is different from what's used on unixes. It was not playing the table insertion script (mysql_system_tables_data.sql), although it was checking for the presence of this script. Fixed by re-enabling the lookup for this file and replaying it at bootstrap time. Note that on the Unixes "SELECT @@hostname" does return a fully qualified name, whereas on Windows it returns only a hostname. So by default we're filtering records in the mysql.user table until we ensure this is fixed.
- Revision #3334.1.289 Tue 2013-01-15 19:08:49 +0100
  - update debian patch to apply
- Revision #3334.1.288 [merge] Tue 2013-01-15 19:07:46 +0100
  - 5.3 merge
  - Revision #2502.567.54 [merge] Thu 2013-01-10 15:40:21 +0100
    - 5.2->5.3 merge
    - Revision #2502.566.32 [merge] Thu 2013-01-10 13:54:04 +0100
      - 5.1 merge
      - Revision #2502.565.25 [merge] Wed 2013-01-09 23:51:51 +0100
        mysql-5.1.67 merge
      - Revision #2502.565.24 Tue 2012-12-04 17:08:02 +0100
        proactive s/strmov/strnmov/ in sql_acl.cc and related test cases
    - Revision #2502.566.31 [merge] Fri 2012-12-21 15:19:08 +0100
      - merge
      - Revision #2502.565.23 Fri 2012-12-21 15:17:26 +0100
        Support VS2012. Exclude compiler-defined symbols from being exported by mysqld.exe
    - Revision #2502.566.30 [merge] Fri 2012-12-21 14:04:25 +0100
      - merge
      - Revision #2502.565.22 Thu 2012-12-06 00:37:06 +0100
        MDEV-3918: myisamchk bogus error for files larger than 4GB.
        The failure is caused by failing stat() call . C Runtime function stat() uses old struct with 32bit st_size member, and since Visual Studio 2010 , it returns an error on st_size overflow (i.e on files larger than 4GB)
        Fix replaces stat() by my_stat(), the later is backed by 64bit-able stat64().
    - Revision #2502.566.29 Tue 2012-12-11 09:50:48 +0100
      - one-byte overflow with old passwords
    - Revision #2502.566.28 Mon 2012-11-26 13:33:24 +0100
      - Fix broken feedback plugin after MDEV-712.
      - Link feedback plugin with yassl libraries, if with-ssl=bundled is used, since mysqld does not export SSL symbols anymore.
    - Revision #2502.566.27 Fri 2012-11-23 13:50:46 +0100
      - MDEV-712 - Bug #1024239 - Mysqlclient exports the same symbols as openssl
      - Compile yassl and taocrypt using -fvisibility=hidden, when possible. This prevent symbols from being exported.
    - Revision #2502.566.26 [merge] Thu 2012-11-22 18:29:53 +0100
      - merge 5.1
      - Revision #2502.565.21 Thu 2012-11-22 18:27:02 +0100
        Feedback plugin now recognizes Windows 8 / Windows Server 2012.
  - Revision #2502.567.53 Tue 2013-01-08 21:23:03 +0100
    - MDEV-3942 FROM_DAYS(<timestamp column>) returns different result in MariaDB comparing to MySQL: NULL vs 0000-00-00
    - fixed a regression, introduced while fixing MDEV-456
  - Revision #2502.567.52 Fri 2012-12-28 14:41:46 +0200
    - MDEV-3873 & MDEV-3876 & MDEV-3912 : Wrong result (extra rows) with ALL subquery from a MERGE view.
    - The problem was in the lost ability to be null for the table of a left join if it is a view/derived table.
    - It hapenned because setup_table_map(), was called earlier then we merged the view or derived.
    - Fixed by propagating new maybe_null flag during Item::update_used_tables().
    - Change in join_outer.test and join_outer_jcl6.test appeared because IS NULL reported no used tables (i.e. constant) for argument which could not be NULL and new maybe_null flag was propagated for IS NULL argument (Item_field) because table the Item_field belonged to changed its maybe_null status.
  - Revision #2502.567.51 Wed 2012-12-19 15:56:57 +0200
    - MDEV-3928: Assertion `example' failed in Item_cache::is_expensive_processor with a 2-level IN subquery
    - Analysis: The following call stack shows that it is possible to set Item_cache::value_cached, and the relevant value without setting Item_cache::example.
    - #0 Item_cache_temporal::store_packed at item.cc:8395 #1 get_datetime_value at item_cmpfunc.cc:915 #2 resolve_const_item at item.cc:7987 #3 propagate_cond_constants at sql_select.cc:12264 #4 propagate_cond_constants at sql_select.cc:12227 #5 optimize_cond at sql_select.cc:13026 #6 JOIN::optimize at sql_select.cc:1016 #7 st_select_lex::optimize_unflattened_subqueries at sql_lex.cc:3161 #8 JOIN::optimize_unflattened_subqueries at opt_subselect.cc:4880 #9 JOIN::optimize at sql_select.cc:1554
    - The fix is to set Item_cache_temporal::example even when the value is set directly by Item_cache_temporal::store_packed. This makes the Item_cache_temporal object consistent.
  - Revision #2502.567.50 Wed 2012-12-05 21:06:00 +0200
    - MDEV-3914 fix.
    - Fixed algorithm of detecting of first real table in view/subquery-in-the-FROM-clase.
  - Revision #2502.567.49 Fri 2012-11-23 13:11:31 +0100
    - bump the version to 5.3.11
  - Revision #2502.567.48 [merge] Thu 2012-11-22 10:30:39 -0800
    - Merge
    - Revision #2502.570.1 Wed 2012-11-21 21:55:04 -0800
      - Fixed LP bug #1002146 (bug MDEV-645). If the setting of system variables does not allow to use join buffer for a join query with GROUP BY <f1,...> / ORDER BY <f1,...> then filesort is not needed if the first joined table is scanned in the order compatible with order specified by the list <f1,...>.
- Revision #3334.1.287 Tue 2013-01-15 17:46:46 +0100
  - remove thd_mark_as_hard_kill() (because it's conceptually wrong. only the user can decide whether the kill is allowed to leave tables in the inconsistent state, storage engine has no say in that)
- Revision #3334.1.286 Tue 2013-01-15 14:33:08 +0200
  - Fix for bug MDEV-3992, second attempt
  - The previous fix for MDEV-3992 was incomplete, because it still computed incorrectly the number of keyparts of the extended secondary key in the case when columns of the PK participate in the secondary key.
  - This patch by Monty corrects the above problem.
- Revision #3334.1.285 Mon 2013-01-14 15:05:05 +0200
  - Fix for bug MDEV-3992
  - Analysis: The crash is a result of incorrect analysis of whether a secondary key can be extended with a primary in order to compute ORDER BY. The analysis is done in test_if_order_by_key(). This function doesn't take into account that the primary key may in fact index the same columns as the secondary key. For the test query test_if_order_by_key says that there is an extended key with total 2 keyparts. At the same time, the condition if (pkinfo->key_part[i].field->key_start.is_set(nr)) in test_if_cheaper_oredring() becomes true for (i == 0), which results in an invalid access to rec_per_key[-1].
  - Solution: The best solution would be to reuse KEY::ext_key_parts that is already computed by open_binary_frm(), however after detailed analysis the conclusion is that the change would be too intrusive for a GA release. The solution for 5.5 is to add a guard for the case when the 0-th key part is considered, and to assume that all keys will be scanned in this case.
- Revision #3334.1.284 Fri 2013-01-11 02:03:43 +0200
  - Buildbot fixes and cleanups: - Added --verbose to BUILD scripts to get make to write out compile commands. - Detect if AM_EXTRA_MAKEFLAGS=VERBOSE=1 was used with build scripts. - Don't write warnings about replication variables when doing bootstrap. - Fixed that mysql_cond_wait() and mysql_cond_timedwait() will report original source file in case of errors. - Ignore some compiler warnings
- Revision #3334.1.283 Fri 2013-01-11 01:31:50 +0200
  - Fixed crashing bug in GROUP_CONCAT with ROLLUP Fixed MDEV-4002: Server crash or valgrind errors in Item_func_group_concat::setup and Item_func_group_concat::add
- Revision #3334.1.282 Fri 2013-01-11 00:53:07 +0200
  - Fixed problem with failing mysql_upgrade when proc table was not correct. Moved out creation of performance schema tables from mysql_system_tables.sql as the performance_tables creation scripts needs a working mysql.proc to work.
- Revision #3334.1.281 Fri 2013-01-11 00:35:33 +0200
  - Fixed MDEV-4013: Password length in replication setup Give error for wrong parameters to CHANGE MASTER Extend MASTER_PASSWORD and MASTER_HOST lengths
- Revision #3334.1.280 Fri 2013-01-11 00:22:14 +0200
  - Fixed some race conditons and bugs related to killed queries KILL now breaks locks inside InnoDB Fixed possible deadlock when running INNODB STATUS Added ha_kill_query() and kill_query() to send kill signal to all storage engines Added reset_killed() to ensure we don't reset killed state while awake() is getting called
- Revision #3334.1.279 Thu 2013-01-10 23:40:18 +0200
  - Fix for MDEV-4009: main.delayed sporadically fails with "query 'REPLACE DELAYED t1 VALUES (5)' failed: 1317: Query execution was interrupted" - Fixed broadcast without a proper mutex - Don't break existing locks if we are just testing if we can get the lock
- Revision #3334.1.278 Wed 2013-01-09 17:30:20 +0100
  - MDEV-3846 REFRESH_CHECKPOINT and REFRESH_TABLE_STATS tokens share the same value
- Revision #3334.1.277 Wed 2013-01-09 17:29:51 +0100
  - MDEV-3985 crash: uninstall soname 'a'
- Revision #3334.1.276 Tue 2013-01-08 21:23:40 +0100
  - MDEV-3883 Show global status not in order
- Revision #3334.1.275 Tue 2013-01-08 21:21:28 +0100
  - MDEV-3987 uninitialized read in Item_cond::fix_fields leads to crash: select .. where .. in ( select ... )
  - change Item_func_group_concat to use max_length according to the expected semantics
- Revision #3334.1.274 Mon 2013-01-07 20:21:05 +0100
  - non-functional cleanup, clarifying CONVERT_IF_BIGGER_TO_BLOB
- Revision #3334.1.273 Sat 2013-01-05 23:52:25 +0100
  - Remove timed mutexes in XtraDB - obsolete feature that does not link on Windows, if plugin is build dynamically It was already removed from innobase in the past.
- Revision #3334.1.272 Tue 2013-01-01 15:33:25 +0100
  - MDEV-3993 - add MSI installer option to set character-set-server=utf8
- Revision #3334.1.271 [merge] Mon 2012-12-31 01:39:26 +0400
  - MDEV-3990: engine tests went out of sync with current MariaDB code Reasons: - as of 5.5.27, YEAR(2) is deprecated, hence the new warning; - MDEV-553 - different error code/message on out-of-range autoincrement; - INSERT IGNORE now produces a warning if a duplicate was encountered
  - Revision #3334.29.1 Fri 2012-12-28 17:02:33 +0400
    - storage_engine tests and upstream engines/* suites went out of sync with current MariaDB code. Reasons: - as of 5.5.27, YEAR(2) is deprecated, hence the new warning; - MDEV-553 - different error code/message on out-of-range autoincrement; - INSERT IGNORE now produces a warning if a duplicate was encountered (change pushed along with MDEV-553)
- Revision #3334.1.270 Thu 2012-12-06 17:30:22 +0100
  - typo
- Revision #3334.1.269 Thu 2012-12-06 16:34:02 +0100
  - if the debian package name for 5.5.28 is 5.5.28-mariadb1wheezy then for 5.5.28a it should be 5.5.28a-mariadb1wheezy not 5.5.28-mariadb-a1wheezy
- Revision #3334.1.268 Fri 2012-12-21 11:18:29 +0200
  - MDEV-3902 Assertion `record_length == m_record_length' failed at Filesort_buffer::alloc_sort_buffer
  - This bug is a duplicate of MDEV-3899 so adding a test case only.
- Revision #3334.1.267 Fri 2012-12-21 00:12:37 +0100
  - MDEV-3945 - do not hold LOCK_thread_count when freeing THD.
  - The patch decreases the duration of LOCK_thread_count, so it is not hold during THD destructor and freeing memory. This mutex now only protects the integrity of threads list, when removing THD from it, and thread_count variable.
  - The add_to_status() function that updates global status during client disconnect, is now correctly protected by the LOCK_status mutex.
  - Benchmark : in a "non-persistent" sysbench test (oltp_ro with reconnect after each query), ~ 25% more connects/disconnects were measured
- Revision #3334.1.266 Thu 2012-12-20 22:38:40 +0200
  - MDEV-3899 Valgrind warnings (blocks are definitely lost) in filesort on IN subquery with SUM and DISTINCT
  - Analysys: In the beginning of JOIN::cleanup there is code that is supposed to free all filesort buffers. The code assumes that the table being sorted is the first non-constant table. To get this table it calls: first_top_level_tab(this, WITHOUT_CONST_TABLES)
  - However, first_top_level_tab() instead returned the wrong table - the first one in the plan, instead of the first non-constant table. There is no other place outside filesort() where sort buffers may be freed. As a result, the sort buffer was not freed, and there was a memory leak.
  - Solution: Change first_top_level_tab(), to test for WITH_CONST_TABLES instead of WITHOUT_CONST_TABLES.
- Revision #3334.1.265 Wed 2012-12-19 21:58:05 +0200
  - Fixed some compiler warnings
- Revision #3334.1.264 Tue 2012-12-18 12:44:15 +0200
  - MDEV-3818: Query against view over IS tables worse than equivalent query without view
  - Fixed the test to be lower-case because it fails on windows with mixed case.
- Revision #3334.1.263 Mon 2012-12-17 22:34:56 +0200
  - Fixed the CREATE TABLE IF EXIST generates warnings instead of errors
- Revision #3334.1.262 Mon 2012-12-17 15:23:58 +0200
  - MDEV-3818: Query against view over IS tables worse than equivalent query without view
  - Analysis: The reason for the suboptimal plan when querying IS tables through a view was that the view columns that participate in an equality are wrapped by an Item_direct_view_ref and were not recognized as being direct column references.
  - Solution: Use the original Item_field objects via the real_item() method.
- Revision #3334.1.261 Sun 2012-12-16 20:51:48 +0200
  - Remember original table row pack type for ALTER TABLE if table is not copied.
- Revision #3334.1.260 Sun 2012-12-16 20:49:57 +0200
  - Removed lock wait timeout warning when using CREATE TABLE IF EXISTS
- Revision #3334.1.259 Sun 2012-12-16 16:13:17 +0200
  - Implemented MDEV-3941: CREATE TABLE xxx IF NOT EXISTS should not block if table exists. - Added option to check_if_table_exists() to quickly check if table exists (either SHARE or .FRM) - Extended lock_table_names() to not wait for meta data locks if CREATE IF NOT EXISTS is used.
- Revision #3334.1.258 [merge] Sun 2012-12-16 12:04:26 +0200
  - Automatic merge
  - Revision #3334.28.1 Fri 2012-12-14 20:21:50 +0200
    - Removed extra '+' from some lines (remains of old merge)
- Revision #3334.1.257 Mon 2012-11-26 21:22:44 +0200
  - Fix of MDEV-3874: Server crashes in Item_field::print on a SELECT from a MERGE view with materialization+semijoin, subquery, ORDER BY.
  - The problem was that in debugging binaries it try to print item to assign human readable name to the item. But subquery item was already freed (join_free/cleanup with full cleanup) so Item_field refers to temporary table which memory had been already freed.
- Revision #3334.1.256 Tue 2012-12-04 16:06:07 -0800
  - Fixed bug MDEV-3888. When inserting a record with update on duplicate keys the server calls the ha_index_read_idx_map handler function to look for the record that violates unique key constraints. The third parameter of this call should mark only the base components of the index where the server is searched for the record. Possible hidden components of the primary key are to be unmarked.
- Revision #3334.1.255 Sat 2012-12-01 18:01:59 +0100
  - fix openssl_1 test
- Revision #3334.1.254 Sat 2012-12-01 16:33:22 +0100
  - MDEV-3901: Wrong SSL error messages
  - Fixed typo (missing comma)
Revision #3372 Tue 2013-02-05 19:20:47 +0200
- fixes for the merge with codership-mysql, revision 3839
Revision #3371 Tue 2013-02-05 17:54:42 +0200
- merged with codership-mysql up to revision 3839 bzr merge -r3810..3839 lp:codership-mysql/5.5
Revision #3370 Tue 2013-02-05 16:54:50 +0200
- remerging wsrep files from lp:codership-mysql
Revision #3369 Tue 2013-02-05 16:49:51 +0200
- remerging wsrep files from lp:codership-mysql
Revision #3368 Tue 2013-02-05 15:48:54 +0200
- re-merging wsrep files from lp:codership-mysql
Revision #3367 Mon 2013-02-04 00:30:15 +0400
- MDEV-508 - wsrep revno can be either a number or XXXX, test should be able to handle both
Revision #3366 Sun 2013-02-03 04:03:08 +0400
- MDEV-508 (Wrong MTR result files in MariaDB-Galera)

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.

MariaDB Galera 5.5.29 Changelog

Comments

Products

Services

Pricing

Resources

About Us

Download MariaDB