summaryrefslogtreecommitdiff
path: root/storage/tokudb/mysql-test/tokudb_alter_table/t/hcad_clustering2.test
diff options
context:
space:
mode:
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb_alter_table/t/hcad_clustering2.test')
-rw-r--r--storage/tokudb/mysql-test/tokudb_alter_table/t/hcad_clustering2.test6
1 files changed, 2 insertions, 4 deletions
diff --git a/storage/tokudb/mysql-test/tokudb_alter_table/t/hcad_clustering2.test b/storage/tokudb/mysql-test/tokudb_alter_table/t/hcad_clustering2.test
index 904954ec0d7..f487c69c637 100644
--- a/storage/tokudb/mysql-test/tokudb_alter_table/t/hcad_clustering2.test
+++ b/storage/tokudb/mysql-test/tokudb_alter_table/t/hcad_clustering2.test
@@ -10,8 +10,7 @@ set session tokudb_disable_slow_alter=ON;
let $diff_tables= test.foo, test.bar;
create table foo (a varchar(10) NOT NULL, b varchar(10) NOT NULL, c varchar(10) NOT NULL, primary key (a), key (b) clustering=yes)engine=TokuDB;
-create table bar like foo;
-alter table bar engine=MyISAM;
+create table bar (a varchar(10) NOT NULL, b varchar(10) NOT NULL, c varchar(10) NOT NULL, primary key (a), key (b))engine=MyISAM;
insert into foo values (1,10,100),(-1,-1,-1),(2,20,200);
insert into bar select * from foo;
@@ -60,8 +59,7 @@ drop table foo;
drop table bar;
create table foo (a varchar(10) NOT NULL, b varchar(10) NOT NULL, c varchar(10) NOT NULL, primary key (c), key (b) clustering=yes)engine=TokuDB;
-create table bar like foo;
-alter table bar engine=MyISAM;
+create table bar (a varchar(10) NOT NULL, b varchar(10) NOT NULL, c varchar(10) NOT NULL, primary key (c), key (b))engine=MyISAM;
insert into foo values (1,10,100),(-1,-1,-1),(2,20,200);
insert into bar select * from foo;