Debian Codegraph @

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

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