Merge lp:~sergei.glushchenko/percona-server/5.6-ST39577-ps-bug1070255 into lp:percona-server/5.6

[Sergei Glushchenko]

http://jenkins.percona.com/view/PS%205.6/job/percona-server-5.6-param/552/

prev MP https://code.launchpad.net/~sergei.glushchenko/percona-server/5.6-ST39577-ps-bug1289754/+merge/211194

removed have_innodb.inc, changed have_debug_sync.inc to have_debug.inc, added have_binlog_format_row.inc

[Laurynas Biveinis (laurynas-biveinis)]

review: Approve

=== added file 'mysql-test/suite/rpl/r/rpl_percona_bug1070255.result'
--- mysql-test/suite/rpl/r/rpl_percona_bug1070255.result	1970-01-01 00:00:00 +0000
+++ mysql-test/suite/rpl/r/rpl_percona_bug1070255.result	2014-03-17 11:03:19 +0000
@@ -0,0 +1,38 @@
+include/master-slave.inc
+Warnings:
+Note	####	Sending passwords in plain text without SSL/TLS is extremely insecure.
+Note	####	Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
+[connection master]
+set global DEBUG='+d,dbug_table_map_id_500';
+CREATE TABLE t2 (a INT PRIMARY KEY, b VARCHAR(20));
+INSERT INTO t2 VALUES(1, '1');
+set global DEBUG='+d,dbug_table_map_id_4B_UINT_MAX+501';
+CREATE TABLE t3 (a INT PRIMARY KEY, b VARCHAR(20));
+INSERT INTO t3 VALUES(1, '1');
+set global DEBUG='+d,dbug_table_map_id_6B_UINT_MAX';
+CREATE TABLE t4 (a INT PRIMARY KEY, b VARCHAR(20));
+INSERT INTO t4 VALUES(1, '1');
+UPDATE t2, t3, t4 SET t2.b='tt2', t3.b='tt3', t4.b='tt4' WHERE t2.a=t3.a and t2.a=t4.a;
+SELECT * FROM t2;
+a	b
+1	tt2
+SELECT * FROM t3;
+a	b
+1	tt3
+SELECT * FROM t4;
+a	b
+1	tt4
+DELETE FROM t2;
+DELETE FROM t3;
+DELETE FROM t4;
+SELECT * FROM t2;
+a	b
+SELECT * FROM t3;
+a	b
+SELECT * FROM t4;
+a	b
+DROP TABLE t2;
+DROP TABLE t3;
+DROP TABLE t4;
+set global DEBUG='';
+include/rpl_end.inc
 
=== added file 'mysql-test/suite/rpl/t/rpl_percona_bug1070255.test'
--- mysql-test/suite/rpl/t/rpl_percona_bug1070255.test	1970-01-01 00:00:00 +0000
+++ mysql-test/suite/rpl/t/rpl_percona_bug1070255.test	2014-03-17 11:03:19 +0000
@@ -0,0 +1,51 @@
+#
+# Bug 1070255: overflow caused replication sql thread failed to execute events
+#
+
+source include/have_debug.inc;
+source include/have_binlog_format_row.inc;
+source include/master-slave.inc;
+
+connection master;
+
+set global DEBUG='+d,dbug_table_map_id_500';
+CREATE TABLE t2 (a INT PRIMARY KEY, b VARCHAR(20));
+INSERT INTO t2 VALUES(1, '1');
+
+set global DEBUG='+d,dbug_table_map_id_4B_UINT_MAX+501';
+CREATE TABLE t3 (a INT PRIMARY KEY, b VARCHAR(20));
+INSERT INTO t3 VALUES(1, '1');
+
+set global DEBUG='+d,dbug_table_map_id_6B_UINT_MAX';
+CREATE TABLE t4 (a INT PRIMARY KEY, b VARCHAR(20));
+INSERT INTO t4 VALUES(1, '1');
+
+UPDATE t2, t3, t4 SET t2.b='tt2', t3.b='tt3', t4.b='tt4' WHERE t2.a=t3.a and t2.a=t4.a;
+
+sync_slave_with_master;
+
+SELECT * FROM t2;
+SELECT * FROM t3;
+SELECT * FROM t4;
+
+connection master;
+
+DELETE FROM t2;
+DELETE FROM t3;
+DELETE FROM t4;
+
+sync_slave_with_master;
+
+SELECT * FROM t2;
+SELECT * FROM t3;
+SELECT * FROM t4;
+
+connection master;
+
+DROP TABLE t2;
+DROP TABLE t3;
+DROP TABLE t4;
+
+set global DEBUG='';
+
+--source include/rpl_end.inc