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, 13 insertions, 12 deletions

diff --git a/mysql-test/t/sel000100.test b/mysql-test/t/sel000100.test
index 718e67de9ea..a1dbab42dab 100644
--- a/mysql-test/t/sel000100.test
+++ b/mysql-test/t/sel000100.test
@@ -1,7 +1,6 @@
-DROP TABLE IF EXISTS test1;
-DROP TABLE IF EXISTS test2;
+DROP TABLE IF EXISTS t1,t2;
 
-CREATE TABLE test1 (
+CREATE TABLE t1 (
   ID int(11) NOT NULL auto_increment,
   NAME varchar(75) DEFAULT '' NOT NULL,
   LINK_ID int(11) DEFAULT '0' NOT NULL,
@@ -10,11 +9,11 @@ CREATE TABLE test1 (
   KEY LINK_ID (LINK_ID)
 );
 
-INSERT INTO test1 (ID, NAME, LINK_ID) VALUES (1,'Mike',0);
-INSERT INTO test1 (ID, NAME, LINK_ID) VALUES (2,'Jack',0);
-INSERT INTO test1 (ID, NAME, LINK_ID) VALUES (3,'Bill',0);
+INSERT INTO t1 (ID, NAME, LINK_ID) VALUES (1,'Mike',0);
+INSERT INTO t1 (ID, NAME, LINK_ID) VALUES (2,'Jack',0);
+INSERT INTO t1 (ID, NAME, LINK_ID) VALUES (3,'Bill',0);
 
-CREATE TABLE test2 (
+CREATE TABLE t2 (
   ID int(11) NOT NULL auto_increment,
   NAME varchar(150) DEFAULT '' NOT NULL,
   PRIMARY KEY (ID),
@@ -22,9 +21,11 @@ CREATE TABLE test2 (
 );
 
 @r/sel000100.result SELECT DISTINCT
-    test2.id AS key_link_id,
-    test2.name AS link
-FROM test1
-LEFT JOIN test2 ON test1.link_id=test2.id
-GROUP BY test1.id
+    t2.id AS key_link_id,
+    t2.name AS link
+FROM t1
+LEFT JOIN t2 ON t1.link_id=t2.id
+GROUP BY t1.id
 ORDER BY link;
+
+drop table t1,t2;