summaryrefslogtreecommitdiff
path: root/storage/tokudb/mysql-test/suite/tokudb.alter_table/t/hcad_clustering.test
diff options
context:
space:
mode:
Diffstat (limited to 'storage/tokudb/mysql-test/suite/tokudb.alter_table/t/hcad_clustering.test')
-rw-r--r--storage/tokudb/mysql-test/suite/tokudb.alter_table/t/hcad_clustering.test111
1 files changed, 0 insertions, 111 deletions
diff --git a/storage/tokudb/mysql-test/suite/tokudb.alter_table/t/hcad_clustering.test b/storage/tokudb/mysql-test/suite/tokudb.alter_table/t/hcad_clustering.test
deleted file mode 100644
index 854409c7f62..00000000000
--- a/storage/tokudb/mysql-test/suite/tokudb.alter_table/t/hcad_clustering.test
+++ /dev/null
@@ -1,111 +0,0 @@
-#--source include/have_tokudb.inc
-SET DEFAULT_STORAGE_ENGINE='tokudb';
-
---disable_warnings
-DROP TABLE IF EXISTS foo,bar;
---enable_warnings
-
-set session tokudb_disable_slow_alter=ON;
-
-let $diff_tables= test.foo, test.bar;
-
-create table foo (a int NOT NULL, b bigint NOT NULL, c mediumint NOT NULL, primary key (a), clustering key (b))engine=TokuDB;
-create table bar like foo;
-alter table bar engine=MyISAM;
-
-insert into foo values (1,10,100),(-1,-1,-1),(2,20,200);
-insert into bar select * from foo;
-
-alter table foo add column d int default 20;
-alter table bar add column d int default 20;
-source include/diff_tables.inc;
-select * from foo;
-select * from foo order by b desc;
-insert into foo values (3,30,300,3000);
-insert into bar values (3,30,300,3000);
-select * from foo;
-select * from foo order by b desc;
-
-alter table foo drop column d;
-alter table bar drop column d;
-source include/diff_tables.inc;
-select * from foo;
-select * from foo order by b desc;
-insert into foo values (4,40,400);
-insert into bar values (4,40,400);
-select * from foo;
-select * from foo order by b desc;
-
-alter table foo add column d int default 20 first;
-alter table bar add column d int default 20 first;
-source include/diff_tables.inc;
-select * from foo;
-select * from foo order by b desc;
-insert into foo values (5,50,500,5000);
-insert into bar values (5,50,500,5000);
-select * from foo;
-select * from foo order by b desc;
-
-alter table foo drop column d;
-alter table bar drop column d;
-source include/diff_tables.inc;
-select * from foo;
-select * from foo order by b desc;
-insert into foo values (6,60,600);
-insert into bar values (6,60,600);
-select * from foo;
-select * from foo order by b desc;
-
-drop table foo;
-drop table bar;
-
-create table foo (a int NOT NULL, b bigint NOT NULL, c mediumint NOT NULL, primary key (c), clustering key (b))engine=TokuDB;
-create table bar like foo;
-alter table bar engine=MyISAM;
-
-insert into foo values (1,10,100),(-1,-1,-1),(2,20,200);
-insert into bar select * from foo;
-
-alter table foo add column d int default 20;
-alter table bar add column d int default 20;
-source include/diff_tables.inc;
-select * from foo;
-select * from foo order by b desc;
-insert into foo values (3,30,300,3000);
-insert into bar values (3,30,300,3000);
-select * from foo;
-select * from foo order by b desc;
-
-alter table foo drop column d;
-alter table bar drop column d;
-source include/diff_tables.inc;
-select * from foo;
-select * from foo order by b desc;
-insert into foo values (4,40,400);
-insert into bar values (4,40,400);
-select * from foo;
-select * from foo order by b desc;
-
-alter table foo add column d int default 20 first;
-alter table bar add column d int default 20 first;
-source include/diff_tables.inc;
-select * from foo;
-select * from foo order by b desc;
-insert into foo values (5,50,500,5000);
-insert into bar values (5,50,500,5000);
-select * from foo;
-select * from foo order by b desc;
-
-alter table foo drop column d;
-alter table bar drop column d;
-source include/diff_tables.inc;
-select * from foo;
-select * from foo order by b desc;
-insert into foo values (6,60,600);
-insert into bar values (6,60,600);
-select * from foo;
-select * from foo order by b desc;
-
-drop table foo;
-drop table bar;
-