summaryrefslogtreecommitdiff
path: root/storage/tokudb/mysql-test/suite/tokudb.alter_table/r/hcad_clustering.result
diff options
context:
space:
mode:
Diffstat (limited to 'storage/tokudb/mysql-test/suite/tokudb.alter_table/r/hcad_clustering.result')
-rw-r--r--storage/tokudb/mysql-test/suite/tokudb.alter_table/r/hcad_clustering.result281
1 files changed, 0 insertions, 281 deletions
diff --git a/storage/tokudb/mysql-test/suite/tokudb.alter_table/r/hcad_clustering.result b/storage/tokudb/mysql-test/suite/tokudb.alter_table/r/hcad_clustering.result
deleted file mode 100644
index 3c67ba37309..00000000000
--- a/storage/tokudb/mysql-test/suite/tokudb.alter_table/r/hcad_clustering.result
+++ /dev/null
@@ -1,281 +0,0 @@
-SET DEFAULT_STORAGE_ENGINE='tokudb';
-DROP TABLE IF EXISTS foo,bar;
-set session tokudb_disable_slow_alter=ON;
-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;
-include/diff_tables.inc [test.foo, test.bar]
-select * from foo;
-a b c d
--1 -1 -1 20
-1 10 100 20
-2 20 200 20
-select * from foo order by b desc;
-a b c d
-2 20 200 20
-1 10 100 20
--1 -1 -1 20
-insert into foo values (3,30,300,3000);
-insert into bar values (3,30,300,3000);
-select * from foo;
-a b c d
--1 -1 -1 20
-1 10 100 20
-2 20 200 20
-3 30 300 3000
-select * from foo order by b desc;
-a b c d
-3 30 300 3000
-2 20 200 20
-1 10 100 20
--1 -1 -1 20
-alter table foo drop column d;
-alter table bar drop column d;
-include/diff_tables.inc [test.foo, test.bar]
-select * from foo;
-a b c
--1 -1 -1
-1 10 100
-2 20 200
-3 30 300
-select * from foo order by b desc;
-a b c
-3 30 300
-2 20 200
-1 10 100
--1 -1 -1
-insert into foo values (4,40,400);
-insert into bar values (4,40,400);
-select * from foo;
-a b c
--1 -1 -1
-1 10 100
-2 20 200
-3 30 300
-4 40 400
-select * from foo order by b desc;
-a b c
-4 40 400
-3 30 300
-2 20 200
-1 10 100
--1 -1 -1
-alter table foo add column d int default 20 first;
-alter table bar add column d int default 20 first;
-include/diff_tables.inc [test.foo, test.bar]
-select * from foo;
-d a b c
-20 -1 -1 -1
-20 1 10 100
-20 2 20 200
-20 3 30 300
-20 4 40 400
-select * from foo order by b desc;
-d a b c
-20 4 40 400
-20 3 30 300
-20 2 20 200
-20 1 10 100
-20 -1 -1 -1
-insert into foo values (5,50,500,5000);
-insert into bar values (5,50,500,5000);
-select * from foo;
-d a b c
-20 -1 -1 -1
-20 1 10 100
-20 2 20 200
-20 3 30 300
-20 4 40 400
-5 50 500 5000
-select * from foo order by b desc;
-d a b c
-5 50 500 5000
-20 4 40 400
-20 3 30 300
-20 2 20 200
-20 1 10 100
-20 -1 -1 -1
-alter table foo drop column d;
-alter table bar drop column d;
-include/diff_tables.inc [test.foo, test.bar]
-select * from foo;
-a b c
--1 -1 -1
-1 10 100
-2 20 200
-3 30 300
-4 40 400
-50 500 5000
-select * from foo order by b desc;
-a b c
-50 500 5000
-4 40 400
-3 30 300
-2 20 200
-1 10 100
--1 -1 -1
-insert into foo values (6,60,600);
-insert into bar values (6,60,600);
-select * from foo;
-a b c
--1 -1 -1
-1 10 100
-2 20 200
-3 30 300
-4 40 400
-6 60 600
-50 500 5000
-select * from foo order by b desc;
-a b c
-50 500 5000
-6 60 600
-4 40 400
-3 30 300
-2 20 200
-1 10 100
--1 -1 -1
-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;
-include/diff_tables.inc [test.foo, test.bar]
-select * from foo;
-a b c d
--1 -1 -1 20
-1 10 100 20
-2 20 200 20
-select * from foo order by b desc;
-a b c d
-2 20 200 20
-1 10 100 20
--1 -1 -1 20
-insert into foo values (3,30,300,3000);
-insert into bar values (3,30,300,3000);
-select * from foo;
-a b c d
--1 -1 -1 20
-1 10 100 20
-2 20 200 20
-3 30 300 3000
-select * from foo order by b desc;
-a b c d
-3 30 300 3000
-2 20 200 20
-1 10 100 20
--1 -1 -1 20
-alter table foo drop column d;
-alter table bar drop column d;
-include/diff_tables.inc [test.foo, test.bar]
-select * from foo;
-a b c
--1 -1 -1
-1 10 100
-2 20 200
-3 30 300
-select * from foo order by b desc;
-a b c
-3 30 300
-2 20 200
-1 10 100
--1 -1 -1
-insert into foo values (4,40,400);
-insert into bar values (4,40,400);
-select * from foo;
-a b c
--1 -1 -1
-1 10 100
-2 20 200
-3 30 300
-4 40 400
-select * from foo order by b desc;
-a b c
-4 40 400
-3 30 300
-2 20 200
-1 10 100
--1 -1 -1
-alter table foo add column d int default 20 first;
-alter table bar add column d int default 20 first;
-include/diff_tables.inc [test.foo, test.bar]
-select * from foo;
-d a b c
-20 -1 -1 -1
-20 1 10 100
-20 2 20 200
-20 3 30 300
-20 4 40 400
-select * from foo order by b desc;
-d a b c
-20 4 40 400
-20 3 30 300
-20 2 20 200
-20 1 10 100
-20 -1 -1 -1
-insert into foo values (5,50,500,5000);
-insert into bar values (5,50,500,5000);
-select * from foo;
-d a b c
-20 -1 -1 -1
-20 1 10 100
-20 2 20 200
-20 3 30 300
-20 4 40 400
-5 50 500 5000
-select * from foo order by b desc;
-d a b c
-5 50 500 5000
-20 4 40 400
-20 3 30 300
-20 2 20 200
-20 1 10 100
-20 -1 -1 -1
-alter table foo drop column d;
-alter table bar drop column d;
-include/diff_tables.inc [test.foo, test.bar]
-select * from foo;
-a b c
--1 -1 -1
-1 10 100
-2 20 200
-3 30 300
-4 40 400
-50 500 5000
-select * from foo order by b desc;
-a b c
-50 500 5000
-4 40 400
-3 30 300
-2 20 200
-1 10 100
--1 -1 -1
-insert into foo values (6,60,600);
-insert into bar values (6,60,600);
-select * from foo;
-a b c
--1 -1 -1
-1 10 100
-2 20 200
-3 30 300
-4 40 400
-6 60 600
-50 500 5000
-select * from foo order by b desc;
-a b c
-50 500 5000
-6 60 600
-4 40 400
-3 30 300
-2 20 200
-1 10 100
--1 -1 -1
-drop table foo;
-drop table bar;
View Lorry Controller Status