Gecko [ www.jdcpatala.org ]

Name	Size	Permission
binlog_anonymous_ownership.tes...	11.78 KB	-rw-r--r--
binlog_bug23533.test	1.48 KB	-rw-r--r--
binlog_bug36391-master.opt	32 B	-rw-r--r--
binlog_bug36391.test	1.18 KB	-rw-r--r--
binlog_cache_write_failure-mas...	97 B	-rw-r--r--
binlog_cache_write_failure.tes...	5.4 KB	-rw-r--r--
binlog_check_flush_log_asserti...	1.68 KB	-rw-r--r--
binlog_checksum.test	1.08 KB	-rw-r--r--
binlog_crash_safe_master_check...	51 B	-rw-r--r--
binlog_crash_safe_master_check...	2.6 KB	-rw-r--r--
binlog_database.test	370 B	-rw-r--r--
binlog_delete_and_flush_index....	3.53 KB	-rw-r--r--
binlog_dmls_on_tmp_tables_read...	2.38 KB	-rw-r--r--
binlog_drop_if_exists.test	3.47 KB	-rw-r--r--
binlog_drop_temp_table_on_disc...	2 KB	-rw-r--r--
binlog_drop_temp_table_on_disc...	1.75 KB	-rw-r--r--
binlog_enforce_gtid_consistenc...	379 B	-rw-r--r--
binlog_enforce_gtid_consistenc...	378 B	-rw-r--r--
binlog_enforce_gtid_consistenc...	1.46 KB	-rw-r--r--
binlog_enforce_gtid_consistenc...	3.75 KB	-rw-r--r--
binlog_enforce_gtid_consistenc...	314 B	-rw-r--r--
binlog_enforce_gtid_consistenc...	313 B	-rw-r--r--
binlog_enforce_gtid_consistenc...	739 B	-rw-r--r--
binlog_enforce_gtid_consistenc...	409 B	-rw-r--r--
binlog_error_action-master.opt	88 B	-rw-r--r--
binlog_error_action.test	17.12 KB	-rw-r--r--
binlog_flush_logs_error.test	1.72 KB	-rw-r--r--
binlog_foreign_key_parent_tabl...	44 B	-rw-r--r--
binlog_foreign_key_parent_tabl...	1.08 KB	-rw-r--r--
binlog_format_switch_in_tmp_ta...	2.77 KB	-rw-r--r--
binlog_grant.test	1.83 KB	-rw-r--r--
binlog_grant_alter_user-master...	32 B	-rw-r--r--
binlog_grant_alter_user.test	39.59 KB	-rw-r--r--
binlog_group_commit_flush_cras...	51 B	-rw-r--r--
binlog_group_commit_flush_cras...	2.17 KB	-rw-r--r--
binlog_group_commit_gtid_order...	4.6 KB	-rw-r--r--
binlog_group_commit_indefinite...	1.51 KB	-rw-r--r--
binlog_group_commit_sync_delay...	1.84 KB	-rw-r--r--
binlog_group_commit_sync_delay...	1.23 KB	-rw-r--r--
binlog_group_commit_sync_no_de...	3.72 KB	-rw-r--r--
binlog_gtid_automatic_using_ro...	2.02 KB	-rw-r--r--
binlog_gtid_cache-master.opt	117 B	-rw-r--r--
binlog_gtid_cache.test	635 B	-rw-r--r--
binlog_gtid_errors-master.opt	149 B	-rw-r--r--
binlog_gtid_errors.test	9.1 KB	-rw-r--r--
binlog_gtid_exhausted-master.o...	77 B	-rw-r--r--
binlog_gtid_exhausted.test	3.3 KB	-rw-r--r--
binlog_gtid_implicit_commit.te...	121 B	-rw-r--r--
binlog_gtid_innodb.test	132 B	-rw-r--r--
binlog_gtid_mix_ok_packet_all_...	131 B	-rw-r--r--
binlog_gtid_mix_ok_packet_all_...	1.63 KB	-rw-r--r--
binlog_gtid_mix_response_packe...	99 B	-rw-r--r--
binlog_gtid_mix_response_packe...	1.82 KB	-rw-r--r--
binlog_gtid_mode_set_gtid_next...	4.66 KB	-rw-r--r--
binlog_gtid_mysqlbinlog_row.te...	197 B	-rw-r--r--
binlog_gtid_mysqlbinlog_row_in...	707 B	-rw-r--r--
binlog_gtid_mysqlbinlog_row_my...	661 B	-rw-r--r--
binlog_gtid_mysqlbinlog_start_...	444 B	-rw-r--r--
binlog_gtid_mysqldump.test	2.09 KB	-rw-r--r--
binlog_gtid_next_begin_caused_...	948 B	-rw-r--r--
binlog_gtid_next_partially_fai...	2.93 KB	-rw-r--r--
binlog_gtid_next_partially_fai...	9.45 KB	-rw-r--r--
binlog_gtid_next_single_stmt_t...	968 B	-rw-r--r--
binlog_gtid_next_temporary_tab...	2.73 KB	-rw-r--r--
binlog_gtid_next_xa.test	241 B	-rw-r--r--
binlog_gtid_ps_reprepare.test	6.56 KB	-rw-r--r--
binlog_gtid_purge_binlog_at_st...	3.72 KB	-rw-r--r--
binlog_gtid_rbr_only_flag.test	2.51 KB	-rw-r--r--
binlog_gtid_reset_consistency_...	2.61 KB	-rw-r--r--
binlog_gtid_row_ctype_ucs.test	265 B	-rw-r--r--
binlog_gtid_simple_recovery.te...	6 KB	-rw-r--r--
binlog_gtid_state_update_deadl...	2.62 KB	-rw-r--r--
binlog_gtid_stm_ctype_ucs.test	280 B	-rw-r--r--
binlog_gtid_unknown_xid.test	5.39 KB	-rw-r--r--
binlog_gtid_utils.test	3.56 KB	-rw-r--r--
binlog_gtids_table_gcov.test	2.86 KB	-rw-r--r--
binlog_implicit_commit.test	290 B	-rw-r--r--
binlog_incident.test	1.39 KB	-rw-r--r--
binlog_incident_ignore-master....	24 B	-rw-r--r--
binlog_incident_ignore.test	152 B	-rw-r--r--
binlog_index-master.opt	16 B	-rw-r--r--
binlog_index.test	16.86 KB	-rw-r--r--
binlog_innodb-master.opt	25 B	-rw-r--r--
binlog_innodb.test	139 B	-rw-r--r--
binlog_innodb_row.test	2.72 KB	-rw-r--r--
binlog_killed.test	9.71 KB	-rw-r--r--
binlog_killed_simulate-master....	39 B	-rw-r--r--
binlog_killed_simulate.test	2.7 KB	-rw-r--r--
binlog_max_extension.test	2.61 KB	-rw-r--r--
binlog_max_flush_queue_time_wa...	32 B	-rw-r--r--
binlog_max_flush_queue_time_wa...	850 B	-rw-r--r--
binlog_mixed_cache_stat.test	277 B	-rw-r--r--
binlog_mixed_load_data.test	535 B	-rw-r--r--
binlog_mts_logical_clock.test	2.35 KB	-rw-r--r--
binlog_mts_logical_clock_gtid....	318 B	-rw-r--r--
binlog_mysqlbinlog-cp932-maste...	23 B	-rw-r--r--
binlog_mysqlbinlog-cp932.test	1.11 KB	-rw-r--r--
binlog_mysqlbinlog_base64.test	2.64 KB	-rw-r--r--
binlog_mysqlbinlog_concat.test	4.28 KB	-rw-r--r--
binlog_mysqlbinlog_filter.test	2.07 KB	-rw-r--r--
binlog_mysqlbinlog_intvar.test	1.59 KB	-rw-r--r--
binlog_mysqlbinlog_raw.test	3.53 KB	-rw-r--r--
binlog_mysqlbinlog_rewrite_db....	6.58 KB	-rw-r--r--
binlog_mysqlbinlog_row.test	204 B	-rw-r--r--
binlog_mysqlbinlog_row_innodb....	714 B	-rw-r--r--
binlog_mysqlbinlog_row_myisam....	669 B	-rw-r--r--
binlog_mysqlbinlog_row_trans.t...	4.07 KB	-rw-r--r--
binlog_mysqlbinlog_start_stop....	452 B	-rw-r--r--
binlog_mysqlbinlog_start_stop_...	1.95 KB	-rw-r--r--
binlog_nogtid_mix_response_pac...	480 B	-rw-r--r--
binlog_noop_dml_with_readonly....	2.4 KB	-rw-r--r--
binlog_old_versions.test	5.22 KB	-rw-r--r--
binlog_purge_binary_logs_stall...	70 B	-rw-r--r--
binlog_purge_binary_logs_stall...	1.36 KB	-rw-r--r--
binlog_purge_binary_logs_to.te...	3.45 KB	-rw-r--r--
binlog_query_filter_rules-mast...	40 B	-rw-r--r--
binlog_query_filter_rules.test	855 B	-rw-r--r--
binlog_rbr_only_savepoint.test	2.83 KB	-rw-r--r--
binlog_reset_connection_not_re...	3.49 KB	-rw-r--r--
binlog_reset_master.test	996 B	-rw-r--r--
binlog_rewrite.test	2.99 KB	-rw-r--r--
binlog_rewrite_db_noleak.test	2.65 KB	-rw-r--r--
binlog_rewrite_order.test	1.07 KB	-rw-r--r--
binlog_rewrite_suppress_use.te...	2.25 KB	-rw-r--r--
binlog_rotate_bgc_sync.test	3.37 KB	-rw-r--r--
binlog_rotate_deadlock-master....	181 B	-rw-r--r--
binlog_rotate_deadlock.test	1.75 KB	-rw-r--r--
binlog_row_binlog-master.opt	55 B	-rw-r--r--
binlog_row_binlog.test	783 B	-rw-r--r--
binlog_row_cache_stat.test	274 B	-rw-r--r--
binlog_row_create_select_crash...	1.35 KB	-rw-r--r--
binlog_row_ctype_cp932.test	268 B	-rw-r--r--
binlog_row_ctype_ucs.test	272 B	-rw-r--r--
binlog_row_delete_all_rows.tes...	688 B	-rw-r--r--
binlog_row_drop_tbl.test	215 B	-rw-r--r--
binlog_row_drop_tmp_tbl.test	233 B	-rw-r--r--
binlog_row_innodb_stat-master....	26 B	-rw-r--r--
binlog_row_insert_select.test	708 B	-rw-r--r--
binlog_row_kill_create_select....	845 B	-rw-r--r--
binlog_row_mix_innodb_myisam-m...	97 B	-rw-r--r--
binlog_row_mix_innodb_myisam.t...	585 B	-rw-r--r--
binlog_row_mysqlbinlog_db_filt...	4.36 KB	-rw-r--r--
binlog_row_mysqlbinlog_verbose...	5.59 KB	-rw-r--r--
binlog_row_query_log_events.te...	942 B	-rw-r--r--
binlog_server_id.test	794 B	-rw-r--r--
binlog_server_start_options-ma...	54 B	-rw-r--r--
binlog_server_start_options.te...	1.14 KB	-rw-r--r--
binlog_set_gtid_mode_ongoing_t...	6.96 KB	-rw-r--r--
binlog_set_trans_dependency_de...	2.24 KB	-rw-r--r--
binlog_sf.test	2.67 KB	-rw-r--r--
binlog_shutdown_hang.test	1.14 KB	-rw-r--r--
binlog_simulate_crash_and_erro...	4.24 KB	-rw-r--r--
binlog_spurious_ddl_errors-mas...	20 B	-rw-r--r--
binlog_spurious_ddl_errors.tes...	4.16 KB	-rw-r--r--
binlog_sql_mode.test	4.75 KB	-rw-r--r--
binlog_start_comment.test	1.01 KB	-rw-r--r--
binlog_start_slave_heartbeat-s...	16 B	-rw-r--r--
binlog_start_slave_heartbeat.t...	1.33 KB	-rw-r--r--
binlog_stm_binlog-master.opt	55 B	-rw-r--r--
binlog_stm_binlog.test	741 B	-rw-r--r--
binlog_stm_blackhole.test	456 B	-rw-r--r--
binlog_stm_cache_stat.test	280 B	-rw-r--r--
binlog_stm_ctype_cp932.test	318 B	-rw-r--r--
binlog_stm_ctype_ucs.test	287 B	-rw-r--r--
binlog_stm_delete_all_rows.tes...	712 B	-rw-r--r--
binlog_stm_do_db-master.opt	38 B	-rw-r--r--
binlog_stm_do_db.test	2.8 KB	-rw-r--r--
binlog_stm_drop_tbl.test	230 B	-rw-r--r--
binlog_stm_drop_tmp_tbl.test	248 B	-rw-r--r--
binlog_stm_innodb_stat-master....	26 B	-rw-r--r--
binlog_stm_insert_select.test	489 B	-rw-r--r--
binlog_stm_mix_innodb_myisam-m...	145 B	-rw-r--r--
binlog_stm_mix_innodb_myisam.t...	552 B	-rw-r--r--
binlog_stm_ps.test	939 B	-rw-r--r--
binlog_stm_row.test	3.38 KB	-rw-r--r--
binlog_stm_unsafe_warning-mast...	51 B	-rw-r--r--
binlog_stm_unsafe_warning.test	5.65 KB	-rw-r--r--
binlog_stm_user_variables.test	3.4 KB	-rw-r--r--
binlog_switch_inside_trans.tes...	7.63 KB	-rw-r--r--
binlog_temporary_tables_user_v...	1.14 KB	-rw-r--r--
binlog_tmp_table.test	4.53 KB	-rw-r--r--
binlog_transaction_dependency_...	90 B	-rw-r--r--
binlog_transaction_dependency_...	8.21 KB	-rw-r--r--
binlog_transaction_dependency_...	2.2 KB	-rw-r--r--
binlog_transaction_write_set_s...	44 B	-rw-r--r--
binlog_transaction_write_set_s...	1.98 KB	-rw-r--r--
binlog_transaction_write_set_s...	44 B	-rw-r--r--
binlog_transaction_write_set_s...	1.33 KB	-rw-r--r--
binlog_transaction_write_set_s...	44 B	-rw-r--r--
binlog_transaction_write_set_s...	1.21 KB	-rw-r--r--
binlog_transaction_write_set_s...	44 B	-rw-r--r--
binlog_transaction_write_set_s...	4.15 KB	-rw-r--r--
binlog_truncate_kill.test	1.96 KB	-rw-r--r--
binlog_truncate_myisam.test	348 B	-rw-r--r--
binlog_unsafe-master.opt	65 B	-rw-r--r--
binlog_unsafe.test	25.95 KB	-rw-r--r--
binlog_unsafe_stmt_capable_eng...	41 B	-rw-r--r--
binlog_unsafe_stmt_capable_eng...	12.55 KB	-rw-r--r--
binlog_use_gtid_skip.test	1.03 KB	-rw-r--r--
binlog_user_if_exists.test	9.22 KB	-rw-r--r--
binlog_variables_log_bin-maste...	16 B	-rw-r--r--
binlog_variables_log_bin.test	136 B	-rw-r--r--
binlog_variables_log_bin_index...	70 B	-rw-r--r--
binlog_variables_log_bin_index...	136 B	-rw-r--r--
binlog_variables_log_statement...	2.18 KB	-rw-r--r--
binlog_wait_for_executed_gtid_...	879 B	-rw-r--r--
binlog_wait_for_executed_gtid_...	2.45 KB	-rw-r--r--
binlog_wait_for_executed_gtid_...	633 B	-rw-r--r--
binlog_wait_for_executed_gtid_...	801 B	-rw-r--r--
binlog_write_error.test	2.7 KB	-rw-r--r--
binlog_writeset_history_protec...	3.06 KB	-rw-r--r--
binlog_wrong_last_committed.te...	3.07 KB	-rw-r--r--
binlog_xa_handling.test	3.69 KB	-rw-r--r--
binlog_xa_modify_gtid_executed...	2.93 KB	-rw-r--r--
binlog_xa_prepare_failure.test	2.05 KB	-rw-r--r--
binlog_xa_prepared_disconnect....	628 B	-rw-r--r--
binlog_xa_rollback_failure.tes...	1.4 KB	-rw-r--r--
binlog_xa_select_gtid_executed...	2.41 KB	-rw-r--r--
binlog_xa_trx_gtid_response_pa...	98 B	-rw-r--r--
binlog_xa_trx_gtid_response_pa...	1.1 KB	-rw-r--r--
binlog_xa_trx_split_across_bin...	2.51 KB	-rw-r--r--
disabled.def	404 B	-rw-r--r--
log_builtin_as_identified_by_p...	39 B	-rw-r--r--
log_builtin_as_identified_by_p...	128 B	-rw-r--r--
show_binlog_events_no_lock.tes...	2.27 KB	-rw-r--r--

Code Editor : binlog_killed.test

-- source include/have_innodb.inc
-- source include/have_myisam.inc
-- source include/have_binlog_format_statement.inc

call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");

# You cannot use `KILL' with the Embedded MySQL Server library,
# because the embedded server merely runs inside the threads of the host
# application. -- the docs

-- source include/not_embedded.inc

###
### bug#22725 : incorrect killed error in binlogged query
###

connect (con1, localhost, root,,);
connect (con2, localhost, root,,);

create table t1 (a int auto_increment, b int, PRIMARY KEY (a)) ENGINE=InnoDB;
create table t2 (a int auto_increment, b int, PRIMARY KEY (a)) ENGINE=MyISAM;
create table t3 (a int auto_increment, b int, PRIMARY KEY (a)) ENGINE=InnoDB;

#
# effective test for bug#22725
#

connection con1;
select get_lock("a", 20);

connection con2;
let $ID= `select connection_id()`;

#
# reset master does not reset binlogging on the embedded server.
# the test is not run on the embedded for reason of using KILL query.
# `reset master' problem is to be addressed by bug#15580 fixes.
#
reset master;
send insert into t2 values (null, null), (null, get_lock("a", 10));

connection con1;

--disable_abort_on_error
--disable_warnings

let $wait_condition=
  select count(*) = 1 from information_schema.processlist
  where info like "%insert into t2 values%" and state like 'User lock';
--source include/wait_condition_or_abort.inc

--replace_regex /[0-9]+/ID/
eval kill query $ID;

connection con2;
--error 0,ER_QUERY_INTERRUPTED
reap;
let $rows= `select count(*) from t2  /* must be 1 or 0 */`;
let $MYSQLD_DATADIR= `select @@datadir`;
--let $row_number=6
--let $binlog_killed_pos=query_get_value(SHOW BINLOG EVENTS, Pos, $row_number)
--let $binlog_killed_end_log_pos=query_get_value(SHOW BINLOG EVENTS, End_log_pos, $row_number)
--exec $MYSQL_BINLOG --force-if-open --start-position=$binlog_killed_pos --stop-position=$binlog_killed_end_log_pos $MYSQLD_DATADIR/master-bin.000001 > $MYSQLTEST_VARDIR/tmp/kill_query_calling_sp.binlog
--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
--disable_result_log
eval select
(@a:=load_file("$MYSQLTEST_VARDIR/tmp/kill_query_calling_sp.binlog"))
is not null;
--enable_result_log
--replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
let $error_code= `select @a like "%#%error_code=0%" /* must return 1 or 0*/`;
let $insert_binlogged= `select @a like "%insert into%" /* must return 1 or 0 */`;
eval set @result= $rows - $error_code - $insert_binlogged;

--enable_warnings
--enable_abort_on_error

if (`SELECT @result != 0`)
{
  --source include/show_rpl_debug_info.inc
  -- echo error_code:$error_code, insert:$insert_binlogged, rows:$rows
  SELECT * FROM t2;
  
  --die DIE
}

select @result /* must be zero either way */;

--remove_file $MYSQLTEST_VARDIR/tmp/kill_query_calling_sp.binlog
connection con1;
select RELEASE_LOCK("a");

#
# bug#27571 asynchronous setting mysql_`query`::error and Query_log_e::error_code
#

# checking that killing inside of select loops is safe as before
# killing after the loop can be only simulated - another test

delete from t1;
delete from t2;
insert into t1 values (1,1),(2,2);

#
# simple update
#
connection con1;
begin; update t1 set b=11 where a=2;

connection con2;
let $ID= `select connection_id()`;
begin;
send update t1 set b=b+10;

connection con1;
--replace_result $ID ID
eval kill query $ID;
rollback;

# Bug #32148  	killi query may be ineffective 
# forced to comment out the test's outcome 
# and mask out ineffective ER_QUERY_INTERRUPTED
# todo1: revert back upon fixing bug#32148
# todo2: the tests need refining in that
#        killing should wait till the victim requested
#        its lock (wait_condition available in 5.1 tests)

connection con2;
--error 0,ER_QUERY_INTERRUPTED
reap;
rollback;
select * from t1  order by a /* must be the same as before (1,1),(2,2) */;

#
# multi update
# commented out as Bug #31807 multi-update,delete killing does not report with ER_QUERY_INTERRUPTED
# in the way
#
# connection con1;
# begin; update t1 set b=b+10;

# connection con2;
# send update t1 as t_1,t1 as t_2 set t_1.b=11 where t_2.a=2;

# connection con1;
# --replace_result $ID ID
# eval kill query $ID;
# rollback;

# disable_abort_on_error;

# connection con2;
# --error HY000,ER_QUERY_INTERRUPTED
# reap;
# select * from t1 /* must be the same as before (1,1),(2,2) */;

# enable_abort_on_error;
#
# simple delete
#
connection con1;
begin; delete from t1 where a=2;

connection con2;
let $ID= `select connection_id()`;
begin;
send delete from t1 where a=2;

connection con1;
--replace_result $ID ID
eval kill query $ID;
rollback;

connection con2;
--error 0,ER_QUERY_INTERRUPTED
reap;
rollback;
# todo1,2 above
select * from t1 order by a /* must be the same as before (1,1),(2,2) */;

#
# multi delete
# the same as for multi-update
#
# connection con1;
# begin; delete from t1 where a=2;

# connection con2;
# send delete t1 from t1 where t1.a=2;

# connection con1;
# --replace_result $ID ID
# eval kill query $ID;
# rollback;

# connection con2;
# --error 0,ER_QUERY_INTERRUPTED
# reap;
# select * from t1 /* must be the same as before (1,1),(2,2) */;
#
# insert select
#
connection con1;
--disable_warnings
drop table if exists t4;
--enable_warnings
create table t4 (a int, b int) engine=innodb;
insert into t4 values (3, 3);
begin; insert into t1 values (3, 3);

connection con2;
let $ID= `select connection_id()`;
begin;
send insert into t1 select * from t4 for update;

connection con1;
--replace_result $ID ID
eval kill query $ID;
rollback;

connection con2;
--error 0,ER_QUERY_INTERRUPTED
reap;
# todo 1,2 above
rollback;
select * from t1 /* must be the same as before (1,1),(2,2) */;

drop table t4; # cleanup for the sub-case

###
## non-ta table case: killing must be recorded in binlog
###
create table t4 (a int, b int) ENGINE=MyISAM /* for killing update and delete */;

delimiter |;
create function bug27563(n int) 
RETURNS int(11)
DETERMINISTIC
begin
  if @b > 0 then
     select get_lock("a", 20)  into @a;
  else 
     set @b= 1;
  end if;
  return n;
end|
delimiter ;|

#
# update
#

delete from t4;
insert into t4 values (1,1), (1,1);
reset master;
connection con1;
select get_lock("a", 20);

connection con2;
let $ID= `select connection_id()`;
set @b= 0;
send update t4 set b=b + bug27563(b);

connection con1;
let $wait_condition= select count(*) = 1 FROM INFORMATION_SCHEMA.PROCESSLIST where state='User lock';
source include/wait_condition_or_abort.inc;
select count(*) FROM INFORMATION_SCHEMA.PROCESSLIST where state='User lock';

--replace_result $ID ID
eval kill query $ID;

connection con2;
--error ER_QUERY_INTERRUPTED
reap;
select * from t4 order by b /* must be (1,1), (1,2) */;
select @b  /* must be 1 at the end of a stmt calling bug27563() */;
--echo must have the update query event on the 4th line
source include/show_binlog_events.inc;
--let $row_number= 6

--let $binlog_killed_pos= query_get_value(SHOW BINLOG EVENTS, Pos, $row_number)
--let $binlog_killed_end_log_pos= query_get_value(SHOW BINLOG EVENTS, End_log_pos, $row_number)

--echo *** a proof the query is binlogged with an error ***

--exec $MYSQL_BINLOG --force-if-open --start-position=$binlog_killed_pos --stop-position=$binlog_killed_end_log_pos $MYSQLD_DATADIR/master-bin.000001 > $MYSQLTEST_VARDIR/tmp/binlog_killed_bug27571.binlog
--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
eval select
(@a:=load_file("$MYSQLTEST_VARDIR/tmp/binlog_killed_bug27571.binlog"))
is not null AS Loaded;
let $error_code= `select @a like "%#%error_code=0%" /* must return 0*/`;
eval select $error_code /* must return 0 to mean the killed update is in */;

# cleanup for the sub-case
connection con1;
select RELEASE_LOCK("a");
--remove_file $MYSQLTEST_VARDIR/tmp/binlog_killed_bug27571.binlog

#
# delete
#

delete from t4;
insert into t4 values (1,1), (2,2);
reset master;
connection con1;
select get_lock("a", 20);

connection con2;
let $ID= `select connection_id()`;
set @b= 0;
send delete from t4 where b=bug27563(1) or b=bug27563(2);

connection con2;
--error ER_QUERY_INTERRUPTED
reap;
select count(*) from t4 /* must be 1 */;
select @b  /* must be 1 at the end of a stmt calling bug27563() */;
--echo must have the delete query event on the 4th line
source include/show_binlog_events.inc;

--let $row_number= 6

--let $binlog_killed_pos= query_get_value(SHOW BINLOG EVENTS, Pos, $row_number)
--let $binlog_killed_end_log_pos= query_get_value(SHOW BINLOG EVENTS, End_log_pos, $row_number)

# a proof the query is binlogged with an error

--exec $MYSQL_BINLOG --force-if-open --start-position=$binlog_killed_pos --stop-position=$binlog_killed_end_log_pos $MYSQLD_DATADIR/master-bin.000001 > $MYSQLTEST_VARDIR/tmp/binlog_killed_bug27571.binlog
--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
eval select
(@a:=load_file("$MYSQLTEST_VARDIR/tmp/binlog_killed_bug27571.binlog"))
is not null AS Loaded;
--replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
let $error_code= `select @a like "%#%error_code=0%" /* must return 0*/`;
eval select $error_code /* must return 0 to mean the killed delete is in */;

# cleanup for the sub-case
connection con1;
select RELEASE_LOCK("a");
--remove_file $MYSQLTEST_VARDIR/tmp/binlog_killed_bug27571.binlog

drop table t4;

#
# load data - see simulation tests
#

# bug#27571 cleanup

drop function bug27563;

#
# common cleanup 
#

connection con1;
disconnect con1;
--source include/wait_until_disconnected.inc
connection con2;
disconnect con2;
--source include/wait_until_disconnected.inc
connection default;

drop table t1,t2,t3;

--echo end of the tests

${this.title}

Code Editor : binlog_killed.test