The Ultimate Guide to High Availability with MariaDB

MariaDB 5.3.0 Changelog p5

You are viewing an old version of this article. View the current version here.

Download | Release Notes | Changelog (page: 1 2 3 4 5 6 ) | Overview of 5.3

Release date: 26 July 2011

  • Revision #2880 Sat 2011-01-15 23:39:51 -0800
    • Corrected test case for Bug #698882 to make it platform independent
  • Revision #2879 [merge] Sat 2011-01-15 12:42:32 -0800
    • Merge
    • Revision #2875.2.1 Sat 2011-01-15 11:14:36 -0800
      • Fixed Bug #698882.
      • Made sure that the optimal fields are used by TABLE_REF objects when building index access keys to joined tables.
      • Fixed a bug in the template function that sorts the elements of a list using the bubble sort algorithm. The bug caused poor performance of the function. Also added an optimization that skips comparison with the most heavy elements that has been already properly placed in the list.
      • Made the comparison of the fields belonging to the same Item_equal more granular: fields belonging to the same table are also ordered according to some rules.
  • Revision #2878 [merge] Fri 2011-01-14 23:53:27 -0800
    • Merge
    • Revision #2875.1.1 Fri 2011-01-14 22:55:56 -0800
      • Ported the fix for Bug #702310 / MySQL Bug #59493.
      • An assertion failure was triggered for a 6-way join query that used two join buffers.
      • The failure happened because every call of JOIN_CACHE::join_matching_records saved and restored status of all tables that were accessed before the table join_tab. It must do it only for those of them that follow the last table using a join buffer.
  • Revision #2877 [merge] Fri 2011-01-14 13:07:50 +0300
    • Merge backported subquery bugfixes/testcases into MariaDB 5.3
    • Revision #2869.2.5 Fri 2011-01-14 00:47:03 +0300
      • Backport testcase for: MySQL Bug #43360 - Server crash with a simple multi-table update
    • Revision #2869.2.4 Fri 2011-01-14 00:15:44 +0300
      • Testcase Backport: MySQL Bug #48093: 6.0 Server not processing equivalent IN clauses properly
    • Revision #2869.2.3 Thu 2011-01-13 23:47:15 +0300
      • Backport testcase for:
        • mybug #45092: join buffer contains two blob columns one of which is used in the key employed to access the joined table
    • Revision #2869.2.2 Thu 2011-01-13 19:25:31 +0300
      • Backport of (see below) + temporary measures to make SJ-Materialization work with join buffering.
        • Date: Mon, 01 Nov 2010 15:15:25 -0000<</style>>
        • 3272 Roy Lyseng 2010-11-01
        • MySQL Bug #52068: Optimizer generates invalid semijoin materialization plan
        • When MaterializeScan semijoin strategy was used and there were one or more outer dependent tables before the semijoin tables, the scan over the materialized table was not properly reset for each row of the prefix outer tables.
        • Example: suppose we have a join order:
        • ot1 SJ-Mat-Scan(it2 it3) ot4
        • Notice that this is called a MaterializeScan, even though there is an outer table ahead of the materialized tables. Usually a MaterializeScan has the outer tables after the materialized table, but this is a special (but legal) case with outer dependent tables both before and after the materialized table.
        • For each qualifying row from ot1, a new scan over the materialized table must be set up. The code failed to do that, so all scans after the first one returned zero rows from the materialized table.
    • Revision #2869.2.1 Sat 2010-12-25 16:23:16 +0300 MySQL Bug #46680: Assertion failed in file item_subselect.cc, line 305 crashing on HAVING subquery - Backport the testcase (the fix itself was included with the subquery optimizations backport)
  • Revision #2876 Wed 2011-01-12 15:00:10 +0300
    • Bug #665669: Result differences on query re-execution
      • Cause: handler::in_range_check_pushed_down was not reset when a command would call handler->idx_cond_push() without later calling handler->index_end().
      • Fix: reset the variable in handler->reset(), too (like we do with other Index Condition Pushdown members).
  • Revision #2875 Wed 2011-01-05 15:03:30 -0800
    • Fixed Bug #697557. When stored in a key buffer any varchar field has a length prefix that always takes 2 bytes.
  • Revision #2874 Wed 2010-12-29 18:14:03 -0800
  • Revision #2873 [merge] Wed 2010-12-29 13:45:38 -0800
  • Revision #2872 Sun 2010-12-26 16:31:03 -0800
    • Fixed Bug #694443 One of the hash functions employed by the BNLH join algorithm calculates the the value of hash index for key value utilizing every byte of the key buffer. To make this calculation valid one has to ensure that for any key value unused bytes of the buffer are filled with with a certain filler. We choose 0 as a filler for these bytes.
    • Added an optional boolean parameter with_zerofill to the function key_copy. If the value of the parameter is TRUE all unused bytes of the key buffer is filled with 0.
  • Revision #2871 [merge] Sat 2010-12-25 18:54:14 -0800
    • Merge
    • Revision #2869.1.1 Fri 2010-12-24 14:36:35 -0800
      • Fixed Bug #694092
      • In some cases the function make_cond_for_index() was mistaken when detecting index only pushdown conditions for a table: a pushdown condition that was not index only could be marked as such.
      • It happened because the procedure erroneously used the markers for index only conditions that remained from the calls of this function that extracted the index conditions for other tables.
      • Fixed by erasing index only markers as soon as they are need anymore.
  • Revision #2870 [merge] Fri 2010-12-24 16:24:20 -0800
    • Merge
    • Revision #2867.1.1 Wed 2010-12-22 00:37:35 -0800
      • Fixed Bug #670380 Lifted the limitation that hash join could not be used over varchar fields with non-binary collation.
  • Revision #2869 Wed 2010-12-22 02:26:35 +0300
    • Fix compile error on Windows: instead of round(X) use floor(X+0.5)
  • Revision #2868 [merge] Tue 2010-12-21 14:40:23 +0300
    • MWL#121-125 DS-MRR improvements
      • Merge with 5.3-main
    • Revision #2866.1.10 Mon 2010-12-20 14:40:12 +0300
      • Bug #670417: Diverging results in maria-5.3-mwl128-dsmrr-cpk with join buffer
        • Fixes for the second fix: take into account case where we don't need to save/restore the scan.
    • Revision #2866.1.9 Sun 2010-12-19 13:56:12 +0300
      • Bug #670417: Diverging results in maria-5.3-mwl128-dsmrr-cpk with join buffer
        • Switch from "Disable identical key handling optimization when
        • IndexConditionPushdown is used" approach
        • To
        • an approach where we save/restore index tuple and so can use index condition pushdown.
    • Revision #2866.1.8 Fri 2010-12-17 14:58:08 +0300
      • Fix a compiler warning on sparc32
    • Revision #2866.1.7 Fri 2010-12-17 13:06:21 +0300
      • Small code cleanups
    • Revision #2866.1.6 Thu 2010-12-16 23:43:52 +0300
      • Better comments
    • Revision #2866.1.5 Thu 2010-12-16 23:37:26 +0300
      • MWL#121-125 DS-MRR improvements
        • Address Monty's review feedback, portion 3
    • Revision #2866.1.4 Thu 2010-12-16 21:18:35 +0300
      • MWL#121-125 DS-MRR improvements
        • Address Monty's review feedback, portion 2
    • Revision #2866.1.3 Wed 2010-12-15 10:45:08 +0300
      • Fix compiler warning
      • Better warnings
    • Revision #2866.1.2 Mon 2010-12-13 20:01:32 +0300
      • MWL#121-125 DS-MRR improvements
        • Address review feedback: change return type of RANGE_SEQ_IF::next()
    • Revision #2866.1.1 [merge] Mon 2010-12-13 13:42:40 +0300
      • Merge DS-MRR/CPK improvements into 5.3-main
  • Revision #2867 Tue 2010-12-14 14:08:05 +0200
    • Fix Bug #685411
      • Analysis:
        • The assert failed because st_select_lex::print() was called for subqueries as follows:
        • Item_subselect::print() -> subselect_single_select_engine::print() -> st_select_lex::print()
        • It was Item_subselect::fix_fields() that set the thd by calling set_thd(), so when this print() was called before fix_fields(), subselect_engine::thd was NULL.
      • Solution:
        • The patch makes all constructors of all subselect_engine classes to take a THD parameter. The default subselect_single_select_engine engine is created early during parse time, in the Item_subselect::init call, so we pass the correct THD object already at this point.
  • Revision #2866 Sat 2010-12-11 12:50:39 -0800
    • Fixed compiler warnings.
  • Revision #2865 [merge] Fri 2010-12-10 23:23:34 -0800
    • Merge.
    • Revision #2850.1.11 Fri 2010-11-19 11:03:03 -0800
      • Got the declarations related to the class JOIN_CACHE, its derivatives and companions out of sql_select.h into a separate file sql_join_cache.h.
    • Revision #2850.1.10 Fri 2010-11-19 07:38:02 -0800
      • Fixed Bug #675922.
      • The bug happened when BKA join algorithm used an incremental buffer and some of the fields over which access keys were constructed
        • were allocated in the previous join buffers
        • were non-nullable
        • belonged to inner tables of outer joins.
      • For such fields an offset to the field value in the record is saved in the postfix of the record, and a zero offset indicates that the value is null. Before the key using the field value is constructed the value is read into the corresponding field of the record buffer and the null bit is set for the field if the offset is 0. However if the field is non-nullable the table->null_row must be set to 1 for null values and to 0 for non-null values to ensure proper reading of the value from the record buffer.
    • Revision #2850.1.9 Fri 2010-11-19 06:20:28 -0800
      • Fixed Bug #660963.
      • The condition that was supposed to check whether a join table is an inner table of a nested outer join or semi-join was not quite correct in the code of the function check_join_cache_usage.
      • That's why some queries with nested outer joins triggered an assertion failure.
      • Encapsulated this condition in the new method called JOIN_TAB::is_nested_inner and provided a proper code for it.
      • Also corrected a bug in the code of check_join_cache_usage() that caused a downgrade of not first join buffers of the level 5 and 7 to level 4 and 6 correspondingly.
    • Revision #2850.1.8 Mon 2010-11-15 21:07:32 -0800
      • Fixed Bug #675516.
      • When pushing the condition for a table in the function JOIN_TAB::make_scan_filter the optimizer must not push conditions from WHERE if the table is some inner table of an outer join..
    • Revision #2850.1.7 Sun 2010-11-14 23:38:25 -0800
      • Fixed Bug #675095.
      • The condition over outer tables extracted from the on expression for a outer join must be ANDed to the condition pushed to the first inner table of this outer join only.
      • Nested outer joins cannot use flat join buffers. So if join_cache_level is set to 1 then any join algorithm employing join buffers cannot be used for nested outer joins.
    • Revision #2850.1.6 Sat 2010-11-13 07:47:43 -0800
      • Fixed Bug #674423.
      • The patch that introduced the new enumeration type Match_flag for the values of match flags in the records put into join buffers missed the necessary modifications in JOIN_CACHE::set_match_flag_if_none.
      • This could cause wrong results for outer joins with on expressions only over outer tables.
    • Revision #2850.1.5 [merge] Sat 2010-11-13 06:35:54 -0800
      • Merge
    • Revision #2850.1.4 Fri 2010-11-12 16:53:20 -0800
    • Revision #2850.1.3 [merge] Thu 2010-11-11 16:59:08 -0800
      • Merge
    • Revision #2850.1.2 [merge] Thu 2010-11-11 16:38:55 -0800
      • Merge
    • Revision #2850.1.1 [merge] Wed 2010-11-10 14:34:37 -0800
      • Merge
  • Revision #2864 Wed 2010-12-08 16:16:32 +0200
    • Fixed test results for windows builds
    • Fixed compiler warning
  • Revision #2863 [merge] Tue 2010-12-07 00:15:27 +0100
  • Revision #2862 Mon 2010-12-06 20:44:17 +0300
    • Post-merge fixes: fix compile failure in buildbot
  • Revision #2861 [merge] Mon 2010-12-06 13:40:52 +0100
    • merge
  • Revision #2860 [merge] Mon 2010-12-06 10:25:44 +0200
    • Merge with 5.1-release.
      • Fixed problem with oqgraph and 'make dist'
      • Note that after this merge we have a problem show in join_outer where we examine too many rows in one specific case (related to MySQL Bug #57024).
      • This will be fixed when MWL#128 is merged into 5.3.
  • Revision #2859 Tue 2010-11-30 01:27:14 +0200
    • Fixed some compiler warnings found when compiling for windows.
    • Changed rows_read and rows_sent status variables to be longlong (to avoid compiler warnings)
  • Revision #2858 Mon 2010-11-29 23:58:18 +0100
    • Use three digits after the decimal point for better resolution and comparability of results.
  • Revision #2857 Mon 2010-11-29 22:02:33 +0200
    • Fix logical expression according to operation priority (also MS visual studio compiler warnings).
  • Revision #2856 [merge] Mon 2010-11-29 13:50:56 +0200
    • Auto-merge fix for Bug #611622
    • Revision #2853.1.1 Thu 2010-11-25 11:43:23 +0200
      • Fix Bug #611622
      • Fix MySQL Bug #52344 - Subquery materialization: Assertion if subquery in on-clause of outer join
      • Original fix and comments from Oysten, adjusted for the different subquery optimization in MariaDB.
      • Problem: If tables of an outer join are constant tables, the associated on-clause will be evaluated in the optimization phase. If the on-clause contains a query that is to be executed with subquery materialization, this will not work since the infrastructure for such execution is not yet set up.
      • Solution: Do not evaluate on-clause in optimization phase if is_expensive() returns true for this clause. This is how the problem is currently avoided for where-clauses. This works because, Item_in_subselect::is_expensive_processor returns true if query is to be executed with subquery materialization.
      • In addition, after MWL#89, in MariaDB if the IN-EXISTS strategy is chosen, the in-to-exists predicates are insterted after join_read_const_table() is called, resulting in evaluation of the subquery without the in-to-exists predicates.
  • Revision #2855 Sun 2010-11-28 15:02:12 +0200
    • Disable warning that comes 'occasionable' depending on if HAVING is executed or not.
  • Revision #2854 [merge] Sun 2010-11-28 14:38:59 +0200
    • Automatic merge
    • Revision #2851.1.4 Sat 2010-11-27 17:29:52 +0200
      • Added TRASH() to table->record[0] to find out if we access not initialzed data.
        • Changed Cached_item_field not copy data for fields with NULL value
        • In key_copy() and key_restore() don't copy data for fields with NULL value
      • Fixed code to avoid valgrind warnings
        • Use c_ptr_safe instead of c_ptr()
      • Removed "QQ" from comments (QQ was ment to be used for internal comments that should be removed before pushing) Fixed wrong alias used (from previous patch)
    • Revision #2851.1.3 [merge] Sat 2010-11-27 17:23:48 +0200
      • Automatic merge with 5.3 (support of BIT keys in heap)
    • Revision #2851.1.2 Wed 2010-11-24 00:08:48 +0200
      • Code cleanup to get fewer reallocs() during execution.
        • Changed TABLE->alias to String to get fewer reallocs when alias are used.
        • Preallocate some buffers
        • Changed some String->c_ptr() -> String->ptr() when \0 is not needed.
        • Fixed wrong usage of String->ptr() when we need a \0 terminated string.
        • Use my_strtod() instead of my_atof() to avoid having to add \0 to string.
        • c_ptr() -> c_ptr_safe() to avoid warnings from valgrind.
        • zr
    • Revision #2851.1.1 [merge] Tue 2010-11-16 19:52:44 +0200
      • Merge to get make String reallocation faster
  • Revision #2853 Thu 2010-11-25 00:34:50 +0200
    • Fix Bug #680058
    • Analysis:
      • The send_data method of the result sink class used to collect data statistics about materialized subqueries incorrectly assumed that duplicate rows are removed prior to calling send_data. As a result the collected statistics was wrong, which resulted in an incorrect maximal number of keys in the Ordered_key buffer.
    • Solution:
      • Try to insert each row into the materialized temp table before collecting statistics, and if the insertion results in a duplicate row, do not count the current row.
  • Revision #2852 Tue 2010-11-23 12:35:37 +0200
    • Fix for Bug #606013: Adding bit field support for heap tables.
  • Revision #2851 [merge] Thu 2010-11-11 14:35:26 +0200
    • Merge in Bug #602574
    • Revision #2831.1.1 Tue 2010-11-02 21:13:53 +0300
      • Bug #602574: RQG: sql_select.cc:5385: bool greedy_search... : Assertion `join->best_read
      • Make optimize_wo_join_buffering() handle cases where position->records_read=0 (this happens for outer joins that have constant tables inside them). The number of 0 is not correct (should be 1 because outer join will produce at least a NULL-complemented record) but for now we just make it work with incorrect number.
  • Revision #2850 [merge] Tue 2010-11-09 19:40:02 -0800
    • Merge
    • Revision #2844.1.1 Mon 2010-11-08 20:36:32 -0800
      • Fixed Bug #668644.
      • The pushdown condition for the sorted table in a query can be complemented by the conditions from HAVING. This transformation is done in JOIN::exec pretty late after the original pushdown condition have been saved in the field pre_idx_push_select_cond for the sorted table. So this field must be updated after the inclusion of the condition from HAVING.
  • Revision #2849 Tue 2010-11-09 13:13:56 +0200
    • Fixed Bug #615378 Incorrect processing of NULL result in Item_cache fixed.
  • Revision #2848 Tue 2010-11-09 09:52:22 +0200
    • Fix buildbot failure introduced by the previous push
  • Revision #2847 Mon 2010-11-08 23:25:12 +0200
    • Fix buildbot failures caused by two previous pushes.
  • Revision #2846 Mon 2010-11-08 20:51:31 +0300
    • Fix buildbot errors: rec_per_key_part can be 0 if re-opening
  • Revision #2845 Mon 2010-11-08 19:06:26 +0300
    • [Patch from Monty] Fix stack-overrun crash in subselect_notembedded.test
      • Make mi_open() use less stack space
  • Revision #2844 [merge] Fri 2010-11-05 12:37:51 +0200
    • Automerge with 5.2
  • Revision #2843 Fri 2010-11-05 11:54:42 +0200
    • Fixed usage of wrong variable in case of errors
  • Revision #2842 [merge] Tue 2010-11-02 16:08:02 -0700
  • Revision #2841 Tue 2010-11-02 16:04:39 -0700
    • Removed empty lines.
  • Revision #2840 [merge] Tue 2010-11-02 10:48:55 +0100
  • Revision #2839 Tue 2010-11-02 11:03:33 +0200
    • Fixed wrong queue_replace(), which caused timeout failure in pbxt.flush_read_lock_kill
    • Fixed compiler warnings.
  • Revision #2838 Fri 2010-10-29 18:59:39 -0700
    • Fixed Bug #665049.
    • The bug could cause wrong results for queries over Maria tables when index condition pushdown was used.
  • Revision #2837 [merge] Thu 2010-10-28 19:04:23 +0200
    • 5.2 merge
  • Revision #2836 Wed 2010-10-27 16:28:19 +0300
    • Fixed Bug #613009
    • The set of Ordered keys of a rowid merge engine is dense. Thus when we decide not to create a key for a column that has only NULLs, this column shouldn't be counted.
    • Notice that the caller has already precomputed the correct total number of keys that should be created.
  • Revision #2835 Wed 2010-10-27 12:35:15 +0300
    • Fixed Bug #609121
    • Post-review fix - avoid re-evaluation of the having clause when it evaluates to true.
  • Revision #2834 Wed 2010-10-27 06:03:59 +0300
    • Type of the variables fixed.
  • Revision #2833 Tue 2010-10-26 14:55:42 +0300
    • Fixed Bug #601156
    • The cause for this bug is that MariaDB 5.3 still processes derived tables (subqueries in the FROM clause) by fully executing them during the parse phase. This will be remedied by MWL#106 once merged into the main 5.3.
    • The assert statement is triggered when MATERIALIZATION is ON for EXPLAIN EXTENDED for derived tables with an IN subquery as follows:
      • mysql_parse calls JOIN::exec for the derived table as if it is regular execution (not explain).
      • When materialization is ON, this call goes all the way to subselect_hash_sj_engine::exec, which creates a partial match engine because of NULL presence.
      • In order to proceed with normal execution, the hash_sj engine substitutes itself with the created partial match engine.
      • After the parse phase it turns out that this execution was part of EXPLAIN EXTENDED, which in turn calls Item_cond::print -> ... -> Item_subselect::print, which calls engine->print(). Since subselect_hash_sj_engine::exec substituted the current Item_subselect engine with a partial match engine, eventually we call its ::print() method. However the partial match engines are designed only for execution, hence there is no implementation of this print() method.
    • The fix temporarily removes the assert, until this code is merged with MWL#106.

MariaDB 5.3.0 Changelog — page: 1 2 3 4 5 6

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.