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