summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--mysql-test/r/connect.result14
-rw-r--r--mysql-test/t/connect.test20
2 files changed, 12 insertions, 22 deletions
diff --git a/mysql-test/r/connect.result b/mysql-test/r/connect.result
index 293ad37c31a..68c86b80e60 100644
--- a/mysql-test/r/connect.result
+++ b/mysql-test/r/connect.result
@@ -1,3 +1,4 @@
+drop table if exists t1,t2;
show tables;
Tables_in_mysql
columns_priv
@@ -65,19 +66,8 @@ show tables;
Tables_in_test
delete from mysql.user where user=_binary"test";
flush privileges;
-use test;
-drop table if exists t1;
-Warnings:
-Note 1051 Unknown table 't1'
create table t1 (id integer not null auto_increment primary key);
-drop table if exists t2;
-Warnings:
-Note 1051 Unknown table 't2'
create temporary table t2(id integer not null auto_increment primary key);
set @id := 1;
delete from t1 where id like @id;
-use test;
-drop table if exists t2;
-Warnings:
-Note 1051 Unknown table 't2'
-drop table if exists t1;
+drop table t1;
diff --git a/mysql-test/t/connect.test b/mysql-test/t/connect.test
index 9acc18a0cee..ff15d74e5ac 100644
--- a/mysql-test/t/connect.test
+++ b/mysql-test/t/connect.test
@@ -6,6 +6,10 @@
# This test makes no sense with the embedded server
--source include/not_embedded.inc
+--disable_warnings
+drop table if exists t1,t2;
+--enable_warnings
+
#connect (con1,localhost,root,,"");
#show tables;
connect (con1,localhost,root,,mysql);
@@ -77,22 +81,18 @@ show tables;
delete from mysql.user where user=_binary"test";
flush privileges;
-# Test for bug #12517.
+#
+# Bug#12517: Clear user variables and replication events before
+# closing temp tables in thread cleanup.
connect (con2,localhost,root,,test);
connection con2;
-use test;
-drop table if exists t1;
create table t1 (id integer not null auto_increment primary key);
-drop table if exists t2;
create temporary table t2(id integer not null auto_increment primary key);
set @id := 1;
delete from t1 where id like @id;
disconnect con2;
-sleep 5;
-connect (con1,localhost,root,,test);
-connection con1;
-use test;
-drop table if exists t2;
-drop table if exists t1;
+--sleep 5
+connection default;
+drop table t1;
# End of 4.1 tests