diff options
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.test | 6 |
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; |