summaryrefslogtreecommitdiff
path: root/mysql-test/t/kill.test
diff options
context:
space:
mode:
authormonty@donna.mysql.fi <>2001-03-15 03:55:48 +0200
committermonty@donna.mysql.fi <>2001-03-15 03:55:48 +0200
commitd0722d73b08d143ae23cdd44e22024995e8cf1a5 (patch)
tree07b5e02de968248c9c9cf63912c2416cb016c45f /mysql-test/t/kill.test
parent1bd0d416b2586de7fbe4c29884bf67954bee46a3 (diff)
downloadmariadb-git-d0722d73b08d143ae23cdd44e22024995e8cf1a5.tar.gz
Added fix for using variables with distinct
Diffstat (limited to 'mysql-test/t/kill.test')
-rw-r--r--mysql-test/t/kill.test19
1 files changed, 11 insertions, 8 deletions
diff --git a/mysql-test/t/kill.test b/mysql-test/t/kill.test
index 19739c88673..0191461f73f 100644
--- a/mysql-test/t/kill.test
+++ b/mysql-test/t/kill.test
@@ -3,21 +3,24 @@ connect (con2, localhost, root,,test,0, mysql-master.sock);
#remember id of con1
connection con1;
-drop table if exists connection_kill;
-create table connection_kill (kill_id int);
-insert into connection_kill values(connection_id());
+drop table if exists t1;
+create table t1 (kill_id int);
+insert into t1 values(connection_id());
#kill con1
connection con2;
-select ((@id := kill_id) - kill_id) from connection_kill;
+select ((@id := kill_id) - kill_id) from t1;
kill @id;
-# verify that con1 is really dead
+# Wait for thread to do.
+--sleep 5
+# verify that con1 is doning a reconnect
connection con1;
-error 2013;
-select 1;
+ping
+ping
+select @id != connection_id();
#make sure the server is still alive
connection con2;
select 4;
-drop table connection_kill;
+drop table t1;