MariaDB 5.2.11 Changelog
Download |Release Notes |Changelog |Overview of 5.2
Release date: 2 Apr 2012
For the highlights of this release, see therelease 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 #3130 [merge] Fri 2012-03-30 16:12:21 +0200
merge
Revision #2643.127.86 Fri 2012-03-30 16:09:57 +0200
MDEV-205 don't install libevent headers
Revision #3129 [merge] Fri 2012-03-30 13:51:16 +0300
Automatic merge
Revision #2643.127.85 Fri 2012-03-30 13:42:52 +0300
Fixed Bug #967914 "CHECK TABLE persistently reports table corruption after removing Aria logs"
Fixed that repair removes the 'table is moved' mark.
Revision #3128 [merge] Thu 2012-03-29 21:15:30 +0200
merge
Revision #2643.127.84 Thu 2012-03-29 18:06:08 +0200
fix the test case for windows: replace_result /
Revision #2643.127.83 Thu 2012-03-29 16:36:06 +0200
make the code compile again
Revision #3127 [merge] Wed 2012-03-28 13:49:07 +0300
Merge with 5.1
Revision #2643.127.82 Wed 2012-03-28 13:22:21 +0300
Fixed Bug #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 #3126 [merge] Wed 2012-03-21 18:30:34 +0100
merge
Revision #2643.127.81 Wed 2012-03-21 18:22:02 +0100
Bug #933959 Assertion `0' failed in net_end_statement(THD*) on concurrent SELECT FROM I_S.INNODB_SYS_INDEXES and ALTER TABLE
Workaround: report a generic error if an I_S plugin failed silently.
Revision #2643.127.80 Thu 2012-03-15 15:06:06 +0100
Fix access to uninitialized variable in innodb error message in case WriteFile() fails.
Revision #2643.127.79 Wed 2012-03-14 21:16:24 +0100
restore my_safe_printf_stderr for "crash-safe sigsegv handler"
use vsnprintf()
use write() on windows, not WriteFile or fwrite()
localtime_r is still a problem
Revision #3125 Wed 2012-03-14 12:09:03 +0200
test suite for Bug #694450
Revision #3124 [merge] Mon 2012-03-12 12:15:55 +0100
merge
Revision #2643.127.78 Mon 2012-03-12 11:31:40 +0100
Bug #952714: Fix formatting of the crash messages in signal/exception handler
Revision #3123 Mon 2012-03-12 12:14:04 +0100
Bug #952607: Do not show MySQL services preinstalled by Dell in the upgrade wizard
Revision #3122 Fri 2012-03-09 15:37:16 -0800
Fixed Bug #930814.
This bug was introduced into mariadb 5.2 in the December 2010 with the patch that added a new engine property: the ability to support virtual columns.
As a result of this bug the information from frm files for tables that contained virtual columns did not appear in the information schema tables.
Revision #3121 Fri 2012-03-09 14:28:02 +0200
Added test case for Bug #905782 "Assertion
pageno < ((1ULL)
<<` 40)' failed at ma_pagecache.c:3438: pagecache_read or table corruption on INSERT into a ucs2 table"The orignal bug has been fixed earlier
Revision #3120 Fri 2012-03-09 14:06:17 +0200
Added ucs2 test moved from maria3.test. (MDEV-167)
Revision #3119 Thu 2012-03-08 22:33:01 -0800
Fixed Bug #884175.
If in the where clause of the a query some comparison conditions on the field under a MIN/MAX aggregate function contained constants whose sizes exceeded the size of the field then the query could return a wrong result when the optimizer had chosen to apply the MIN/MAX optimization.
With such conditions the MIN/MAX optimization still could be applied, yet it would require a more thorough analysis of the keys built to find the value of MIN/MAX aggregate functions with index look-ups.
The current patch just prohibits using the MIN/MAX optimization in this situation.
Revision #3118 [merge] Tue 2012-03-06 01:48:38 +0100
merge
Revision #3116.1.1 Tue 2012-03-06 01:46:32 +0100
Bug #947631: Uninstall wipes HeidiSQL settings, even if HeidiSQL is installed prior to MariaDB
Fixed detection of installed HeidiSQL in the machine, prevent installing own copy if HeidiSQL is already installed.
On deinstallation, do not remove settings if official HeidiSQL is detected.
Revision #3117 Thu 2012-03-01 09:27:42 +0200
Return original checksum value inside the test.
Move ucs2 test in separate file (MDEV-167).
Revision #3116 [merge] Tue 2012-02-28 13:50:30 +0200
Automatic merge
Revision #3113.1.1 Tue 2012-02-28 13:39:02 +0200
Fixed Bug #905716 "Assertion `page->size <= share->max_index_block_size'"
The issue was that Aria allowed too long keys to be created (so that the internal buffer was not big enough to hold the whole key).
Key lengths is now limited to HA_MAX_KEY_LENGTH (1000), as for MyISAM.
Fixed failure in "_ma_apply_redo_index: Assertion `new_page_length == 0", as found by buildbot.
Revision #3115 Sat 2012-02-25 17:10:07 -0800
Fixed Bug #939866.
The field key_cache_mem_size of the KEY_CACHE structure must be initialized in the function init_key_cache() and updated in the function resize_key_cache().
Revision #3114 Sat 2012-02-25 09:03:06 +0200
Fix of Bug #938518 (also Bug #791761 and Bug #806955)
Cause of the bug is uninitialized items before evaluation HAVING clasue in case of empty result.
Revision #3113 [merge] Fri 2012-02-24 17:21:44 +0200
Automatic merge
Revision #2643.127.77 Fri 2012-02-24 17:01:47 +0200
Fix for Bug #909635: MariaDB crashes on a select with long varchar and blob fields
Problem was a crash in internal temporary (Maria) files when row length exceeded 65535
Revision #3112 Wed 2012-02-22 00:10:39 -0800
Back-ported the fix and test cases for bugs #59487 and #43368 from the mysql-5.6 code line.
Revision #3111 [merge] Tue 2012-02-21 17:48:15 +0200
Automatic merge with 5.1
Revision #2643.127.76 Tue 2012-02-21 14:17:33 +0200
Fixed suppression expression.
Revision #3110 Tue 2012-02-21 09:35:46 +0200
Fixed wrong test case
Revision #3109 [merge] Tue 2012-02-21 01:55:12 +0200
Merge with 5.1
Revision #2643.127.75 [merge] Tue 2012-02-21 01:51:55 +0200
Automatic merge
Revision #2643.135.1 Tue 2012-02-21 01:44:50 +0200
More general handling of memory loss in dlclose (backported from 5.2)
Fixed supression in mysql-test-run so it also works on windows.
Revision #3108 [merge] Tue 2012-02-21 01:49:14 +0200
Automatic merge
Revision #3106.1.2 Tue 2012-02-21 01:46:51 +0200
Added missing signal values to signal_handler.cc
Revision #3106.1.1 [merge] Mon 2012-02-20 17:58:00 +0200
Merge with 5.1
Revision #3107 [merge] Mon 2012-02-20 18:46:22 +0100
merge
Revision #2643.127.74 Mon 2012-02-20 18:07:38 +0100
Fix compilation on Windows, and various Windows related mistakes introduced by "safe exception patch".
Remove misleading comments suggesting about signal() Windows, the routine here is part of a exception handler, and sig parameter is an exception code.
Revision #2643.127.73 Mon 2012-02-20 17:56:47 +0200
Fixed compiler warnings
Revision #3106 [merge] Mon 2012-02-20 17:49:21 +0200
Merge with MariaDB 5.1 and MySQL 5.1.61
Revision #2643.127.72 [merge] Mon 2012-02-20 16:23:18 +0200
Merge with MYSQL 5.1.61
Fixed README with link to source
Merged InnoDB change to XtraDB
merge] Sat 2012-02-11 16:42:46 +0100
merge
Revision #2643.127.70 Wed 2012-01-25 11:34:43 +0100
mtr runs only "big" tests, if
--big-test
is repeated twice
Revision #2643.127.69 Wed 2012-01-04 20:10:15 +0100
report innodb_file_per_table, innodb_flush_log_at_trx_commit, innodb_flush_method
Revision #3105 Mon 2012-02-20 14:03:44 +0200
Fixed Bug #902654 "MariaDB consistently crashes in collect_tables on Aria checkpoint execution"
This happend when you have more than 1024 open Aria tables during checkpoint.
Revision #3104 Thu 2012-02-16 16:06:49 -0800
Fixed Bug #933117.
The bug was fixed with the code back-ported from the patch for Bug #800184 pushed into mariadb-5.3.
Revision #3103 Sun 2012-02-12 23:02:56 +0100
Use newly released HeidiSQL 7.0 in the MSI installer
Revision #3102 [merge] Sat 2012-02-11 15:05:07 +0100
merge
Revision #3098.1.1 [merge] Sat 2012-02-11 14:57:44 +0100
Fix for MDEV-140, Bug #930145 - broken SSL connectivity for some connectors
Revision #2643.134.3 Sat 2012-02-11 03:25:49 +0100
fixes Bug #930145
A recent change in the server protocol code broke SSL connection for some client libraries.
Protocol documentation (MySQL_Internals_ClientServer_Protocol) says that initial packet sent by client if client wants SSL, consists of client capability flags only (4 bytes or 2 bytes edependent on protocol versionl). Some clients happen to send more in the initial SSL packet (C client, Python connector), while others (Java, .NET) follow the docs and send only client capability flags.
A change that broke Java client was a newly introduced check that frst client packet has 32 or more bytes. This is generally wrong, if client capability flags contains CLIENT_SSL.
Also, fixed the code such that read max client packet size and charset in the first packet prior to SSL handshake. With SSL, clients do not have to send this info, they can only send client flags.
This is now fixed such that max packet size and charset are not read prior to SSL handshake, in case of SSL they are read from the "complete" client authentication packet after SSL initialization.
Revision #3101 Fri 2012-02-03 12:24:55 +0200
Fixed DELETE issues of view over view over table.
Revision #3100 Fri 2012-02-03 10:31:30 +0200
Added 5.2 test result delimiter
Revision #3099 Fri 2012-02-03 10:28:23 +0200
Fix check of view updatability in case of underlying view changes its updatability.
For single table update/insert added deep check of single tables (single_table_updatable()).
For multi-table view insert added additional check of target table (check_view_single_update).
Multi-update was correct.
Test suite for all cases added.
Revision #3098 Mon 2012-01-23 11:43:28 +0100
MDEV-106 my_gethwaddr() does not compile on Solaris 11
Revision #3097 Fri 2012-01-20 23:54:43 -0800
Fixed Bug #919427.
The function subselect_uniquesubquery_engine::copy_ref_key has to take into account that when EXPLAIN is processed the array of store_key object created for any TABLE_REF may contain elements for constant items. These items should be ignored by thefunction.
Revision #3096 Thu 2012-01-12 20:13:41 +0100
Bug #901693 dialog.c:perform_dialog treats every password prompt as first
Revision #3095 Thu 2012-01-12 20:13:22 +0100
Bug #893522 more problems found by PVS Studio
Revision #3094 Thu 2012-01-12 20:12:46 +0100
openpam compatibility
Revision #3093 Thu 2012-01-12 20:12:14 +0100
fixes for get_password():
on windows: don't hang when there's no console, that is, _getch() returns -1.
on windows: _getch() returns an int, not char. to distinguish between (char)255 and (int)-1
everywhere. isspace(pos[-1]) == ' ' never worked, isspace() returns a boolean, not a char. the never-worked loop was removed to preserve the existing behavior.
Revision #3092 Fri 2011-12-30 13:57:03 +0100
plugin renamed socket_peercred -> unix_socket.
test added.
Revision #3091 Thu 2011-12-29 22:52:13 +0100
on windows: don't link all plugins with mysqld, only do it for storage engines.
Revision #3090 Sat 2012-01-14 00:02:02 -0800
Back-ported the test case for bug #12616253 from mariadb-5.3 that was actually a duplicate of Bug #888456 fixed in mariadb-5.2.
Revision #3089 Fri 2012-01-13 19:00:50 -0800
Back-ported the fix and the test case for MySQL Bug #50257 from mariadb-5.3 code line.
Adjusted results for a few test cases.
Revision #3088 Fri 2012-01-13 12:23:19 -0800
Back-ported the test cases for bug #12763207 from mysql-5.6 code line into 5.2
Completed the fix for this bug.
Note: in 5.3 the affected 'if' statement in Item_in_subselect::single_value_transformer() starting with the condition (thd->variables.sql_mode & MODE_ONLY_FULL_GROUP_BY) should be removed altogether. The change from table.cc is not needed either.
This is because in 5.3
min/max transformation for subqueries are done at the optimization phase
evaluation of the expensive subqueries is done at the execution phase.
Added an EXPLAIN EXTENDED to the test case for bug #12329653.
Revision #3087 Tue 2012-01-10 19:26:47 +0100
MDEV-50 : Fix default compilation comment
Revision #3086 Tue 2012-01-10 19:23:00 +0100
Fix MDEV-49 : version_compile_machine server variable is 'unknown' for x64 builds
Revision #3085 Sun 2012-01-08 20:29:05 +0200
Fixed compiler and test failures found by buildbot
Revision #3084 [merge] Sat 2012-01-07 14:59:03 +0200
Merge
Revision #3082.1.1 Sat 2012-01-07 10:23:46 +0200
Fixed wrong merge
Revision #3083 Thu 2012-01-05 11:06:52 +0200
Fix of Bug #793589 Wrong result with double ORDER BY
Problem was in caching 'eq_ref' dependency between calls of remove_const() for ORDER BY and GROUP BY lists.
Revision #3082 [merge] Wed 2012-01-04 17:22:06 +0200
Merge with 5.1
Revision #2643.127.68 Thu 2011-12-29 21:55:17 -0800
Fixed Bug #848652.
The cause of this bug was the same as for Bug #902356 fixed for 5.3.
Revision #2643.127.67 Wed 2011-12-21 13:23:15 +0200
Fixes Bug #907049 "Server started with skip-aria crashes on an attempt to connect to it"
Revision #3081 Mon 2012-01-02 23:52:31 +0100
Fix embedded/windows tests- move COND_manager and LOCK_manager to sql_manager.cc, to prevent race condition that results into accessing already destroyed critical section
Revision #3080 Thu 2011-12-29 15:09:20 -0800
Fixed Bug #806057.
A table expression with a natural join or a USING clause is transformed into an equivalent expression with equi-join ON conditions. If a reference to a virtual column happened to occur only in these generated equi-join conditions then it was not erroneously marked in the TABLE::vcol_set bitmap.
This could lead to wrong results for queries containing natural join expressions or USING clauses.
Revision #3079 Wed 2011-12-28 18:47:01 -0800
Fixed Bug #777654.
The method Item_sum_num::fix_fields() calculated the value of the flag Item_sum_num::maybe_null in some cases incorrectly.
Revision #3078 Tue 2011-12-27 19:13:53 -0800
Fixed Bug #879860.
The MIN/MAX optimization cannot be applied to a subquery if its WHERE clause contains a conjunctive condition depending on an outer reference.
Revision #3077 Tue 2011-12-27 13:19:13 -0800
Fixed Bug #904345.
The MIN/MAX optimizer code from the function opt_sum_query erroneously did not take into account conjunctive conditions that did not depend on any table, yet were not identified as constant items. These could be items containing rand() or PS/SP parameters. These items are supposed to be evaluated at the execution phase. That's why if such conditions can be extracted from the WHERE condition the MIN/MAX optimization is not applied as currently it is always done at the optimization phase.
(In 5.3 expensive subqueries are also evaluated only at the execution phase. So, if a constant condition with such subquery can be extracted from the WHERE clause the MIN/MAX optimization should not be applied in 5.3.)
IF an IN/ALL/SOME predicate with a constant left part is transformed into an EXISTS subquery the resulting subquery should not be considered uncacheable if the right part of the predicate is not uncacheable.
Backported the function dbug_print_item() from 5.3. The function is used only for debugging.
Revision #3076 [merge] Fri 2011-12-23 15:02:57 +0100
merge
Revision #3075.1.1 Thu 2011-12-22 15:50:33 +0100
Bug #906638 : Fixes to build oqgraph with boost 1.48
dijkstra_shortest_paths() needs a Graph as first parameter, in case of reverse_graph we now need to use its m_g member
use boost::tuples::tie() on all places where tie() was used . Reason - fix the build with Visual Studio 10 SP1 (which includes std:tr1:tie, thus creating ambiguity)
Revision #3075 Thu 2011-12-22 11:07:04 +0100
compilation warning - unused variable
Revision #3074 Wed 2011-12-21 12:45:53 +0200
Supression condition made wider to cover some other system cases.
Revision #3073 Tue 2011-12-20 01:56:41 -0800
Fixed Bug #794005.
The function st_table::mark_virtual_columns_for_write() did not take into account the fact that for any table the value of st_table::vfield is 0 when there are no virtual columns in the table definition.
Revision #3072 Mon 2011-12-19 14:55:30 -0800
Fixed Bug #906322.
If the sorted table belongs to a dependent subquery then the function create_sort_index() should not clear TABLE:: select and TABLE::select for this table after the sort of the table has been performed, because these members are needed for the second execution of the subquery.
Revision #3071 [merge] Tue 2011-12-13 20:08:41 +0200
Merge with 5.1
Updated version number in configure
Revision #2643.127.66 Mon 2011-12-12 16:28:16 +0100
new "
./configure --disable-distribution
" option
Revision #2643.127.65 Mon 2011-12-12 13:37:18 +0100
Fix GCC build failure in PBXT in some cases/platforms.
Revision #2643.127.64 Sun 2011-12-11 22:58:01 +0200
Fixed valgrind problem: reference on deleted memory of temporary table name.
Removed previous patch of this problem.
Revision #3070 Tue 2011-12-13 19:57:19 +0200
Fixed Bug #887051 ; Error in recovery with LOAD DATA + DELETE
Revision #3069 Mon 2011-12-12 12:36:46 +0200
Fixed Bug #900375
The range optimizer incorrectly chose a loose scan for group by when there is a correlated WHERE condition. This range access method cannot be executed for correlated conditions also with the "range checked for each record" because generally the range access method can change for each outer record. Loose scan destructively changes the query plan and removes the GROUP operation, which will result in wrong query plans if another range access is chosen dynamically.
Revision #3068 Thu 2011-12-08 12:05:52 +0200
Fixed Bug #888456
Analysis:
The class member QUICK_GROUP_MIN_MAX_SELECT::seen_first_key was not reset between subquery re-executions. Thus each subsequent execution continued from the group that was reached by the previous subquery execution. As a result loose scan reached end of file much earlier, and returned empty result where it shouldn't.
Solution:
Reset seen_first_key before each re-execution of the loose scan.
This page is licensed: CC BY-SA / Gnu FDL
Last updated
Was this helpful?