EVOLUTION-MANAGER

Edit File: binlog_killed_simulate.test

-- source include/have_debug.inc
-- source include/have_binlog_format_statement.inc
-- source include/binlog_start_pos.inc
#
# bug#27571 asynchronous setting mysql_$query()'s local error and 
#           Query_log_event::error_code
#

#
#  Checking that killing upon successful row-loop does not affect binlogging
#

create table t1  (a int) engine=MyISAM;
insert into t1 set a=1;
reset master;

update t1 set a=2 /* will be "killed" after work has been done */;

# a proof the query is binlogged with no error
let datadir= `select @@datadir`;
--exec $MYSQL_BINLOG --force-if-open --start-position=$binlog_start_pos $datadir/master-bin.000001 > $MYSQLTEST_VARDIR/tmp/binlog_killed_bug27571.binlog
--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
eval set @a:=load_file("$MYSQLTEST_VARDIR/tmp/binlog_killed_bug27571.binlog");
--replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
select @a like '%#%error_code=0%' /* must return 1 as query completed before got killed*/;

# cleanup for the sub-case
remove_file $MYSQLTEST_VARDIR/tmp/binlog_killed_bug27571.binlog;

#
#  Checking that killing inside of row-loop for LOAD DATA into
#  non-transactional table affects binlogging
#

create table t2 (a int, b int) ENGINE=MyISAM;
reset master;
--error ER_QUERY_INTERRUPTED
load data infile '../../std_data/rpl_loaddata.dat' into table t2 /* will be "killed" in the middle */;

# a proof the query is binlogged with an error
--let binlog_load_data= query_get_value(SHOW BINLOG EVENTS, Pos, 5)
--let binlog_end=       query_get_value(SHOW BINLOG EVENTS, Pos, 6)
source include/show_binlog_events.inc;

--mkdir $MYSQLTEST_VARDIR/tmp/binlog_killed_bug27571
--exec $MYSQL_BINLOG --local-load=$MYSQLTEST_VARDIR/tmp/binlog_killed_bug27571 --force-if-open --start-position=$binlog_load_data --stop-position=$binlog_end $datadir/master-bin.000001 > $MYSQLTEST_VARDIR/tmp/binlog_killed_bug27571.binlog

--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
eval set @a:=load_file("$MYSQLTEST_VARDIR/tmp/binlog_killed_bug27571.binlog");
--replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
select @a like '%#%error_code=0%' /* must return 0 to mean the killed query is in */;

# cleanup for the sub-case
remove_file $MYSQLTEST_VARDIR/tmp/binlog_killed_bug27571.binlog;

--remove_files_wildcard $MYSQLTEST_VARDIR/tmp/binlog_killed_bug27571 *
--rmdir $MYSQLTEST_VARDIR/tmp/binlog_killed_bug27571

drop table t1,t2;

--echo end of the tests