Debian Codegraph @

mysql-test/suite/binlog/t/binlog_start_comment.test

raw
1
2 # Test case for bug#32205 Replaying statements from mysqlbinlog fails
3 # with a syntax error, replicates fine
4
5 source include/have_log_bin.inc;
6 source include/have_local_infile.inc;
7
8 reset master;
9 --disable_warnings
10 drop table if exists t1,t2;
11 --enable_warnings
12 create table t1 (word varchar(20)) -- create table t1;
13 create table t2 (word varchar(20)) -- create table t2;
14 load data infile '../../std_data/words.dat' into table t1 -- load data to t1;
15 insert into t2 values ("Ada");
16 flush logs;
17 select * from t2;
18 let $MYSQLD_DATADIR= `select @@datadir`;
19 --exec $MYSQL_BINLOG --local-load=$MYSQLTEST_VARDIR/tmp/ $MYSQLD_DATADIR/binlog.000001 > $MYSQLTEST_VARDIR/tmp/binlog_start_comment.binlog
20 # With gtid-mode=on we need purge gtid_executed, if not transactions
21 # replayed through mysqlbinlog will be skipped.
22 reset master;
23 --exec $MYSQL --local-infile=1 < $MYSQLTEST_VARDIR/tmp/binlog_start_comment.binlog
24 flush logs;
25 select * from t2;
26
27 # clean up
28 drop table t1,t2;
29 remove_file $MYSQLTEST_VARDIR/tmp/binlog_start_comment.binlog;
30 remove_files_wildcard $MYSQLTEST_VARDIR/tmp SQL_LOAD_MB*;