14-day MaxScale Trial: Explore the latest version of our advanced database proxy!
Start Trial
Download MariaDBContact Us

MariaDB 5.3.0 Changelog p3

Download |Release Notes |Changelog (page:123456 ) |Overview of 5.3

Release date: 26 July 2011

  • Revision #3000 [merge] Thu 2011-05-19 20:03:33 -0700

    • Merge

    • Revision #2998.1.1 [merge] Thu 2011-05-19 20:01:43 -0700

      • Merged the fix for Bug #777745 into 5.3.

        • Revision #2980.1.1 Thu 2011-05-19 18:28:38 -0700

          • Fixed Bug #777745

          • Fields belonging to views in general cannot be substituted for equal items, in particular for constants, because all references to a view field refer to the same Item_field object while they could be used in different OR parts of the where condition and belong to different equivalence classes (to different Item_equals). That's why substitution for equal items in any context is allowed only in place of Item_direct_view_ref objects, but not in place of Item_fields these objects refer to. Due to some erroneous code in the patch for Bug #717577 substitution for view fields were allowed in some context.This could lead

          • The fix prohibits substitution of view fields for equal items in any context.

          • The patch also changes slightly the compile method for the Item_func class. Now if the analyze method returns NULL in his parameter the compile method is not called for the arguments of the function at all. A similar change was made for the Item_ref class.

  • Revision #2999 [

    • merge] Fri 2011-05-20 01:41:07 +0200

    • merge

  • Revision #2998 [merge] Thu 2011-05-19 19:23:06 +0300

    • Automatic merge

    • Revision #2992.2.4 Thu 2011-05-19 18:14:02 +0300

      • Updated comments as part of code review

    • Revision #2992.2.3 Thu 2011-05-19 16:37:57 +0300

      • Fix based on suggestion by Zardosht Kasheff and Richard Prohaska) for making all clustered indexes equal in test_if_skip_sort_order()

    • Revision #2992.2.2 Wed 2011-05-18 19:26:30 +0300

      • Original idea from Zardosht Kasheff to add HA_CLUSTERED_INDEX

        • Added a lot of code comments

        • Updated get_best_ror_intersec() to prefer index scan on not clustered keys before clustered keys.

        • Use HA_CLUSTERED_INDEX to define if one should use HA_MRR_INDEX_ONLY

        • For test of using index or filesort to resolve ORDER BY, use HA_CLUSTERED_INDEX flag instead of primary_key_is_clustered()

        • Use HA_TABLE_SCAN_ON_INDEX instead of primary_key_is_clustered() to decide if ALTER TABLE ... ORDER BY will have any effect.

    • Revision #2992.2.1 Wed 2011-05-18 13:36:12 +0300

      • Added HA_ERR_DISK_FULL handler error

      • Original code by Zardosht Kasheff

  • Revision #2997 Thu 2011-05-19 08:45:06 +0300

    • PBXT test fix.

  • Revision #2996 [merge] Wed 2011-05-18 23:03:46 +0300

    • automatic merge

    • Revision #2992.1.1 Wed 2011-05-18 16:27:19 +0300

      • Rewritten patch of percona - switching query cache on and off, removing comments.

  • Revision #2995 [merge] Wed 2011-05-18 15:31:20 +0200

    • automerge

    • Revision #2732.26.24 Wed 2011-05-18 15:22:56 +0200

      • merge some fixes for rpl_corruption.test from MySQL 5.6.

  • Revision #2994 [merge] Wed 2011-05-18 15:19:18 +0200

    • automerge

  • Revision #2993 Wed 2011-05-18 12:28:17 +0200

    • Fix compile warning.

  • Revision #2992 Wed 2011-05-18 00:47:56 +0300

    • Removed some alias warnings

    • Fixed alias bug when compiling with gcc 4.2.4 that caused subselect.test to fail

  • Revision #2991 Mon 2011-05-16 16:21:09 +0300

    • fix dynco test on Windows, really now (from Wlad)

  • Revision #2990 Mon 2011-05-16 16:13:34 +0300

    • Fix of compiler errors.

  • Revision #2989 [merge] Mon 2011-05-16 15:16:48 +0300

  • Revision #2988 Fri 2011-05-13 18:27:43 +0300

    • Directories with .dylib files added to DYLD_LOIBRARY_PATH to allow plugins to use them.

  • Revision #2987 Thu 2011-05-12 18:01:36 +0300

    • Fix library build on mac (prevent handlersocket.so loading failure if it called from build directory)

  • Revision #2986 [merge] Thu 2011-05-12 01:02:55 +0300

  • Revision #2985 [merge] Wed 2011-05-11 08:52:16 +0100

  • Revision #2984 [merge] Wed 2011-05-11 08:28:11 +0200

    • automerge

    • Revision #2732.26.23 Wed 2011-05-11 08:16:49 +0200

      • Fix race in testcase innodb_plugin.group_commit_no_optimize_thread

      • The problem was that connection con5, which is supposed to be the leader for the third group, could if timing was bad end up as participant in the second group, causing the test to fail.

      • Fixed by ensuring that group 2 is running before starting the transaction for group 3.

  • Revision #2983 [merge] Tue 2011-05-10 18:28:05 +0300

    • MWL#89 - Automatic merge with 5.3

    • Revision #2979.1.3 Thu 2011-05-05 15:24:28 +0300

      • Fix Bug #772309

      • Analysis: The method st_select_lex::optimize_unflattened_subqueries() incorrectly propagated to each subquery the complete select_options flag set for the whole query. Among other flags in select_options, this propagated incorrectly the STRAIGHT_JOIN flag from the upper query to the subquery.

      • Solution: During EXPLAIN set only the SELECT_DESCRIBE bit in the select_options of the subquery.

    • Revision #2979.1.2 Thu 2011-05-05 01:35:03 +0300

      • MWL#89

        • Adjusted test results after merge.

    • Revision #2979.1.1 [merge] Thu 2011-05-05 00:35:21 +0300

  • Revision #2982 Sun 2011-05-08 13:26:07 +0300

    • Fixed compiler warnings

  • Revision #2981 [merge] Sat 2011-05-07 15:48:45 +0200

  • Revision #2980 Wed 2011-05-04 18:08:44 -0700

    • Fixed Bug #776295. If the value of the flag cond_false of an Item_equal object is true then the print method must return the string '0'.

  • Revision #2979 Wed 2011-05-04 11:23:29 -0700

    • Fixed Bug #751350: The third parameter in the call of make_cond_for_table() that built the pushed condition containing only outer references was incorrect. This condition appeared for the first time in the patch fixing Bug #729039.

  • Revision #2978 Tue 2011-05-03 17:11:45 -0700

  • Revision #2977 Mon 2011-05-02 13:02:36 +0200

    • Shoot in the dark - try to fight build environment based on cygwin, where presumably neither TMP nor TEMP environment variable are set.

  • Revision #2976 Mon 2011-05-02 13:25:53 +0300 (no message)

  • Revision #2975 [merge] Fri 2011-04-29 19:20:46 -0700

    • Merge

    • Revision #2972.1.1 Wed 2011-04-27 15:29:46 -0700

      • Fixed Bug #754521: The function test_quick_select by mistake did not update the value of table->quick_condition_rows for index intersection scans though the specification explicitly required to do so from any table access plan once the plan provided a better upper bound for the number of rows selected from the table. It resulted in a bogus, usually very big number saved as the cost of the table access. This, in its turn, in many cases forced the optimizer to make a bad choice of the execution plan for join queries.

  • Revision #2974 Thu 2011-04-28 19:56:10 +0300

    • Added ALTER ONLINE TABLE, which will give an error if the change can't be done 'instantly' (without a table copy)

  • Revision #2973 Thu 2011-04-28 18:02:26 +0300

    • Added option "AND DISABLE CHECKPOINT" to "FLUSH TABLES WITH READ LOCK"

    • This makes it possible to do safe multi volume snapshots as long as one snapshots the volume with the transaction logs last.

  • Revision #2972 [merge] Tue 2011-04-26 21:11:06 -0700

    • Merge

    • Revision #2907.2.1 Tue 2011-04-26 19:58:41 -0700

      • Fixed Bug #717577, Bug #724942:

        • Both these two bugs happened due to the following problem. When a view column is referenced in the query an Item_direct_view_ref object is created that is refers to the Item_field for the column. All references to the same view column refer to the same Item_field. Different references can belong to different AND/OR levels and, as a result, can be included in different Item_equal object. These Item_equal objects may include different constant objects. If these constant objects are substituted for the Item_field created for a view column we have a conflict situation when the second substitution annuls the first substitution. This leads to wrong result sets returned by the query. Bug #724942 demonstrates such an erroneous behaviour.

        • Test case of the Bug #717577 produces wrong result sets because best equal fields of the multiple equalities built for different OR levels of the WHERE condition differs. The subsitution for the best equal field in the second OR branch overwrites the the substitution made for the first branch.

        • To avoid such conflicts we have to substitute for the references to the view columns rather than for the underlying field items. To make such substitutions possible we have to include into multiple equalities references to view columns rather than field items created for such columns.

        • This patch modifies the Item_equal class to include references to view columns into multiple equality objects. It also performs a clean up of the class methods and adds more comments. The methods of the Item_direct_view_ref class that assist substitutions for references to view columns has been also added by this patch.

  • Revision #2971 Wed 2011-04-20 15:30:21 -0700

    • Fixed Bug #752353. In some cases the field max_part_no of the SEL_ARG structure was not initialized. That triggered a Valgrind complain.

  • Revision #2970 Tue 2011-04-19 14:34:40 +0200

    • Bug #730035 Handlersocket does not load

      • -fimplicit-termplates must be in CXXFLAGS not in handlersocket_la_CXXFLAGS. otehrwise automake puts it in the command line too early to override global -fno-implicit-templates

  • Revision #2969 [merge] Thu 2011-04-14 13:25:18 +0200

    • Merge test case fix from MariaDB 5.2-rpl into 5.3.

    • Revision #2732.26.19 Thu 2011-04-14 13:23:02 +0200

      • Fix race in testcase innodb_plugin.group_commit

      • The problem was that connection con5, which is supposed to be the leader for the third group, could if timing was bad end up as participant in the second group, causing the test to fail.

      • Fixed by ensuring that group 2 is running before starting the transaction for group 3.

  • Revision #2968 Tue 2011-04-12 15:06:09 +0200

    • Missing PBXT result file updates after previous patch.

  • Revision #2967 [

    • merge] Sun 2011-04-10 23:00:08 -0700

    • merge

  • Revision #2966 [merge] Fri 2011-04-08 09:39:33 +0200

    • Merge various replication-related patches into MariaDB 5.3:

      • MWL#116 Group commit

      • MWL#136 Enhancements for START TRANSACTION WITH CONSISTENT SNAPSHOT

      • MWL#47 Annotate_rows_log_event

      • MWL#163 innodb_release_locks_early

      • Percona patch enhancing row-based replication for tables with no primary key

    • Revision #2732.26.18 Thu 2011-04-07 17:21:22 +0200

      • Fix merge error.

    • Revision #2732.26.17 Thu 2011-04-07 13:55:18 +0200

      • MWL#116: After-review fixes.

      • Also implement the InnoDB changes for group commit into innodb_plugin.

    • Revision #2732.26.16 Thu 2011-04-07 12:41:49 +0200

      • Change lock release to assert in XtraDB commit_ordered(); we never want to hold the latch across the 2-phase commit, and it is already released at start of prepare (if not before).

      • Rename trx->active_trans to active_flag; since we changed the semantics of the field, renaming should help prevent silent merge errors.

    • Revision #2732.26.15 Mon 2011-04-04 21:56:19 +0200

      • After-merge fixes.

    • Revision #2732.26.14 [merge] Mon 2011-04-04 15:18:43 +0200

      • Merge --binlog_optimize_thread_scheduling into mariadb-5.2-rpl.

    • Revision #2732.26.13 [merge] Fri 2011-04-01 15:07:10 +0200

    • Revision #2732.26.12 [merge] Fri 2011-04-01 10:25:45 +0200

      • Merge MWL#136 after-review fixes into mariadb-5.2-rpl

    • Revision #2732.26.11 [merge] Thu 2011-03-31 15:32:04 +0200

    • Revision #2732.26.10 [merge] Mon 2011-01-31 15:40:58 +0100

      • Merge MWL#116, PBXT part into mariadb-5.2-rpl

      • This makes PBXT implement the commit_ordered() method, so that cross-engine START TRANSACTION WITH CONSISTENT SNAPSHOT works actually consistent with XtraDB.

      • Also mark the version number to show this is the -rpl feature preview.

    • Revision #2732.26.9 [merge] Thu 2011-01-27 20:08:00 +0100

    • Revision #2732.26.8 [merge] Thu 2011-01-27 16:54:49 +0100

    • Revision #2732.26.7 Thu 2011-01-27 15:56:44 +0100

      • After-merge fixes for MWL#47 (which causes changes in binlog positions in .result files).

      • Also fix one incorrect printf() format.

    • Revision #2732.26.6 [merge] Thu 2011-01-27 15:56:00 +0100

      • automerge

    • Revision #2732.26.5 [merge] Wed 2011-01-26 15:35:03 +0100

      • Merge three Percona patches into mariadb-5.2-rpl:

        • MWL#47, allowing to annotate row-based binlog events with the SQL test of the originating query (eg. in mysqlbinlog output).

        • row_based_replication_without_primary_key.patch, providing more intelligent selection of index to use on slave when applying row-based binlog events for tables with no primary key.

        • Make mysqlbinlog omit redundant use around BEGIN/SAVEPOINT/COMMIT/ROLLBACK in 5.0 binlogs.

    • Revision #2732.26.4 Wed 2011-01-26 14:52:39 +0100

      • Fix wrong printf() format.

    • Revision #2732.26.3 [merge] Sat 2010-12-25 18:28:24 +0100

    • Revision #2732.26.2 [merge] Sat 2010-12-25 16:14:50 +0100

    • Revision #2732.26.1 [merge] Sat 2010-12-25 15:42:33 +0100

      • Merge MWL#116 into mariadb-5.2-rpl.

  • Revision #2965 [merge] Fri 2011-04-08 02:54:01 +0200

  • Revision #2964 Fri 2011-04-08 02:12:03 +0400

    • Bug #752992: Wrong results for a subquery with 'semijoin=on'

      • Let advance_sj_state() save the value of JOIN::cur_dups_producing_tables in POSITION::prefix_dups_producing_tables, and restore_sj_state() restore it.

  • Revision #2963 [merge] Mon 2011-04-04 12:38:08 +0400

    • Merge: Make EXPLAIN better at displaying MRR/BKA

    • Revision #2948.1.2 Mon 2011-04-04 12:32:52 +0400

      • Amend the previous cset:

        • Make EXPLAIN better at displaying MRR/BKA:

          • Update all .result files

          • Extra comments

    • Revision #2948.1.1 Sat 2011-04-02 14:04:45 +0400

      • Make EXPLAIN better at displaying MRR/BKA:

        • "Using MRR" is no longer shown with range access.

        • Instead, both range and BKA accesses will show one of the following:

          • = "Rowid-ordered scan"

          • = "Key-ordered scan"

          • = "Key-ordered Rowid-ordered scan"

        • depending on whether DS-MRR implementation will do scan keys in order, rowids in order, or both.

        • The patch also introduces a way for other storage engines/MRR implementations to pass information to EXPLAIN output about the properties of employed MRR scans.

  • Revision #2962 [merge] Sun 2011-04-03 21:03:31 +0200

    • null merge

  • Revision #2961 Fri 2011-04-01 12:04:59 +0300

    • Fixed compiler warnings

  • Revision #2960 [merge] Thu 2011-03-31 18:35:57 +0300

    • Automatic merge

    • Revision #2958.1.3 Thu 2011-03-31 18:30:05 +0300

      • Fixed unlikely reference to freed memory in item->print().

    • Revision #2958.1.2 Thu 2011-03-31 16:26:51 +0300

      • Fixed all BUILD scripts to use g++ instead of gcc for linking

      • Fixed memory leak from HEAP tables that was not deleted properly

    • Revision #2958.1.1 Wed 2011-03-30 12:15:58 +0300

      • Fixes to get more information about random bind failure in pushbuild for windows hosts.

  • Revision #2959 [merge] Wed 2011-03-30 23:34:48 +0200

  • Revision #2958 [merge] Wed 2011-03-30 00:48:35 +0300

    • Merge the fix for Bug #613029.

    • Revision #2946.1.1 Mon 2011-03-28 12:55:36 +0300

      • Fix Bug #613029

      • Analysis:

        • There are two code paths through which JOIN::exec may produce an all-NULL row for an empty result set. One goes via the function return_zero_rows(), when query processing detectes early that the where clause is false, the other one is via do_select() in the case of join execution.

        • In the case of do_select(), the problem was that the executioner didn't set TABLE::null_row to 1. As result when sending the only result row, the evaluation of each field didn't detect that all non-aggregated fields are NULL, because Field::is_null returned true, after checking that field->table->null_row was false.

        • Given that the each non-aggregated field was not considered NULL, select_result::send_data sent whatever was in the buffer of each field. However, since there was no actual data in the field buffer, send_data() accessed and sent whatever junk was in the field's data buffer.

      • Solution:

        • Similar to the analogous case in return_zero_rows() mark all tables that their current row is NULL before sending the artificailly created NULL row.

  • Revision #2957 [

    • merge] Tue 2011-03-29 22:43:35 +0200

    • merge

  • Revision #2956 Tue 2011-03-29 20:56:54 +0200

    • Suppress ANALYZE_TABLE output, to be consistent with rest of the test case

  • Revision #2955 Tue 2011-03-29 20:37:30 +0200

    • Fix formatting error message (invalid table name) in handler tests.

  • Revision #2954 [merge] Mon 2011-03-28 17:19:40 +0200

    • null merge

  • Revision #2953 [

    • merge] Mon 2011-03-28 17:13:41 +0200

    • merge

  • Revision #2952 [

    • merge] Mon 2011-03-28 12:57:52 +0200

    • merge

  • Revision #2951 [

    • merge] Mon 2011-03-28 02:04:43 +0200

    • merge

  • Revision #2950 [

    • merge] Mon 2011-03-28 01:10:55 +0200

    • merge

  • Revision #2949 [

    • merge] Sat 2011-03-26 00:15:33 +0100

    • merge

  • Revision #2948 Fri 2011-03-25 16:33:17 +0300

  • Revision #2947 [merge] Fri 2011-03-25 12:47:44 +0300

    • Merge in fix for Bug #727667

    • Revision #2932.1.2 Fri 2011-03-25 12:43:32 +0300

      • Bug #727667 Wrong result with OR + NOT NULL in maria-5.3

        • Address review feedback: introduce NO_REF_PART symbolic name, better comments

    • Revision #2932.1.1 Sat 2011-03-05 12:56:22 +0300

      • Bug #727667 Wrong result with OR + NOT NULL in maria-5.3

        • put the code that sets HA_NULL_PART bit back

        • Fix test_if_ref/part_of_refkey() so that

          • NULL-ability of lookup columns does not prevent the equality from being removed (we now have early/late NULLs filtering which will filter out NULL values)

          • equality is not removed if it is ref_or_null access, and the value of the lookup column can alternate between the lookup value and NULL.

  • Revision #2946 Thu 2011-03-24 16:34:06 +0200

    • Fix Bug #715738

      • Analysis:

        • A query with implicit grouping is one with aggregate functions and no GROUP BY clause. MariaDB inherits from MySQL an SQL extenstion that allows mixing aggregate functions with non-aggregate fields. If a query with such mixed select clause produces an empty result set, the meaning of aggregate functions is well defined - either NULL (MIN, MAX, etc.), or 0 (count(*)). However the non-aggregated fields must also have some value, and the only reasonable value in the case of empty result is NULL.

        • The cause of the many wrong results was that if a field is declared as non-nullable (e.g. because it is a PK or NOT NULL), the semantic analysis and the optimization phases treat this field as non-nullable, and generate all related query plan elements based on this assumption.

        • Later during execution, these incorrectly configured/generated query plan elements result in a wrong result because the selected fields are not null due to the not-null assumption during optimization.

      • Solution:

        • Detect before the context analysys phase that a query uses implicit grouping with mixed aggregates/non-aggregates, and set all fields as nullable. The parser already walks the SELECT clause, and already sets Item::with_sum_func for Items that reference aggreagate functions. The patch adds a symmetric Item::with_field so that all Items that reference an Item_field are marked during their construction at parse time in the same way as with aggregate function use.

MariaDB 5.3.0 Changelog — page:123456

Be notified of new MariaDB Server releases automatically by subscribing 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 page.

This page is licensed: CC BY-SA / Gnu FDL

PreviousMariaDB 5.3.0 Changelog p2NextMariaDB 5.3.0 Changelog p4

Last updated

Was this helpful?