summaryrefslogtreecommitdiff
path: root/mysql-test/t/rpl_temporary.test
diff options
context:
space:
mode:
authorunknown <aelkin@mysql.com>2006-04-08 15:31:47 +0300
committerunknown <aelkin@mysql.com>2006-04-08 15:31:47 +0300
commit53731b7e6984ba9330ed8b7e52936d8f161b9e02 (patch)
tree6a9156368a036d04ce03ed34c6f8639d2142776a /mysql-test/t/rpl_temporary.test
parent03920635dcbf959fecc39f9c6a3f03fe2ff70574 (diff)
parent67cbda06b9dd5313f77c0d00d19c9cf49fcc11bc (diff)
downloadmariadb-git-53731b7e6984ba9330ed8b7e52936d8f161b9e02.tar.gz
Merge mysql.com:/usr_rh9/home/elkin.rh9/MySQL/BARE/5.0
into mysql.com:/usr_rh9/home/elkin.rh9/MySQL/Merge/5.1 mysql-test/mysql-test-run.sh: Auto merged mysql-test/r/rpl_temporary.result: Auto merged sql/sql_repl.cc: Auto merged mysql-test/t/rpl_temporary.test: manual merge
Diffstat (limited to 'mysql-test/t/rpl_temporary.test')
-rw-r--r--mysql-test/t/rpl_temporary.test26
1 files changed, 26 insertions, 0 deletions
diff --git a/mysql-test/t/rpl_temporary.test b/mysql-test/t/rpl_temporary.test
index 9c6056f9217..7269b54556b 100644
--- a/mysql-test/t/rpl_temporary.test
+++ b/mysql-test/t/rpl_temporary.test
@@ -131,4 +131,30 @@ drop table t1,t2;
create temporary table t3 (f int);
sync_with_master;
+#
+# Bug#17284 erroneous temp table cleanup on slave
+#
+
+connection master;
+create temporary table t4 (f int);
+create table t5 (f int);
+sync_with_master;
+# find dumper's $id
+source include/get_binlog_dump_thread_id.inc;
+insert into t4 values (1);
+# a hint how to do that in 5.1
+--replace_result $id "`select id from information_schema.processlist where command='Binlog Dump'`"
+eval kill $id; # to stimulate reconnection by slave w/o timeout
+insert into t5 select * from t4;
+save_master_pos;
+
+connection slave;
+sync_with_master;
+select * from t5 /* must be 1 after reconnection */;
+
+connection master;
+drop temporary table t4;
+drop table t5;
+
# The server will now close done
+# End of 5.1 tests