summaryrefslogtreecommitdiff
path: root/mysql-test/suite/galera/r
diff options
context:
space:
mode:
authorNirbhay Choubey <nirbhay@mariadb.com>2016-10-26 12:06:54 -0400
committerNirbhay Choubey <nirbhay@mariadb.com>2016-11-07 11:53:59 -0500
commit9b6bd3f17994175e1a67b2b8d3bedcb1d738c2a4 (patch)
treede76a69a9ec855c53e4d089828a2e06f3afe4bab /mysql-test/suite/galera/r
parentdb95beb365bde1d487a23de95eab118a3eb0e5ef (diff)
downloadmariadb-git-9b6bd3f17994175e1a67b2b8d3bedcb1d738c2a4.tar.gz
MDEV-11149: wsrep_replicate_mysaim: DML fails when binlog checksum enabled
During total-order replication, Query_log_event's checksum_alg should be explicitly set to the current binlog_checksum as it is not set for DML queries. Note: wsrep_replicate_myisam enables replication of DMLs on MyISAM tables using TOI.
Diffstat (limited to 'mysql-test/suite/galera/r')
-rw-r--r--mysql-test/suite/galera/r/galera_binlog_checksum.result16
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/suite/galera/r/galera_binlog_checksum.result b/mysql-test/suite/galera/r/galera_binlog_checksum.result
index b0ea2293119..7303aa61122 100644
--- a/mysql-test/suite/galera/r/galera_binlog_checksum.result
+++ b/mysql-test/suite/galera/r/galera_binlog_checksum.result
@@ -11,3 +11,19 @@ SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 2;
COUNT(*) = 1
1
DROP TABLE t1;
+#
+# MDEV-11149: wsrep_replicate_mysaim: DML fails when binlog checksum
+# enabled
+#
+connection node_1;
+SET @@global.wsrep_replicate_myisam=1;
+CREATE TABLE t1 (i INT) ENGINE=MYISAM;
+INSERT INTO t1 VALUES(1);
+connection node_2;
+SELECT * FROM t1;
+i
+1
+connection node_1;
+DROP TABLE t1;
+SET @@global.wsrep_replicate_myisam=0;
+# End of tests.