1 files changed, 7 insertions, 9 deletions
diff --git a/mysql-test/t/ins000001.test b/mysql-test/t/ins000001.test
index 1c40d1ffa8d..4d75b4e7fe3 100644
--- a/mysql-test/t/ins000001.test
+++ b/mysql-test/t/ins000001.test
@@ -1,11 +1,9 @@
 use test;
-drop table if exists emails;
-drop table if exists domain;
-drop table if exists domain;
-create table emails (email varchar(50));
-insert into emails values ('sasha@mysql.com'),('monty@mysql.com'),
+drop table if exists t1,t2;
+create table t1 (email varchar(50));
+insert into t1 values ('sasha@mysql.com'),('monty@mysql.com'),
 ('foo@hotmail.com'),('foo@aol.com'),('bar@aol.com');
-create table domain(id int not null auto_increment primary key,
- domain varchar(50), unique(domain));
-insert into domain (domain) select distinct substring(email, locate('@', email)+1) from emails;
-@r/ins000001.result select * from domain;
+create table t2(id int not null auto_increment primary key,
+ t2 varchar(50), unique(t2));
+insert into t2 (t2) select distinct substring(email, locate('@', email)+1) from t1;
+select * from t2;