1 files changed, 61 insertions, 0 deletions
diff --git a/mysql-test/suite/binlog/t/binlog_killed_simulate.test b/mysql-test/suite/binlog/t/binlog_killed_simulate.test
new file mode 100644
index 00000000..20f51721
--- /dev/null
+++ b/mysql-test/suite/binlog/t/binlog_killed_simulate.test
@@ -0,0 +1,61 @@
+-- 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