# test for BUG#42519

--source include/have_debug_sync.inc

connect(con1, localhost, root,,);

connection default;
--disable_warnings
DROP DATABASE IF EXISTS mysqltest;
--error 0,1
--remove_file $MYSQLTEST_VARDIR/master-data/test.ba
--enable_warnings

CREATE DATABASE mysqltest;
USE mysqltest;
CREATE TABLE t1 (a int, b varchar(100), unique(a)) engine=myisam;
#insert into t1 values(1,"abc");

--replace_column 1 #
BACKUP DATABASE mysqltest TO 'test.ba';
DROP DATABASE mysqltest;

SET DEBUG_SYNC= 'before_restore_locks_tables SIGNAL wait_for_restore WAIT_FOR finish';
send RESTORE FROM 'test.ba';

connection con1;
SET DEBUG_SYNC= 'now WAIT_FOR wait_for_restore';
insert into mysqltest.t1 values(1,"def");
SET DEBUG_SYNC= 'now SIGNAL finish';

connection default;
--replace_column 1 #
reap;

select * from t1;
check table t1;
select * from t1;

--echo
--echo connection default: cleanup
connection default;
drop database mysqltest;
--remove_file $MYSQLTEST_VARDIR/master-data/test.ba