Author: Sergei Golubchik
Revision Date: 2017-04-09 17:05:49 UTC

gdb.py: pitonify

Author: Michael Widenius
Revision Date: 2015-05-19 20:23:49 UTC

Fixed crashing bug when using ONLY_FULL_GROUP_BY in a stored procedure/trigger that is repeatedly executed.
This is MDEV-7601, including it's sub tasks MDEV-7594, MDEV-7555, MDEV-7590, MDEV-7581, MDEV-7589

The problem was that select_lex->non_agg_fields was not properly reset for re-execution and this caused an overwrite of a random memory position.
The fix was move non_agg_fields from select_lext to JOIN, which is properly reset.

Author: Sergei Golubchik
Revision Date: 2014-05-26 19:11:53 UTC

merge the compilation fixes from 10.0-FusionIO

Author: Oleksandr "Sanja" Byelkin
Revision Date: 2015-03-22 14:43:16 UTC

MDEV-7445:Server crash with Signal 6
MDEV-7565: Server crash with Signal 6 (part 2)

followup test suite and its fix.

Author: Olivier Bertrand
Revision Date: 2015-03-01 23:35:56 UTC

- Make json_udf test work on Windows
modified:
  storage/connect/mysql-test/connect/t/json_udf.inc

Author: Kentoku SHIBA
Revision Date: 2015-02-25 19:29:51 UTC

Merge Spider 3.2.19

Author: Sergey Petrunia
Revision Date: 2015-02-25 13:58:36 UTC

MDEV-7413: optimizer_use_condition_selectivity > 2 crashes 10.0.15+maria-1~wheezy

Add a testcase. The bug itself was fixed by the fix for MDEV-7316.

Author: Kristian Nielsen
Revision Date: 2015-02-23 09:13:11 UTC

MDEV-7310: last_commit_pos_offset set to wrong value after binlog rotate in group commit

When the binlog was rotated due to @@max_binlog_size, the values of the
binlog_shapshot_file and binlog_snapshot_position were inconsistent in case of
non-transactional DML. The position was refering to the old file, while the
filename was of the new file after rotation. This patch makes them consistent
by making sure the position is also refering to the new file.

Author: Kristian Nielsen
Revision Date: 2015-02-20 13:18:16 UTC

MDEV-7458: Deadlock in parallel replication can allow following transaction to start replicating too early

In parallel replication, don't rollback inside ha_commit_trans() in case of
error.

The rollback will be done later, but the parallel replication code needs to
run unmark_start_commit() before the rollback to properly control the
sequencing of transactions.

I did not manage to come up with a reliable automatic test case for this, but
I tested it manually.

Author: Sergei Golubchik
Revision Date: 2015-02-19 21:05:33 UTC

merge 10.0-spider

Author: Jan Lindström
Revision Date: 2015-02-19 15:16:56 UTC

Fix incorrect merge of extra/CMakeLists.txt

Author: Sergei Golubchik
Revision Date: 2015-02-11 19:40:56 UTC

XtraDB 5.5.41-37.0

Author: Sergei Golubchik
Revision Date: 2015-02-11 17:32:40 UTC

percona-server-5.5.41-37.0

Author: Alexey Botchkov
Revision Date: 2015-02-08 18:38:19 UTC

Audit plugin v1.2.0.

Author: Sergey Petrunia
Revision Date: 2015-02-06 10:44:22 UTC

Better formatting

Author: Georg Richter
Revision Date: 2015-01-28 17:25:27 UTC

Updated ignore file list

Author: Georg Richter
Revision Date: 2015-01-28 12:41:50 UTC

Fixed outdated dependencies of msi installer

Author: Nirbhay Choubey
Revision Date: 2015-01-28 01:22:06 UTC

Add cmake check for getifaddrs.

Author: Nirbhay Choubey
Revision Date: 2015-01-28 01:02:43 UTC

Add cmake check for getifaddrs.

Author: Alexey Botchkov
Revision Date: 2015-01-15 16:39:32 UTC

MDEV-7462 SET STATEMENT .. FOR <DML or DDL> is not recognized as DML or DDL.

Author: Georg Richter
Revision Date: 2015-01-14 07:13:23 UTC

Fixed javadoc errors

Author: Kristian Nielsen
Revision Date: 2015-01-13 07:28:20 UTC

Empty commit to trigger a buildbot run

Author: Sergey Petrunia
Revision Date: 2014-12-18 17:06:49 UTC

MDEV-6830: Server crashes in best_access_path after a sequence of SELECTs ...

generate_derived_keys_for_table() did not work correctly in the case where
- it had a potential index on derived table
- however, TABLE::check_tmp_key() would disallow creation of this index
  after looking at its future key parts (because of the key parts exceeding
  max. index length)
- the code would leave a KEYUSE structure that refers to a non-existant index.
  Depending on further optimizer calculations, this could cause a crash.

Author: Kristian Nielsen
Revision Date: 2014-12-18 15:57:43 UTC

Empty commit to trigger a buildbot run

Author: Kristian Nielsen
Revision Date: 2014-12-05 11:55:39 UTC

MDEV-6676: Optimistic parallel replication.

Fix that --slave-parallel-mode does not appear twice in mysqld --help
output.

(Also fix small typo in help message).

Author: Jan Lindström
Revision Date: 2014-12-02 09:03:51 UTC

Merge MariaDB 10.0.15 from lp:maria/10.0-FusionIO up to revision 4005.

Author: Sergei Golubchik
Revision Date: 2014-08-08 15:58:45 UTC

after-merge fixes for 10.0-connect

Author: Sergey Vojtovich
Revision Date: 2014-10-21 18:20:21 UTC

Merged mroonga updates.

Author: Nirbhay Choubey
Revision Date: 2014-10-17 22:08:54 UTC

Added some more test cases to non-GTID mode.

Author: Michael Widenius
Revision Date: 2014-09-23 07:49:13 UTC

Autmatic merge

Author: Sergey Petrunia
Revision Date: 2014-09-03 14:05:51 UTC

MDEV-6657: Poor plan choice for ORDER BY key DESC optimization...

Backport to MariaDB 10.0:
The problem was caused by the following scenario:
- range optimizer picks an index IDX1 which doesn't match the ORDER BY ...
  LIMIT clause.
- test_if_skip_sort_order() decides to switch to index IDX2 which matches
  the ORDER BY ... LIMIT.
- it runs SQL_SELECT::test_quick_select() for the second time to produce
  an quick select for IDX2.
- However, test_quick_select() would figure that full index scan on IDX1
  is still cheaper (its calculations ignore the LIMIT n).

Fixed this by
- passing force_quick_range=true to test_quick_select()
- in test_quick_select, don't consider full index scans if the mentioned
  parameter is true.

Numerous changes in .result files are caused by test_quick_select() being
run after "early/late NULLs filtering" feature has injected NOT NULL
condition.

Author: Michael Widenius
Revision Date: 2014-08-14 09:13:33 UTC

Apply Innodb changes for power8 to xtradb

Author: Oleksandr "Sanja" Byelkin
Revision Date: 2014-07-28 12:35:41 UTC

MDEV-6441: memory leak

Whole mysql_derived_prepare() was executed on statement memory. Now it is executed on runtime meory and all bugs induced bu this fixed.

Author: Sergey Petrunia
Revision Date: 2014-07-11 16:48:20 UTC

Explicit insert into an auto-inc column is not noticed by RocksDB
- Basic fix: don't forget to update the table-wide auto-increment value.

Author: Sergei Golubchik
Revision Date: 2014-06-02 15:33:08 UTC

5.1 merge

Author: Sergei Golubchik
Revision Date: 2014-05-05 15:48:54 UTC

cherry-pick http://bazaar.launchpad.net/~bzr-gtk/bzr-gtk/gtk3/revision/777

Avoid the use of Repository.get_ancestry().

Author: Sergei Golubchik
Revision Date: 2012-04-16 02:10:32 UTC

c

Author: Elena Stepanova
Revision Date: 2014-04-22 21:16:41 UTC

Change in the result file merged from 5.1 did not take into account
MariaDB-specific result replacement

Author: Sergei Golubchik
Revision Date: 2014-04-10 08:30:31 UTC

update to bzr 2.6.0

Author: Elena Stepanova
Revision Date: 2014-04-03 13:56:00 UTC

MDEV-6016 Packaging error with cmake 2.8.12 and greater

Avoid CPack complaints when a pdb file is missing for a static library
(patch from Vladislav Vaintroub)

Author: Kristian Nielsen
Revision Date: 2014-03-20 14:36:45 UTC

MDEV-5914: Parallel replication deadlock due to InnoDB lock conflicts

Preparation patch for investigating a possible solution.

Add THD::rpl_group_commit_id. This will be zero except when running
multiple transactions in parallel in parallel replication. Then it
can be compared between two THDs to check if these are two
transactions that were group-committed together on the master and
thus are known not to conflict.

Author: Sergei Golubchik
Revision Date: 2014-03-17 16:29:11 UTC

update deb patches for 5.2 and 5.3

Author: Vicențiu Ciorbaru
Revision Date: 2014-03-16 00:25:20 UTC

[SQL ACL] fill_schema_enabled_roles memory error checks

Author: Akira Higuchi
Revision Date: 2014-02-18 03:44:01 UTC

add hsmodule_pxc/client

Author: Michael Widenius
Revision Date: 2014-02-05 07:20:51 UTC

Replication changes for CREATE OR REPLACE TABLE
- CREATE TABLE is by default handled by slave as CREATE OR REPLACE
- DROP TABLE is by default handled by slave as DROP TABLE IF NOT EXISTS

- Ensure that a CREATE OR REPLACE TABLE which dropped a table is replicated
- DROP TABLE that generated an error on master is handled as DROP TABLE without IF NOT EXISTS on slave.
- Added slave_ddl_exec_mode_options to decide how DDL's are replicated

New logic for handling BEGIN GTID ... COMMIT from the binary log:

- When we find a BEGIN GTID, we start a transaction and set OPTION_GTID_BEGIN
- When we find COMMIT, we reset OPTION_GTID_BEGIN and execute the normal COMMIT code.
- While OPTION_GTID_BEGIN is set:
  - We don't generate implict commits before or after statements
  - All tables are regarded as transactional tables in the binary log (to ensure things are executed exactly as on the master)
- We reset OPTION_GTID_BEGIN also on rollback

This will help ensuring that we don't get any sporadic commits (and thus new GTID's) on the slave and will help keep the GTID's between master and slave in sync.

Author: Alexander Barkov
Revision Date: 2014-01-29 11:43:48 UTC

Adding environment variable GRN_PLUGINS_DIR when
running tests from a build directory.

modified:
  storage/mroonga/mysql-test/mroonga/storage/suite.pm
  storage/mroonga/mysql-test/mroonga/wrapper/suite.pm

Author: Sergei Golubchik
Revision Date: 2014-01-28 13:48:52 UTC

update to match the current kb changelog formatting

Author: Michael Widenius
Revision Date: 2014-01-26 18:57:20 UTC

Fix for MDEV-5168: MariaDB returns warnings for INSERT IGNORE

Added variable "OLD_MODE" that can be used to turn off the new behavior

Author: Sergey Petrunia
Revision Date: 2013-12-31 10:43:19 UTC

Added comments

Author: Timour Katchaounov
Revision Date: 2013-11-19 09:29:09 UTC

MDEV-4170 Dynamic pushdown of subquery predicates
- fixed an error where the left-most pushdown tab was the left-most tab in a nest, instead of the tab where the condition can pushed the earliest
- fixed errors in the cost computation, mainly when the optimizer looks for optimal join order of the outer query,
  its subqueries may not be optimized yet, and their cost may not be known.
- fixed several valgrind errors

Author: Sergey Vojtovich
Revision Date: 2013-11-18 11:48:01 UTC

MDEV-5182 - build of 10.0.4/r3863 fails @ 'cmake' with
            -DINSTALL_SYSCONFDIR/-DDEFAULT_SYSCONFDIR specified

The reason for a bug is in support-files/CMakeLists.txt that tries to
install files in INSTALL_SYSCONF2DIR, without checking whether this
variable is actually defined.

Normally INSTALL_SYSCONF2DIR is always defined if INSTALL_SYSCONFDIR is
defined, and support-files/CMakeLists.txt assumes that. But when one
specifies INSTALL_SYSCONFDIR manually on the command line, this
assumption might be broken.

Author: Oleksandr "Sanja" Byelkin
Revision Date: 2013-10-28 18:04:04 UTC

yet another try to trigger duildbot

Author: Timour Katchaounov
Revision Date: 2013-10-18 09:09:35 UTC

Removed extra empty line

Author: Sergei Golubchik
Revision Date: 2013-09-04 12:54:41 UTC

different approach for generating file-id's
that creates unique ids for all files and allows
to merge many repositories into one.

incompatible with the old file-id == file-path approach,
and with old branched (from git) repositories.

Author: Sergei Golubchik
Revision Date: 2013-07-02 09:39:41 UTC

Mark tokudb plugin as "Alpha" in MariaDB.

It's reasonably stable on itself, but MariaDB integration
within 5.5 series is still rather new.

Author: Vladislav Vaintroub
Revision Date: 2013-06-17 17:18:14 UTC

MDEV-4503 : Installation fails if TEMP directory contains "~" subdirectory.

Remove special handling for ~ in the middle of the path in cleanup_dir_name() - according to Monty, this was ancient code that tried to emulate Emacs behavior

Author: Oleksandr "Sanja" Byelkin
Revision Date: 2013-06-14 18:55:58 UTC

Fix of stmt_da / m_stamt_da.

Work around for alolocated memory counter.

Author: Vladislav Vaintroub
Revision Date: 2013-05-24 22:02:13 UTC

MDEV-4553 - NetBSD fixes

Author: Sergey Petrunia
Revision Date: 2013-05-23 16:25:20 UTC

Added comments

Author: Sergey Petrunia
Revision Date: 2013-05-16 14:34:40 UTC

MDEV-4201: LevelDB Storage Engine MS2
- Add @@leveldb_max_row_locks variable, limit # of locks a transaction may hold

Author: Igor Babaev
Revision Date: 2013-04-26 02:05:30 UTC

Fixed bug mdev-4428.
Do not try to estimate the selectivity of a column range if min/max
values for the column are not provided and there is no supporting index.

Author: Vladislav Vaintroub
Revision Date: 2013-04-03 21:42:41 UTC

MDEV-4356

Author: Lixun Peng (P.Linux)
Revision Date: 2013-04-02 11:45:28 UTC

FLASHBACK FEATURE

How to use this feature?
I added several new arguments for mysqlbinlog: (binlog_format must be ROW)
--flashback (-B), it will let mysqlbinlog to work on FLASHBACK mode.
--table (-T), it likes -d, but this argument is for tables.
--review, it will let mysqlbinlog print the SQL for reviewing. Reviewing feature will create a new "review" table to record the data that will be modified by
FLASHBACK feature. If you aren't special the --review-dbname/tablename, "review" table will created on current DB, and the table name will be "__"+original_table_name. And for getting the original table struct, mysqlbinlog need to connect mysql, so --user/--host/--password is necessary if needed.
--review-dbname, the DB that you want to store the review table.
--review-tablename, the TABLE that you want to store the original data before modified. Only if you set -T, this argument is useful.

For example:
I have a table "t" in database "test", we can compare the output with --flashback and without.
#client/mysqlbinlog /data/mysqldata_10.0/binlog/mysql-bin.000001 -vv -d test -T t --start-datetime="2013-03-27 14:54:00" > /tmp/1.sql
#client/mysqlbinlog /data/mysqldata_10.0/binlog/mysql-bin.000001 -vv -uroot -d test -T t --start-datetime="2013-03-27 14:54:00" -B --review > /tmp/2.sql

Then, importing the flashback output can flashback database/table to the special time.

How to implement Flashback:
1. mysqlbinlog tool can parse the binlog files and print them, so we can use the most of code in mysqlbinlog.
2. Changing the event type (INSERT -> DELETE; DELETE -> INSERT).
3. Exchanging the SET/WHERE part in UPDATE event (UPDATE table SET x=1 WHERE y=2 -> UPDATE table SET y=2 WHERE x=1).
4. Invert the events in binlog files, from end to beginning (binlog: e1,e2,e3... -> flashback_log: en...e3,e2,e1).

Author: Oleksandr "Sanja" Byelkin
Revision Date: 2013-03-04 11:38:05 UTC

Check posibility to allow exists-to-in in SELECT list and deep inside WHERE clause.

Author: Timour Katchaounov
Revision Date: 2012-12-21 09:32:49 UTC

MDEV-537 Make multi-column non-top level subqueries to be executed via index (index/unique subquery)
         instead of single_select_engine

This task changes the IN-EXISTS rewrite for multi-column subqueries "(a, b) IN (select b, c ...)"
to work in the same way as for single-column subqueries "a IN (select b ...) with respect to the
injection of NULL-rejecting predicates.

More specifically, the method Item_in_subselect::create_row_in_to_exists_cond() adds
Item_is_not_null_test and Item_func_trig_cond only if the left IN operand can be NULL.
Not having these predicates when not necessary, makes it possible to rewrite the subquery
into a "unique_subquery" or "index_subquery" when there is a suitable index on the only
subquery table.

Author: Vladislav Vaintroub
Revision Date: 2012-12-19 20:40:14 UTC

Add Fusion-io support (Percona's patch)

Author: Igor Babaev
Revision Date: 2012-12-19 06:45:15 UTC

The patch for the task mdev-539.
The patch lifts the limitation of the current implementation
of ALTER TABLE that does not allow to build unique/primary
indexes by sort for MyISAM engine.

Author: Vladislav Vaintroub
Revision Date: 2012-12-18 19:35:48 UTC

Add support for fusionio (via PErconas patch)

Author: Oleksandr "Sanja" Byelkin
Revision Date: 2011-10-04 11:14:59 UTC

open_binary_frm() decomposed an methods of TABLE_SHARE to allow engine to create TABLE_SHARE.

utype and geometry_type moved out of Field.

Author: Oleksandr "Sanja" Byelkin
Revision Date: 2012-12-10 10:51:07 UTC

MDEV-3906 fix. Server crashes in Dependency_marker::visit_field on 2nd execution of PS with exists_to_in and NOT EXISTS subquery.

The problem is that in case of NOT we put IS NOT NULL befoe Item_in_optimizer with reference on its left expression. On the first execution the left expression is already "fixed". But on the second IS NOT NULL fix_field() called before and so it is not fix fielded.

Fix is to allow direct references to call fixfields of its arguments if it is needed.

Author: Vladislav Vaintroub
Revision Date: 2012-12-02 02:21:39 UTC

remove drizzle related time packing routines, remove checking for Java5. This driver does not work with java5

Author: Alexey Botchkov
Revision Date: 2012-11-30 13:10:15 UTC

'lighter' ST_ConvexHull implemented.

Author: Oleksandr "Sanja" Byelkin
Revision Date: 2012-11-20 13:11:22 UTC

MDEV-3862 Lift limitation for merging VIEWS with Subqueries in SELECT list.

Author: Oleksandr "Sanja" Byelkin
Revision Date: 2012-11-19 12:16:04 UTC

Cassandra SE & Dynamic columns with names merge to 10.0

Author: Lixun Peng (P.Linux)
Revision Date: 2012-10-23 06:35:18 UTC

Automatic merge

Author: Michael Widenius
Revision Date: 2012-10-03 21:09:32 UTC

Fixed bug when using positional parameters with length

Author: Oleksandr "Sanja" Byelkin
Revision Date: 2012-09-24 14:12:18 UTC

fix string charset conversion

Author: Sergey Petrunia
Revision Date: 2012-09-20 17:52:24 UTC

Parallel load fixes

Author: Sergey Petrunia
Revision Date: 2012-09-03 15:11:24 UTC

MDEV-406: EXPLAIN ANALYZE
- First code, it is possible to get the data for joins/unions
- Numbers for join buffering are likely to be incorrect
- Same for subqueries (what should 'loops' show?)

Author: Kristian Nielsen
Revision Date: 2012-08-27 13:07:58 UTC

MDEV-381: fdatasync() does not correctly flush growing binlog file.

When we append data to the binlog file, we use fdatasync() to ensure
the data gets to disk so that crash recovery can work.

Unfortunately there seems to be a bug in ext3/ext4 on linux, so that
fdatasync() does not correctly sync all data when the size of a file
is increased. This causes crash recovery to not work correctly (it
loses transactions from the binlog).

As a work-around, use fsync() for the binlog, not fdatasync(). Since
we are increasing the file size, (correct) fdatasync() will most
likely not be faster than fsync() on any file system, and fsync()
does work correctly on ext3/ext4. This avoids the need to try to
detect if we are running on buggy ext3/ext4.

Author: Timour Katchaounov
Revision Date: 2012-08-09 09:07:36 UTC

MDEV-83 Cost-based choice for the pushdown of expensive predicates to joined tables

Commit of current work state. The commit implements a prototype of the task, where
the main things missing are:
- handling of semi-join nests (predicates cannot be moved outside of semi-join nests), and
- outer join restrictions on predicate moves

Author: jani
Revision Date: 2012-07-23 07:56:30 UTC

New version of mysqld_multi

Author: Kristian Nielsen
Revision Date: 2012-06-22 10:20:29 UTC

MDEV-232: Remove one fsync() from commit phase.

Introduce a new storage engine API method commit_checkpoint_request().
This is used to replace the fsync() at the end of every storage engine
commit with a single fsync() when a binlog is rotated.

Binlog rotation is now done during group commit instead of being
delayed until unlog(), removing some server stall and avoiding an
expensive lock/unlock of LOCK_log inside unlog().

Author: Kristian Nielsen
Revision Date: 2012-06-21 16:24:42 UTC

MDEV-359: Fix another case where switch-off semisync could cause a race that ended with server crash.

Author: Jelmer Vernooij
Revision Date: 2012-05-21 11:52:58 UTC

Merge fix for sending emails after refactoring from Bob Tanner.

Author: Sergei Golubchik
Revision Date: 2012-04-27 14:16:05 UTC

mariadb-server-dev package with private server headers

Author: Kazuhiko
Revision Date: 2012-04-27 12:12:19 UTC

update storage/mroonga and storage/mroonga/groonga and add missing files.

Author: Kazuhiko
Revision Date: 2012-04-26 11:46:06 UTC

update storage/mroonga.

Author: Oleksandr "Sanja" Byelkin
Revision Date: 2012-04-24 07:24:30 UTC

yet another try to build

Author: Davi Arnaut
Revision Date: 2012-03-19 22:00:23 UTC

Make Replication filter settings dynamic.

Make the slave options --replicate-* dynamic variables so that these
options can be changed dynamically while the server is running,
which enables users to modify replication filtering rules without
having to stop and restart the server.

This is accomplished by just requiring that the slave threads are
stopped when these options are set dynamically. Since filtering
rules are only used by the SQL slave thread, setting them while the
thread is not running avoids the need for locking.

Author: Igor Babaev
Revision Date: 2012-03-02 00:02:25 UTC

Merge

Author: Sergey Petrunia
Revision Date: 2012-03-01 20:33:11 UTC

Merge 5.3 -> 5.3-optimizer-debugging

Author: Oleksandr "Sanja" Byelkin
Revision Date: 2012-02-07 13:01:11 UTC

more cache statistic + additional check

Author: Kristian Nielsen
Revision Date: 2011-12-08 11:05:03 UTC

test commit - test if buildbot survives 8-bit chars: rødgrød med fløde.

Author: Sergey Petrunia
Revision Date: 2011-11-19 11:57:11 UTC

Safety: make valgrind catch access to join->positions[] after join optimization
is done.

Author: Sergei Golubchik
Revision Date: 2011-10-27 11:14:52 UTC

rewrite to use dialog plugin.
simplify configure.ac.
support builds from within 5.5 tree.
fix make distcheck target.