EVOLUTION-MANAGER

Edit File: hcad_clustering2.test

--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 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 (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; alter table foo add column d varchar(10) default 20; alter table bar add column d varchar(10) 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 varchar(10) default 20 first; alter table bar add column d varchar(10) 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 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 (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; alter table foo add column d varchar(10) default 20; alter table bar add column d varchar(10) 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 varchar(10) default 20 first; alter table bar add column d varchar(10) 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;