1--source include/have_tokudb.inc 2SET DEFAULT_STORAGE_ENGINE='tokudb'; 3 4--disable_warnings 5DROP TABLE IF EXISTS foo,bar; 6--enable_warnings 7 8set session tokudb_disable_slow_alter=ON; 9 10let $diff_tables= test.foo, test.bar; 11 12 13create table foo (aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; 14create table bar like foo; 15alter table bar engine=MyISAM; 16insert into foo values (NULL,NULL,NULL,NULL); 17insert into foo values (-1,NULL,'2008-1-1',NULL); 18insert into foo values (NULL,12345678987,NULL,1); 19insert into foo values (2,20,'1999-11-11',0); 20insert into bar select * from foo; 21source include/diff_tables.inc; 22alter table foo drop column aaa; 23alter table bar drop column aaa; 24source include/diff_tables.inc; 25drop table foo; drop table bar; 26 27 28create table foo (aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; 29create table bar like foo; 30alter table bar engine=MyISAM; 31insert into foo values (NULL,NULL,NULL,NULL); 32insert into foo values (-1,NULL,'2008-1-1',NULL); 33insert into foo values (NULL,12345678987,NULL,1); 34insert into foo values (2,20,'1999-11-11',0); 35insert into bar select * from foo; 36source include/diff_tables.inc; 37alter table foo drop column bbb; 38alter table bar drop column bbb; 39source include/diff_tables.inc; 40drop table foo; drop table bar; 41 42 43create table foo (aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; 44create table bar like foo; 45alter table bar engine=MyISAM; 46insert into foo values (NULL,NULL,NULL,NULL); 47insert into foo values (-1,NULL,'2008-1-1',NULL); 48insert into foo values (NULL,12345678987,NULL,1); 49insert into foo values (2,20,'1999-11-11',0); 50insert into bar select * from foo; 51source include/diff_tables.inc; 52alter table foo drop column ccc; 53alter table bar drop column ccc; 54source include/diff_tables.inc; 55drop table foo; drop table bar; 56 57 58create table foo (aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; 59create table bar like foo; 60alter table bar engine=MyISAM; 61insert into foo values (NULL,NULL,NULL,NULL); 62insert into foo values (-1,NULL,'2008-1-1',NULL); 63insert into foo values (NULL,12345678987,NULL,1); 64insert into foo values (2,20,'1999-11-11',0); 65insert into bar select * from foo; 66source include/diff_tables.inc; 67alter table foo drop column ddd; 68alter table bar drop column ddd; 69source include/diff_tables.inc; 70drop table foo; drop table bar; 71 72 73create table foo (aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; 74create table bar like foo; 75alter table bar engine=MyISAM; 76insert into foo values (NULL,NULL,NULL,NULL); 77insert into foo values (-1,NULL,'2008-1-1',NULL); 78insert into foo values (NULL,12345678987,NULL,1); 79insert into foo values (2,20,'1999-11-11',0); 80insert into bar select * from foo; 81source include/diff_tables.inc; 82alter table foo drop column aaa, drop column bbb; 83alter table bar drop column aaa, drop column bbb; 84source include/diff_tables.inc; 85drop table foo; drop table bar; 86 87 88create table foo (aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; 89create table bar like foo; 90alter table bar engine=MyISAM; 91insert into foo values (NULL,NULL,NULL,NULL); 92insert into foo values (-1,NULL,'2008-1-1',NULL); 93insert into foo values (NULL,12345678987,NULL,1); 94insert into foo values (2,20,'1999-11-11',0); 95insert into bar select * from foo; 96source include/diff_tables.inc; 97alter table foo drop column aaa, drop column ccc; 98alter table bar drop column aaa, drop column ccc; 99source include/diff_tables.inc; 100drop table foo; drop table bar; 101 102 103create table foo (aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; 104create table bar like foo; 105alter table bar engine=MyISAM; 106insert into foo values (NULL,NULL,NULL,NULL); 107insert into foo values (-1,NULL,'2008-1-1',NULL); 108insert into foo values (NULL,12345678987,NULL,1); 109insert into foo values (2,20,'1999-11-11',0); 110insert into bar select * from foo; 111source include/diff_tables.inc; 112alter table foo drop column aaa, drop column ddd; 113alter table bar drop column aaa, drop column ddd; 114source include/diff_tables.inc; 115drop table foo; drop table bar; 116 117 118create table foo (aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; 119create table bar like foo; 120alter table bar engine=MyISAM; 121insert into foo values (NULL,NULL,NULL,NULL); 122insert into foo values (-1,NULL,'2008-1-1',NULL); 123insert into foo values (NULL,12345678987,NULL,1); 124insert into foo values (2,20,'1999-11-11',0); 125insert into bar select * from foo; 126source include/diff_tables.inc; 127alter table foo drop column bbb, drop column aaa; 128alter table bar drop column bbb, drop column aaa; 129source include/diff_tables.inc; 130drop table foo; drop table bar; 131 132 133create table foo (aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; 134create table bar like foo; 135alter table bar engine=MyISAM; 136insert into foo values (NULL,NULL,NULL,NULL); 137insert into foo values (-1,NULL,'2008-1-1',NULL); 138insert into foo values (NULL,12345678987,NULL,1); 139insert into foo values (2,20,'1999-11-11',0); 140insert into bar select * from foo; 141source include/diff_tables.inc; 142alter table foo drop column bbb, drop column ccc; 143alter table bar drop column bbb, drop column ccc; 144source include/diff_tables.inc; 145drop table foo; drop table bar; 146 147 148create table foo (aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; 149create table bar like foo; 150alter table bar engine=MyISAM; 151insert into foo values (NULL,NULL,NULL,NULL); 152insert into foo values (-1,NULL,'2008-1-1',NULL); 153insert into foo values (NULL,12345678987,NULL,1); 154insert into foo values (2,20,'1999-11-11',0); 155insert into bar select * from foo; 156source include/diff_tables.inc; 157alter table foo drop column bbb, drop column ddd; 158alter table bar drop column bbb, drop column ddd; 159source include/diff_tables.inc; 160drop table foo; drop table bar; 161 162 163create table foo (aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; 164create table bar like foo; 165alter table bar engine=MyISAM; 166insert into foo values (NULL,NULL,NULL,NULL); 167insert into foo values (-1,NULL,'2008-1-1',NULL); 168insert into foo values (NULL,12345678987,NULL,1); 169insert into foo values (2,20,'1999-11-11',0); 170insert into bar select * from foo; 171source include/diff_tables.inc; 172alter table foo drop column ccc, drop column aaa; 173alter table bar drop column ccc, drop column aaa; 174source include/diff_tables.inc; 175drop table foo; drop table bar; 176 177 178create table foo (aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; 179create table bar like foo; 180alter table bar engine=MyISAM; 181insert into foo values (NULL,NULL,NULL,NULL); 182insert into foo values (-1,NULL,'2008-1-1',NULL); 183insert into foo values (NULL,12345678987,NULL,1); 184insert into foo values (2,20,'1999-11-11',0); 185insert into bar select * from foo; 186source include/diff_tables.inc; 187alter table foo drop column ccc, drop column bbb; 188alter table bar drop column ccc, drop column bbb; 189source include/diff_tables.inc; 190drop table foo; drop table bar; 191 192 193create table foo (aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; 194create table bar like foo; 195alter table bar engine=MyISAM; 196insert into foo values (NULL,NULL,NULL,NULL); 197insert into foo values (-1,NULL,'2008-1-1',NULL); 198insert into foo values (NULL,12345678987,NULL,1); 199insert into foo values (2,20,'1999-11-11',0); 200insert into bar select * from foo; 201source include/diff_tables.inc; 202alter table foo drop column ccc, drop column ddd; 203alter table bar drop column ccc, drop column ddd; 204source include/diff_tables.inc; 205drop table foo; drop table bar; 206 207 208create table foo (aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; 209create table bar like foo; 210alter table bar engine=MyISAM; 211insert into foo values (NULL,NULL,NULL,NULL); 212insert into foo values (-1,NULL,'2008-1-1',NULL); 213insert into foo values (NULL,12345678987,NULL,1); 214insert into foo values (2,20,'1999-11-11',0); 215insert into bar select * from foo; 216source include/diff_tables.inc; 217alter table foo drop column ddd, drop column aaa; 218alter table bar drop column ddd, drop column aaa; 219source include/diff_tables.inc; 220drop table foo; drop table bar; 221 222 223create table foo (aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; 224create table bar like foo; 225alter table bar engine=MyISAM; 226insert into foo values (NULL,NULL,NULL,NULL); 227insert into foo values (-1,NULL,'2008-1-1',NULL); 228insert into foo values (NULL,12345678987,NULL,1); 229insert into foo values (2,20,'1999-11-11',0); 230insert into bar select * from foo; 231source include/diff_tables.inc; 232alter table foo drop column ddd, drop column bbb; 233alter table bar drop column ddd, drop column bbb; 234source include/diff_tables.inc; 235drop table foo; drop table bar; 236 237 238create table foo (aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; 239create table bar like foo; 240alter table bar engine=MyISAM; 241insert into foo values (NULL,NULL,NULL,NULL); 242insert into foo values (-1,NULL,'2008-1-1',NULL); 243insert into foo values (NULL,12345678987,NULL,1); 244insert into foo values (2,20,'1999-11-11',0); 245insert into bar select * from foo; 246source include/diff_tables.inc; 247alter table foo drop column ddd, drop column ccc; 248alter table bar drop column ddd, drop column ccc; 249source include/diff_tables.inc; 250drop table foo; drop table bar; 251 252 253create table foo (aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; 254create table bar like foo; 255alter table bar engine=MyISAM; 256insert into foo values (NULL,NULL,NULL,NULL); 257insert into foo values (-1,NULL,'2008-1-1',NULL); 258insert into foo values (NULL,12345678987,NULL,1); 259insert into foo values (2,20,'1999-11-11',0); 260insert into bar select * from foo; 261source include/diff_tables.inc; 262alter table foo drop column aaa, drop column bbb, drop column ccc; 263alter table bar drop column aaa, drop column bbb, drop column ccc; 264source include/diff_tables.inc; 265drop table foo; drop table bar; 266 267 268create table foo (aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; 269create table bar like foo; 270alter table bar engine=MyISAM; 271insert into foo values (NULL,NULL,NULL,NULL); 272insert into foo values (-1,NULL,'2008-1-1',NULL); 273insert into foo values (NULL,12345678987,NULL,1); 274insert into foo values (2,20,'1999-11-11',0); 275insert into bar select * from foo; 276source include/diff_tables.inc; 277alter table foo drop column aaa, drop column bbb, drop column ddd; 278alter table bar drop column aaa, drop column bbb, drop column ddd; 279source include/diff_tables.inc; 280drop table foo; drop table bar; 281 282 283create table foo (aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; 284create table bar like foo; 285alter table bar engine=MyISAM; 286insert into foo values (NULL,NULL,NULL,NULL); 287insert into foo values (-1,NULL,'2008-1-1',NULL); 288insert into foo values (NULL,12345678987,NULL,1); 289insert into foo values (2,20,'1999-11-11',0); 290insert into bar select * from foo; 291source include/diff_tables.inc; 292alter table foo drop column aaa, drop column ccc, drop column ddd; 293alter table bar drop column aaa, drop column ccc, drop column ddd; 294source include/diff_tables.inc; 295drop table foo; drop table bar; 296 297 298create table foo (aaa varchar(12), bbb varbinary(20), ccc varchar(50), ddd varchar(3000)) engine=TokuDB; 299create table bar like foo; 300alter table bar engine=MyISAM; 301insert into foo values (NULL,NULL,NULL,NULL); 302insert into foo values (-1,NULL,'2008-1-1',NULL); 303insert into foo values (NULL,12345678987,NULL,1); 304insert into foo values (2,20,'1999-11-11',0); 305insert into bar select * from foo; 306source include/diff_tables.inc; 307alter table foo drop column bbb, drop column ccc, drop column ddd; 308alter table bar drop column bbb, drop column ccc, drop column ddd; 309source include/diff_tables.inc; 310drop table foo; drop table bar; 311