EVOLUTION-MANAGER

Edit File: hcad_fixedvar_drop.result

SET DEFAULT_STORAGE_ENGINE='tokudb'; DROP TABLE IF EXISTS foo,bar; set session tokudb_disable_slow_alter=ON; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column a; alter table bar drop column a; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column b; alter table bar drop column b; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column c; alter table bar drop column c; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column d; alter table bar drop column d; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column aaa; alter table bar drop column aaa; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column bbb; alter table bar drop column bbb; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column ccc; alter table bar drop column ccc; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column ddd; alter table bar drop column ddd; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column a, drop column b; alter table bar drop column a, drop column b; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column a, drop column c; alter table bar drop column a, drop column c; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column a, drop column d; alter table bar drop column a, drop column d; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column a, drop column aaa; alter table bar drop column a, drop column aaa; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column a, drop column bbb; alter table bar drop column a, drop column bbb; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column a, drop column ccc; alter table bar drop column a, drop column ccc; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column a, drop column ddd; alter table bar drop column a, drop column ddd; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column b, drop column a; alter table bar drop column b, drop column a; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column b, drop column c; alter table bar drop column b, drop column c; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column b, drop column d; alter table bar drop column b, drop column d; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column b, drop column aaa; alter table bar drop column b, drop column aaa; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column b, drop column bbb; alter table bar drop column b, drop column bbb; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column b, drop column ccc; alter table bar drop column b, drop column ccc; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column b, drop column ddd; alter table bar drop column b, drop column ddd; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column c, drop column a; alter table bar drop column c, drop column a; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column c, drop column b; alter table bar drop column c, drop column b; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column c, drop column d; alter table bar drop column c, drop column d; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column c, drop column aaa; alter table bar drop column c, drop column aaa; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column c, drop column bbb; alter table bar drop column c, drop column bbb; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column c, drop column ccc; alter table bar drop column c, drop column ccc; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column c, drop column ddd; alter table bar drop column c, drop column ddd; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column d, drop column a; alter table bar drop column d, drop column a; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column d, drop column b; alter table bar drop column d, drop column b; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column d, drop column c; alter table bar drop column d, drop column c; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column d, drop column aaa; alter table bar drop column d, drop column aaa; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column d, drop column bbb; alter table bar drop column d, drop column bbb; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column d, drop column ccc; alter table bar drop column d, drop column ccc; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column d, drop column ddd; alter table bar drop column d, drop column ddd; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column aaa, drop column a; alter table bar drop column aaa, drop column a; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column aaa, drop column b; alter table bar drop column aaa, drop column b; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column aaa, drop column c; alter table bar drop column aaa, drop column c; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column aaa, drop column d; alter table bar drop column aaa, drop column d; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column aaa, drop column bbb; alter table bar drop column aaa, drop column bbb; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column aaa, drop column ccc; alter table bar drop column aaa, drop column ccc; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column aaa, drop column ddd; alter table bar drop column aaa, drop column ddd; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column bbb, drop column a; alter table bar drop column bbb, drop column a; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column bbb, drop column b; alter table bar drop column bbb, drop column b; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column bbb, drop column c; alter table bar drop column bbb, drop column c; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column bbb, drop column d; alter table bar drop column bbb, drop column d; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column bbb, drop column aaa; alter table bar drop column bbb, drop column aaa; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column bbb, drop column ccc; alter table bar drop column bbb, drop column ccc; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column bbb, drop column ddd; alter table bar drop column bbb, drop column ddd; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column ccc, drop column a; alter table bar drop column ccc, drop column a; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column ccc, drop column b; alter table bar drop column ccc, drop column b; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column ccc, drop column c; alter table bar drop column ccc, drop column c; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column ccc, drop column d; alter table bar drop column ccc, drop column d; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column ccc, drop column aaa; alter table bar drop column ccc, drop column aaa; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column ccc, drop column bbb; alter table bar drop column ccc, drop column bbb; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column ccc, drop column ddd; alter table bar drop column ccc, drop column ddd; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column ddd, drop column a; alter table bar drop column ddd, drop column a; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column ddd, drop column b; alter table bar drop column ddd, drop column b; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column ddd, drop column c; alter table bar drop column ddd, drop column c; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column ddd, drop column d; alter table bar drop column ddd, drop column d; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column ddd, drop column aaa; alter table bar drop column ddd, drop column aaa; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column ddd, drop column bbb; alter table bar drop column ddd, drop column bbb; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column ddd, drop column ccc; alter table bar drop column ddd, drop column ccc; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column a, drop column b, drop column c; alter table bar drop column a, drop column b, drop column c; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column a, drop column b, drop column d; alter table bar drop column a, drop column b, drop column d; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column a, drop column c, drop column d; alter table bar drop column a, drop column c, drop column d; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column b, drop column c, drop column d; alter table bar drop column b, drop column c, drop column d; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column a, drop column b, drop column c, drop column d; alter table bar drop column a, drop column b, drop column c, drop column d; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar; create table foo (a int, b bigint, c date, d tinyint, aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; create table bar like foo; alter table bar engine=MyISAM; insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); insert into bar select * from foo; include/diff_tables.inc [test.foo, test.bar] alter table foo drop column aaa, drop column bbb, drop column ccc, drop column ddd; alter table bar drop column aaa, drop column bbb, drop column ccc, drop column ddd; include/diff_tables.inc [test.foo, test.bar] drop table foo; drop table bar;