summaryrefslogtreecommitdiff
path: root/mysql-test/t/rpl000001.test
diff options
context:
space:
mode:
authorsasha@mysql.sashanet.com <>2001-04-10 20:56:54 -0600
committersasha@mysql.sashanet.com <>2001-04-10 20:56:54 -0600
commit102c1945eb20afcfc727ab9cec981f4b5204ed8c (patch)
treec052d8d91d91bacc775ebdfd8e299c23e4a6e100 /mysql-test/t/rpl000001.test
parent54b9d367f9fd32e1c57b0abd53c6299fdafad81f (diff)
downloadmariadb-git-102c1945eb20afcfc727ab9cec981f4b5204ed8c.tar.gz
do not log the drop internal temporary tables into the binary log
mark killed partially completed updates with an error code in binlog stop replication if the master reports a possible partial/killed update test partially killed update
Diffstat (limited to 'mysql-test/t/rpl000001.test')
-rw-r--r--mysql-test/t/rpl000001.test42
1 files changed, 42 insertions, 0 deletions
diff --git a/mysql-test/t/rpl000001.test b/mysql-test/t/rpl000001.test
index c7b1f817e81..c2a6b2aaec9 100644
--- a/mysql-test/t/rpl000001.test
+++ b/mysql-test/t/rpl000001.test
@@ -20,4 +20,46 @@ drop table t1;
save_master_pos;
connection slave;
sync_with_master;
+#test handling of aborted connection in the middle of update
+connection master;
+drop table if exists t1,t2;
+create table t1(n int);
+let $1=30000;
+while ($1)
+{
+ eval insert into t1 values($1);
+ dec $1;
+}
+create table t2(id int);
+insert into t2 values(connection_id());
+save_master_pos;
+send update t1 set n = n + 1;
+connection master1;
+select (@id := id) - id from t2;
+sleep 0.1;
+kill @id;
+drop table t2;
+connection master;
+--error 1053;
+reap;
+connection slave;
+sync_with_master ;
+show slave status;
+set sql_slave_skip_counter=1;
+slave start;
+select count(*) from t1;
+connection master1;
+drop table t1;
+create table t1 (n int);
+insert into t1 values(3456);
+save_master_pos;
+connection slave;
+sync_with_master;
+select n from t1;
+connection master1;
+drop table t1;
+save_master_pos;
+connection slave;
+sync_with_master;
+