1source include/have_innodb.inc;
2source include/have_log_bin.inc;
3
4#
5# WL#2540 replication event checksum
6#
7# Objectives of the test are:
8# to demo binlog events with CRC32 checksum in them and
9# to prove show binlog events and mysqlbinlog are capable to handle
10# the checksum.
11#
12
13set @save_binlog_checksum = @@global.binlog_checksum;
14set @save_master_verify_checksum = @@global.master_verify_checksum;
15set @@global.binlog_checksum = CRC32;
16set @@global.master_verify_checksum = 1;
17let $MYSQLD_DATADIR= `select @@datadir`;
18
19reset master;
20--echo must be master-bin.000001
21--source include/show_binary_logs.inc
22
23create table t1 (a int);
24flush logs;
25copy_file $MYSQLD_DATADIR/master-bin.000001 $MYSQLD_DATADIR/master-bin.saved;
26drop table t1;
27
28# Reset GTIDs
29RESET MASTER;
30
31--exec $MYSQL_BINLOG -c $MYSQLD_DATADIR/master-bin.saved | $MYSQL
32remove_file $MYSQLD_DATADIR/master-bin.saved;
33--source include/show_binlog_events.inc
34show tables;
35
36# clean-up
37
38drop table t1;
39set @@global.binlog_checksum = @save_binlog_checksum;
40set @@global.master_verify_checksum = @save_master_verify_checksum;
41
42--echo End of the tests
43