Cleanup of tests to make them less dependent of eachother

Added new big select test


mysql-test/r/rpl000004.a.result:
  Cleanup
mysql-test/r/show_check.result:
  Cleanup
mysql-test/r/shw000001.result:
  Cleanup
mysql-test/t/fulltext_multi.test:
  Cleanup
mysql-test/t/fulltext_order_by.test:
  Cleanup
mysql-test/t/rpl000001.test:
  Cleanup
mysql-test/t/rpl000002.test:
  Cleanup
mysql-test/t/rpl000003.test:
  Cleanup
mysql-test/t/rpl000004.test:
  Cleanup
mysql-test/t/rpl000005.test:
  Cleanup
mysql-test/t/rpl000006.test:
  Cleanup
mysql-test/t/rpl000007.test:
  Cleanup
mysql-test/t/rpl000008.test:
  Cleanup
mysql-test/t/rpl000009.test:
  Cleanup
mysql-test/t/rpl000010.test:
  Cleanup
mysql-test/t/rpl000011.test:
  Cleanup
mysql-test/t/rpl000012.test:
  Cleanup
mysql-test/t/rpl000013.test:
  Cleanup
mysql-test/t/rpl000014.test:
  Cleanup
mysql-test/t/rpl000015.test:
  Cleanup
mysql-test/t/rpl000016.test:
  Cleanup
mysql-test/t/sel000001.test:
  Cleanup
mysql-test/t/sel000002.test:
  Cleanup
mysql-test/t/sel000003.test:
  Cleanup
mysql-test/t/sel000031.test:
  Cleanup
mysql-test/t/sel000032.test:
  Cleanup
mysql-test/t/sel000033.test:
  Cleanup
mysql-test/t/sel000100.test:
  Cleanup
mysql-test/t/show_check.test:
  Cleanup
mysql-test/t/shw000001.test:
  Cleanup

1 files changed, 17 insertions, 10 deletions

diff --git a/mysql-test/t/rpl000012.test b/mysql-test/t/rpl000012.test
index 55d6bd4d4f2..8a231c3f04d 100644
--- a/mysql-test/t/rpl000012.test
+++ b/mysql-test/t/rpl000012.test
@@ -1,19 +1,26 @@
 source include/master-slave.inc;
 connection master;
-drop table if exists x;
-create table x(n int);
-create temporary table t(n int);
-insert into t values(1),(2),(3);
-insert into x select * from t;
+drop table if exists t1,t2;
+
+create table t2 (n int);
+create temporary table t1 (n int);
+insert into t1 values(1),(2),(3);
+insert into t2 select * from t1;
 connection master1;
-create temporary table t (n int);
-insert into t values (4),(5);
-insert into x select * from t;
+create temporary table t1 (n int);
+insert into t1 values (4),(5);
+insert into t2 select * from t1;
 disconnect master;
 connection master1;
-insert into x values(6);
+insert into t2 values(6);
 disconnect master1;
 connection slave;
 sleep 1;
-@r/rpl000012.result select * from x;
+@r/rpl000012.result select * from t2;
 @r/rpl000012.status.result show status like 'Slave_open_temp_tables';
+#
+# Clean up
+#
+connect (master2,localhost,root,,test,0,var/tmp/mysql.sock);
+connection master2;
+drop table if exists t1,t2;