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 (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 14create table bar like foo; 15alter table bar engine=MyISAM; 16insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 17insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 18insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 19insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 20insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 21insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 22insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 23insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 24insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 25insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 26insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 27insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 28insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 29insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 30insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 31insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 32insert into bar select * from foo; 33source include/diff_tables.inc; 34alter table foo drop column a; 35alter table bar drop column a; 36source include/diff_tables.inc; 37drop table foo; drop table bar; 38 39 40create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 41create table bar like foo; 42alter table bar engine=MyISAM; 43insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 44insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 45insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 46insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 47insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 48insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 49insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 50insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 51insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 52insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 53insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 54insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 55insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 56insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 57insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 58insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 59insert into bar select * from foo; 60source include/diff_tables.inc; 61alter table foo drop column b; 62alter table bar drop column b; 63source include/diff_tables.inc; 64drop table foo; drop table bar; 65 66 67create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 68create table bar like foo; 69alter table bar engine=MyISAM; 70insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 71insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 72insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 73insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 74insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 75insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 76insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 77insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 78insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 79insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 80insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 81insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 82insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 83insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 84insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 85insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 86insert into bar select * from foo; 87source include/diff_tables.inc; 88alter table foo drop column c; 89alter table bar drop column c; 90source include/diff_tables.inc; 91drop table foo; drop table bar; 92 93 94create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 95create table bar like foo; 96alter table bar engine=MyISAM; 97insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 98insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 99insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 100insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 101insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 102insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 103insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 104insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 105insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 106insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 107insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 108insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 109insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 110insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 111insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 112insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 113insert into bar select * from foo; 114source include/diff_tables.inc; 115alter table foo drop column d; 116alter table bar drop column d; 117source include/diff_tables.inc; 118drop table foo; drop table bar; 119 120 121create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 122create table bar like foo; 123alter table bar engine=MyISAM; 124insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 125insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 126insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 127insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 128insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 129insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 130insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 131insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 132insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 133insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 134insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 135insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 136insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 137insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 138insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 139insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 140insert into bar select * from foo; 141source include/diff_tables.inc; 142alter table foo drop column aa; 143alter table bar drop column aa; 144source include/diff_tables.inc; 145drop table foo; drop table bar; 146 147 148create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 149create table bar like foo; 150alter table bar engine=MyISAM; 151insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 152insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 153insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 154insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 155insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 156insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 157insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 158insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 159insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 160insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 161insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 162insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 163insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 164insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 165insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 166insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 167insert into bar select * from foo; 168source include/diff_tables.inc; 169alter table foo drop column bb; 170alter table bar drop column bb; 171source include/diff_tables.inc; 172drop table foo; drop table bar; 173 174 175create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 176create table bar like foo; 177alter table bar engine=MyISAM; 178insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 179insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 180insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 181insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 182insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 183insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 184insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 185insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 186insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 187insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 188insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 189insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 190insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 191insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 192insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 193insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 194insert into bar select * from foo; 195source include/diff_tables.inc; 196alter table foo drop column cc; 197alter table bar drop column cc; 198source include/diff_tables.inc; 199drop table foo; drop table bar; 200 201 202create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 203create table bar like foo; 204alter table bar engine=MyISAM; 205insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 206insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 207insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 208insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 209insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 210insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 211insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 212insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 213insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 214insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 215insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 216insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 217insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 218insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 219insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 220insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 221insert into bar select * from foo; 222source include/diff_tables.inc; 223alter table foo drop column dd; 224alter table bar drop column dd; 225source include/diff_tables.inc; 226drop table foo; drop table bar; 227 228 229create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 230create table bar like foo; 231alter table bar engine=MyISAM; 232insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 233insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 234insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 235insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 236insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 237insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 238insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 239insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 240insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 241insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 242insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 243insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 244insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 245insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 246insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 247insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 248insert into bar select * from foo; 249source include/diff_tables.inc; 250alter table foo drop column a, drop column b; 251alter table bar drop column a, drop column b; 252source include/diff_tables.inc; 253drop table foo; drop table bar; 254 255 256create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 257create table bar like foo; 258alter table bar engine=MyISAM; 259insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 260insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 261insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 262insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 263insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 264insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 265insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 266insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 267insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 268insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 269insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 270insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 271insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 272insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 273insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 274insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 275insert into bar select * from foo; 276source include/diff_tables.inc; 277alter table foo drop column a, drop column c; 278alter table bar drop column a, drop column c; 279source include/diff_tables.inc; 280drop table foo; drop table bar; 281 282 283create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 284create table bar like foo; 285alter table bar engine=MyISAM; 286insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 287insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 288insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 289insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 290insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 291insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 292insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 293insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 294insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 295insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 296insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 297insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 298insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 299insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 300insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 301insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 302insert into bar select * from foo; 303source include/diff_tables.inc; 304alter table foo drop column a, drop column d; 305alter table bar drop column a, drop column d; 306source include/diff_tables.inc; 307drop table foo; drop table bar; 308 309 310create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 311create table bar like foo; 312alter table bar engine=MyISAM; 313insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 314insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 315insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 316insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 317insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 318insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 319insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 320insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 321insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 322insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 323insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 324insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 325insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 326insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 327insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 328insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 329insert into bar select * from foo; 330source include/diff_tables.inc; 331alter table foo drop column a, drop column aa; 332alter table bar drop column a, drop column aa; 333source include/diff_tables.inc; 334drop table foo; drop table bar; 335 336 337create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 338create table bar like foo; 339alter table bar engine=MyISAM; 340insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 341insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 342insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 343insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 344insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 345insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 346insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 347insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 348insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 349insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 350insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 351insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 352insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 353insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 354insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 355insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 356insert into bar select * from foo; 357source include/diff_tables.inc; 358alter table foo drop column a, drop column bb; 359alter table bar drop column a, drop column bb; 360source include/diff_tables.inc; 361drop table foo; drop table bar; 362 363 364create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 365create table bar like foo; 366alter table bar engine=MyISAM; 367insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 368insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 369insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 370insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 371insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 372insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 373insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 374insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 375insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 376insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 377insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 378insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 379insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 380insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 381insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 382insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 383insert into bar select * from foo; 384source include/diff_tables.inc; 385alter table foo drop column a, drop column cc; 386alter table bar drop column a, drop column cc; 387source include/diff_tables.inc; 388drop table foo; drop table bar; 389 390 391create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 392create table bar like foo; 393alter table bar engine=MyISAM; 394insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 395insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 396insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 397insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 398insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 399insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 400insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 401insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 402insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 403insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 404insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 405insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 406insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 407insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 408insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 409insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 410insert into bar select * from foo; 411source include/diff_tables.inc; 412alter table foo drop column a, drop column dd; 413alter table bar drop column a, drop column dd; 414source include/diff_tables.inc; 415drop table foo; drop table bar; 416 417 418create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 419create table bar like foo; 420alter table bar engine=MyISAM; 421insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 422insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 423insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 424insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 425insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 426insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 427insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 428insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 429insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 430insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 431insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 432insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 433insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 434insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 435insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 436insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 437insert into bar select * from foo; 438source include/diff_tables.inc; 439alter table foo drop column b, drop column a; 440alter table bar drop column b, drop column a; 441source include/diff_tables.inc; 442drop table foo; drop table bar; 443 444 445create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 446create table bar like foo; 447alter table bar engine=MyISAM; 448insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 449insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 450insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 451insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 452insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 453insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 454insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 455insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 456insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 457insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 458insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 459insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 460insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 461insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 462insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 463insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 464insert into bar select * from foo; 465source include/diff_tables.inc; 466alter table foo drop column b, drop column c; 467alter table bar drop column b, drop column c; 468source include/diff_tables.inc; 469drop table foo; drop table bar; 470 471 472create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 473create table bar like foo; 474alter table bar engine=MyISAM; 475insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 476insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 477insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 478insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 479insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 480insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 481insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 482insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 483insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 484insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 485insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 486insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 487insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 488insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 489insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 490insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 491insert into bar select * from foo; 492source include/diff_tables.inc; 493alter table foo drop column b, drop column d; 494alter table bar drop column b, drop column d; 495source include/diff_tables.inc; 496drop table foo; drop table bar; 497 498 499create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 500create table bar like foo; 501alter table bar engine=MyISAM; 502insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 503insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 504insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 505insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 506insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 507insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 508insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 509insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 510insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 511insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 512insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 513insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 514insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 515insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 516insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 517insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 518insert into bar select * from foo; 519source include/diff_tables.inc; 520alter table foo drop column b, drop column aa; 521alter table bar drop column b, drop column aa; 522source include/diff_tables.inc; 523drop table foo; drop table bar; 524 525 526create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 527create table bar like foo; 528alter table bar engine=MyISAM; 529insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 530insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 531insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 532insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 533insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 534insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 535insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 536insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 537insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 538insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 539insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 540insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 541insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 542insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 543insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 544insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 545insert into bar select * from foo; 546source include/diff_tables.inc; 547alter table foo drop column b, drop column bb; 548alter table bar drop column b, drop column bb; 549source include/diff_tables.inc; 550drop table foo; drop table bar; 551 552 553create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 554create table bar like foo; 555alter table bar engine=MyISAM; 556insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 557insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 558insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 559insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 560insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 561insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 562insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 563insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 564insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 565insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 566insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 567insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 568insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 569insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 570insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 571insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 572insert into bar select * from foo; 573source include/diff_tables.inc; 574alter table foo drop column b, drop column cc; 575alter table bar drop column b, drop column cc; 576source include/diff_tables.inc; 577drop table foo; drop table bar; 578 579 580create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 581create table bar like foo; 582alter table bar engine=MyISAM; 583insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 584insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 585insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 586insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 587insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 588insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 589insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 590insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 591insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 592insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 593insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 594insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 595insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 596insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 597insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 598insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 599insert into bar select * from foo; 600source include/diff_tables.inc; 601alter table foo drop column b, drop column dd; 602alter table bar drop column b, drop column dd; 603source include/diff_tables.inc; 604drop table foo; drop table bar; 605 606 607create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 608create table bar like foo; 609alter table bar engine=MyISAM; 610insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 611insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 612insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 613insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 614insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 615insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 616insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 617insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 618insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 619insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 620insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 621insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 622insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 623insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 624insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 625insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 626insert into bar select * from foo; 627source include/diff_tables.inc; 628alter table foo drop column c, drop column a; 629alter table bar drop column c, drop column a; 630source include/diff_tables.inc; 631drop table foo; drop table bar; 632 633 634create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 635create table bar like foo; 636alter table bar engine=MyISAM; 637insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 638insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 639insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 640insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 641insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 642insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 643insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 644insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 645insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 646insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 647insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 648insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 649insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 650insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 651insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 652insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 653insert into bar select * from foo; 654source include/diff_tables.inc; 655alter table foo drop column c, drop column b; 656alter table bar drop column c, drop column b; 657source include/diff_tables.inc; 658drop table foo; drop table bar; 659 660 661create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 662create table bar like foo; 663alter table bar engine=MyISAM; 664insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 665insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 666insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 667insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 668insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 669insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 670insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 671insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 672insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 673insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 674insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 675insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 676insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 677insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 678insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 679insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 680insert into bar select * from foo; 681source include/diff_tables.inc; 682alter table foo drop column c, drop column d; 683alter table bar drop column c, drop column d; 684source include/diff_tables.inc; 685drop table foo; drop table bar; 686 687 688create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 689create table bar like foo; 690alter table bar engine=MyISAM; 691insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 692insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 693insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 694insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 695insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 696insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 697insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 698insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 699insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 700insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 701insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 702insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 703insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 704insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 705insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 706insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 707insert into bar select * from foo; 708source include/diff_tables.inc; 709alter table foo drop column c, drop column aa; 710alter table bar drop column c, drop column aa; 711source include/diff_tables.inc; 712drop table foo; drop table bar; 713 714 715create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 716create table bar like foo; 717alter table bar engine=MyISAM; 718insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 719insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 720insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 721insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 722insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 723insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 724insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 725insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 726insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 727insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 728insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 729insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 730insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 731insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 732insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 733insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 734insert into bar select * from foo; 735source include/diff_tables.inc; 736alter table foo drop column c, drop column bb; 737alter table bar drop column c, drop column bb; 738source include/diff_tables.inc; 739drop table foo; drop table bar; 740 741 742create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 743create table bar like foo; 744alter table bar engine=MyISAM; 745insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 746insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 747insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 748insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 749insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 750insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 751insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 752insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 753insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 754insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 755insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 756insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 757insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 758insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 759insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 760insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 761insert into bar select * from foo; 762source include/diff_tables.inc; 763alter table foo drop column c, drop column cc; 764alter table bar drop column c, drop column cc; 765source include/diff_tables.inc; 766drop table foo; drop table bar; 767 768 769create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 770create table bar like foo; 771alter table bar engine=MyISAM; 772insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 773insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 774insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 775insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 776insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 777insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 778insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 779insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 780insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 781insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 782insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 783insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 784insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 785insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 786insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 787insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 788insert into bar select * from foo; 789source include/diff_tables.inc; 790alter table foo drop column c, drop column dd; 791alter table bar drop column c, drop column dd; 792source include/diff_tables.inc; 793drop table foo; drop table bar; 794 795 796create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 797create table bar like foo; 798alter table bar engine=MyISAM; 799insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 800insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 801insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 802insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 803insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 804insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 805insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 806insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 807insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 808insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 809insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 810insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 811insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 812insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 813insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 814insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 815insert into bar select * from foo; 816source include/diff_tables.inc; 817alter table foo drop column d, drop column a; 818alter table bar drop column d, drop column a; 819source include/diff_tables.inc; 820drop table foo; drop table bar; 821 822 823create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 824create table bar like foo; 825alter table bar engine=MyISAM; 826insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 827insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 828insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 829insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 830insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 831insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 832insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 833insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 834insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 835insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 836insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 837insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 838insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 839insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 840insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 841insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 842insert into bar select * from foo; 843source include/diff_tables.inc; 844alter table foo drop column d, drop column b; 845alter table bar drop column d, drop column b; 846source include/diff_tables.inc; 847drop table foo; drop table bar; 848 849 850create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 851create table bar like foo; 852alter table bar engine=MyISAM; 853insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 854insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 855insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 856insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 857insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 858insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 859insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 860insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 861insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 862insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 863insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 864insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 865insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 866insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 867insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 868insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 869insert into bar select * from foo; 870source include/diff_tables.inc; 871alter table foo drop column d, drop column c; 872alter table bar drop column d, drop column c; 873source include/diff_tables.inc; 874drop table foo; drop table bar; 875 876 877create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 878create table bar like foo; 879alter table bar engine=MyISAM; 880insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 881insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 882insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 883insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 884insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 885insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 886insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 887insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 888insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 889insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 890insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 891insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 892insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 893insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 894insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 895insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 896insert into bar select * from foo; 897source include/diff_tables.inc; 898alter table foo drop column d, drop column aa; 899alter table bar drop column d, drop column aa; 900source include/diff_tables.inc; 901drop table foo; drop table bar; 902 903 904create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 905create table bar like foo; 906alter table bar engine=MyISAM; 907insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 908insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 909insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 910insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 911insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 912insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 913insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 914insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 915insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 916insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 917insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 918insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 919insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 920insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 921insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 922insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 923insert into bar select * from foo; 924source include/diff_tables.inc; 925alter table foo drop column d, drop column bb; 926alter table bar drop column d, drop column bb; 927source include/diff_tables.inc; 928drop table foo; drop table bar; 929 930 931create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 932create table bar like foo; 933alter table bar engine=MyISAM; 934insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 935insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 936insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 937insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 938insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 939insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 940insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 941insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 942insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 943insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 944insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 945insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 946insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 947insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 948insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 949insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 950insert into bar select * from foo; 951source include/diff_tables.inc; 952alter table foo drop column d, drop column cc; 953alter table bar drop column d, drop column cc; 954source include/diff_tables.inc; 955drop table foo; drop table bar; 956 957 958create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 959create table bar like foo; 960alter table bar engine=MyISAM; 961insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 962insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 963insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 964insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 965insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 966insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 967insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 968insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 969insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 970insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 971insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 972insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 973insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 974insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 975insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 976insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 977insert into bar select * from foo; 978source include/diff_tables.inc; 979alter table foo drop column d, drop column dd; 980alter table bar drop column d, drop column dd; 981source include/diff_tables.inc; 982drop table foo; drop table bar; 983 984 985create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 986create table bar like foo; 987alter table bar engine=MyISAM; 988insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 989insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 990insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 991insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 992insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 993insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 994insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 995insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 996insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 997insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 998insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 999insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 1000insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 1001insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 1002insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 1003insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 1004insert into bar select * from foo; 1005source include/diff_tables.inc; 1006alter table foo drop column aa, drop column a; 1007alter table bar drop column aa, drop column a; 1008source include/diff_tables.inc; 1009drop table foo; drop table bar; 1010 1011 1012create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1013create table bar like foo; 1014alter table bar engine=MyISAM; 1015insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 1016insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 1017insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 1018insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 1019insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 1020insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 1021insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 1022insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 1023insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 1024insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 1025insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 1026insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 1027insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 1028insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 1029insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 1030insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 1031insert into bar select * from foo; 1032source include/diff_tables.inc; 1033alter table foo drop column aa, drop column b; 1034alter table bar drop column aa, drop column b; 1035source include/diff_tables.inc; 1036drop table foo; drop table bar; 1037 1038 1039create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1040create table bar like foo; 1041alter table bar engine=MyISAM; 1042insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 1043insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 1044insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 1045insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 1046insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 1047insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 1048insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 1049insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 1050insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 1051insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 1052insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 1053insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 1054insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 1055insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 1056insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 1057insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 1058insert into bar select * from foo; 1059source include/diff_tables.inc; 1060alter table foo drop column aa, drop column c; 1061alter table bar drop column aa, drop column c; 1062source include/diff_tables.inc; 1063drop table foo; drop table bar; 1064 1065 1066create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1067create table bar like foo; 1068alter table bar engine=MyISAM; 1069insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 1070insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 1071insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 1072insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 1073insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 1074insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 1075insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 1076insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 1077insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 1078insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 1079insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 1080insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 1081insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 1082insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 1083insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 1084insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 1085insert into bar select * from foo; 1086source include/diff_tables.inc; 1087alter table foo drop column aa, drop column d; 1088alter table bar drop column aa, drop column d; 1089source include/diff_tables.inc; 1090drop table foo; drop table bar; 1091 1092 1093create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1094create table bar like foo; 1095alter table bar engine=MyISAM; 1096insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 1097insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 1098insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 1099insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 1100insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 1101insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 1102insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 1103insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 1104insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 1105insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 1106insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 1107insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 1108insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 1109insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 1110insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 1111insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 1112insert into bar select * from foo; 1113source include/diff_tables.inc; 1114alter table foo drop column aa, drop column bb; 1115alter table bar drop column aa, drop column bb; 1116source include/diff_tables.inc; 1117drop table foo; drop table bar; 1118 1119 1120create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1121create table bar like foo; 1122alter table bar engine=MyISAM; 1123insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 1124insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 1125insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 1126insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 1127insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 1128insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 1129insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 1130insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 1131insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 1132insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 1133insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 1134insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 1135insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 1136insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 1137insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 1138insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 1139insert into bar select * from foo; 1140source include/diff_tables.inc; 1141alter table foo drop column aa, drop column cc; 1142alter table bar drop column aa, drop column cc; 1143source include/diff_tables.inc; 1144drop table foo; drop table bar; 1145 1146 1147create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1148create table bar like foo; 1149alter table bar engine=MyISAM; 1150insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 1151insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 1152insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 1153insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 1154insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 1155insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 1156insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 1157insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 1158insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 1159insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 1160insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 1161insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 1162insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 1163insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 1164insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 1165insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 1166insert into bar select * from foo; 1167source include/diff_tables.inc; 1168alter table foo drop column aa, drop column dd; 1169alter table bar drop column aa, drop column dd; 1170source include/diff_tables.inc; 1171drop table foo; drop table bar; 1172 1173 1174create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1175create table bar like foo; 1176alter table bar engine=MyISAM; 1177insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 1178insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 1179insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 1180insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 1181insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 1182insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 1183insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 1184insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 1185insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 1186insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 1187insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 1188insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 1189insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 1190insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 1191insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 1192insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 1193insert into bar select * from foo; 1194source include/diff_tables.inc; 1195alter table foo drop column bb, drop column a; 1196alter table bar drop column bb, drop column a; 1197source include/diff_tables.inc; 1198drop table foo; drop table bar; 1199 1200 1201create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1202create table bar like foo; 1203alter table bar engine=MyISAM; 1204insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 1205insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 1206insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 1207insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 1208insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 1209insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 1210insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 1211insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 1212insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 1213insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 1214insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 1215insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 1216insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 1217insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 1218insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 1219insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 1220insert into bar select * from foo; 1221source include/diff_tables.inc; 1222alter table foo drop column bb, drop column b; 1223alter table bar drop column bb, drop column b; 1224source include/diff_tables.inc; 1225drop table foo; drop table bar; 1226 1227 1228create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1229create table bar like foo; 1230alter table bar engine=MyISAM; 1231insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 1232insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 1233insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 1234insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 1235insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 1236insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 1237insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 1238insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 1239insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 1240insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 1241insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 1242insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 1243insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 1244insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 1245insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 1246insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 1247insert into bar select * from foo; 1248source include/diff_tables.inc; 1249alter table foo drop column bb, drop column c; 1250alter table bar drop column bb, drop column c; 1251source include/diff_tables.inc; 1252drop table foo; drop table bar; 1253 1254 1255create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1256create table bar like foo; 1257alter table bar engine=MyISAM; 1258insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 1259insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 1260insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 1261insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 1262insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 1263insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 1264insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 1265insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 1266insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 1267insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 1268insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 1269insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 1270insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 1271insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 1272insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 1273insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 1274insert into bar select * from foo; 1275source include/diff_tables.inc; 1276alter table foo drop column bb, drop column d; 1277alter table bar drop column bb, drop column d; 1278source include/diff_tables.inc; 1279drop table foo; drop table bar; 1280 1281 1282create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1283create table bar like foo; 1284alter table bar engine=MyISAM; 1285insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 1286insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 1287insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 1288insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 1289insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 1290insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 1291insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 1292insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 1293insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 1294insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 1295insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 1296insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 1297insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 1298insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 1299insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 1300insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 1301insert into bar select * from foo; 1302source include/diff_tables.inc; 1303alter table foo drop column bb, drop column aa; 1304alter table bar drop column bb, drop column aa; 1305source include/diff_tables.inc; 1306drop table foo; drop table bar; 1307 1308 1309create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1310create table bar like foo; 1311alter table bar engine=MyISAM; 1312insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 1313insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 1314insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 1315insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 1316insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 1317insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 1318insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 1319insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 1320insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 1321insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 1322insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 1323insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 1324insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 1325insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 1326insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 1327insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 1328insert into bar select * from foo; 1329source include/diff_tables.inc; 1330alter table foo drop column bb, drop column cc; 1331alter table bar drop column bb, drop column cc; 1332source include/diff_tables.inc; 1333drop table foo; drop table bar; 1334 1335 1336create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1337create table bar like foo; 1338alter table bar engine=MyISAM; 1339insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 1340insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 1341insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 1342insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 1343insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 1344insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 1345insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 1346insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 1347insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 1348insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 1349insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 1350insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 1351insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 1352insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 1353insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 1354insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 1355insert into bar select * from foo; 1356source include/diff_tables.inc; 1357alter table foo drop column bb, drop column dd; 1358alter table bar drop column bb, drop column dd; 1359source include/diff_tables.inc; 1360drop table foo; drop table bar; 1361 1362 1363create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1364create table bar like foo; 1365alter table bar engine=MyISAM; 1366insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 1367insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 1368insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 1369insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 1370insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 1371insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 1372insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 1373insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 1374insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 1375insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 1376insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 1377insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 1378insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 1379insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 1380insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 1381insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 1382insert into bar select * from foo; 1383source include/diff_tables.inc; 1384alter table foo drop column cc, drop column a; 1385alter table bar drop column cc, drop column a; 1386source include/diff_tables.inc; 1387drop table foo; drop table bar; 1388 1389 1390create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1391create table bar like foo; 1392alter table bar engine=MyISAM; 1393insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 1394insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 1395insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 1396insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 1397insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 1398insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 1399insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 1400insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 1401insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 1402insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 1403insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 1404insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 1405insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 1406insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 1407insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 1408insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 1409insert into bar select * from foo; 1410source include/diff_tables.inc; 1411alter table foo drop column cc, drop column b; 1412alter table bar drop column cc, drop column b; 1413source include/diff_tables.inc; 1414drop table foo; drop table bar; 1415 1416 1417create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1418create table bar like foo; 1419alter table bar engine=MyISAM; 1420insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 1421insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 1422insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 1423insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 1424insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 1425insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 1426insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 1427insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 1428insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 1429insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 1430insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 1431insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 1432insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 1433insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 1434insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 1435insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 1436insert into bar select * from foo; 1437source include/diff_tables.inc; 1438alter table foo drop column cc, drop column c; 1439alter table bar drop column cc, drop column c; 1440source include/diff_tables.inc; 1441drop table foo; drop table bar; 1442 1443 1444create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1445create table bar like foo; 1446alter table bar engine=MyISAM; 1447insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 1448insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 1449insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 1450insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 1451insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 1452insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 1453insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 1454insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 1455insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 1456insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 1457insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 1458insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 1459insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 1460insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 1461insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 1462insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 1463insert into bar select * from foo; 1464source include/diff_tables.inc; 1465alter table foo drop column cc, drop column d; 1466alter table bar drop column cc, drop column d; 1467source include/diff_tables.inc; 1468drop table foo; drop table bar; 1469 1470 1471create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1472create table bar like foo; 1473alter table bar engine=MyISAM; 1474insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 1475insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 1476insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 1477insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 1478insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 1479insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 1480insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 1481insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 1482insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 1483insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 1484insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 1485insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 1486insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 1487insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 1488insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 1489insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 1490insert into bar select * from foo; 1491source include/diff_tables.inc; 1492alter table foo drop column cc, drop column aa; 1493alter table bar drop column cc, drop column aa; 1494source include/diff_tables.inc; 1495drop table foo; drop table bar; 1496 1497 1498create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1499create table bar like foo; 1500alter table bar engine=MyISAM; 1501insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 1502insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 1503insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 1504insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 1505insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 1506insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 1507insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 1508insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 1509insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 1510insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 1511insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 1512insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 1513insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 1514insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 1515insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 1516insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 1517insert into bar select * from foo; 1518source include/diff_tables.inc; 1519alter table foo drop column cc, drop column bb; 1520alter table bar drop column cc, drop column bb; 1521source include/diff_tables.inc; 1522drop table foo; drop table bar; 1523 1524 1525create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1526create table bar like foo; 1527alter table bar engine=MyISAM; 1528insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 1529insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 1530insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 1531insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 1532insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 1533insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 1534insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 1535insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 1536insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 1537insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 1538insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 1539insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 1540insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 1541insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 1542insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 1543insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 1544insert into bar select * from foo; 1545source include/diff_tables.inc; 1546alter table foo drop column cc, drop column dd; 1547alter table bar drop column cc, drop column dd; 1548source include/diff_tables.inc; 1549drop table foo; drop table bar; 1550 1551 1552create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1553create table bar like foo; 1554alter table bar engine=MyISAM; 1555insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 1556insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 1557insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 1558insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 1559insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 1560insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 1561insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 1562insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 1563insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 1564insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 1565insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 1566insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 1567insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 1568insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 1569insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 1570insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 1571insert into bar select * from foo; 1572source include/diff_tables.inc; 1573alter table foo drop column dd, drop column a; 1574alter table bar drop column dd, drop column a; 1575source include/diff_tables.inc; 1576drop table foo; drop table bar; 1577 1578 1579create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1580create table bar like foo; 1581alter table bar engine=MyISAM; 1582insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 1583insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 1584insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 1585insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 1586insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 1587insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 1588insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 1589insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 1590insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 1591insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 1592insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 1593insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 1594insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 1595insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 1596insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 1597insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 1598insert into bar select * from foo; 1599source include/diff_tables.inc; 1600alter table foo drop column dd, drop column b; 1601alter table bar drop column dd, drop column b; 1602source include/diff_tables.inc; 1603drop table foo; drop table bar; 1604 1605 1606create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1607create table bar like foo; 1608alter table bar engine=MyISAM; 1609insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 1610insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 1611insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 1612insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 1613insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 1614insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 1615insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 1616insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 1617insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 1618insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 1619insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 1620insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 1621insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 1622insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 1623insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 1624insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 1625insert into bar select * from foo; 1626source include/diff_tables.inc; 1627alter table foo drop column dd, drop column c; 1628alter table bar drop column dd, drop column c; 1629source include/diff_tables.inc; 1630drop table foo; drop table bar; 1631 1632 1633create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1634create table bar like foo; 1635alter table bar engine=MyISAM; 1636insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 1637insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 1638insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 1639insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 1640insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 1641insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 1642insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 1643insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 1644insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 1645insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 1646insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 1647insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 1648insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 1649insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 1650insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 1651insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 1652insert into bar select * from foo; 1653source include/diff_tables.inc; 1654alter table foo drop column dd, drop column d; 1655alter table bar drop column dd, drop column d; 1656source include/diff_tables.inc; 1657drop table foo; drop table bar; 1658 1659 1660create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1661create table bar like foo; 1662alter table bar engine=MyISAM; 1663insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 1664insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 1665insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 1666insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 1667insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 1668insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 1669insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 1670insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 1671insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 1672insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 1673insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 1674insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 1675insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 1676insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 1677insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 1678insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 1679insert into bar select * from foo; 1680source include/diff_tables.inc; 1681alter table foo drop column dd, drop column aa; 1682alter table bar drop column dd, drop column aa; 1683source include/diff_tables.inc; 1684drop table foo; drop table bar; 1685 1686 1687create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1688create table bar like foo; 1689alter table bar engine=MyISAM; 1690insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 1691insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 1692insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 1693insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 1694insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 1695insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 1696insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 1697insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 1698insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 1699insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 1700insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 1701insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 1702insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 1703insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 1704insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 1705insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 1706insert into bar select * from foo; 1707source include/diff_tables.inc; 1708alter table foo drop column dd, drop column bb; 1709alter table bar drop column dd, drop column bb; 1710source include/diff_tables.inc; 1711drop table foo; drop table bar; 1712 1713 1714create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1715create table bar like foo; 1716alter table bar engine=MyISAM; 1717insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 1718insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 1719insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 1720insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 1721insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 1722insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 1723insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 1724insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 1725insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 1726insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 1727insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 1728insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 1729insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 1730insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 1731insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 1732insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 1733insert into bar select * from foo; 1734source include/diff_tables.inc; 1735alter table foo drop column dd, drop column cc; 1736alter table bar drop column dd, drop column cc; 1737source include/diff_tables.inc; 1738drop table foo; drop table bar; 1739 1740 1741create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1742create table bar like foo; 1743alter table bar engine=MyISAM; 1744insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 1745insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 1746insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 1747insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 1748insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 1749insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 1750insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 1751insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 1752insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 1753insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 1754insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 1755insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 1756insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 1757insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 1758insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 1759insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 1760insert into bar select * from foo; 1761source include/diff_tables.inc; 1762alter table foo drop column a, drop column b, drop column c; 1763alter table bar drop column a, drop column b, drop column c; 1764source include/diff_tables.inc; 1765drop table foo; drop table bar; 1766 1767 1768create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1769create table bar like foo; 1770alter table bar engine=MyISAM; 1771insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 1772insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 1773insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 1774insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 1775insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 1776insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 1777insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 1778insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 1779insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 1780insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 1781insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 1782insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 1783insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 1784insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 1785insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 1786insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 1787insert into bar select * from foo; 1788source include/diff_tables.inc; 1789alter table foo drop column a, drop column b, drop column d; 1790alter table bar drop column a, drop column b, drop column d; 1791source include/diff_tables.inc; 1792drop table foo; drop table bar; 1793 1794 1795create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1796create table bar like foo; 1797alter table bar engine=MyISAM; 1798insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 1799insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 1800insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 1801insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 1802insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 1803insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 1804insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 1805insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 1806insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 1807insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 1808insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 1809insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 1810insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 1811insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 1812insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 1813insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 1814insert into bar select * from foo; 1815source include/diff_tables.inc; 1816alter table foo drop column a, drop column c, drop column d; 1817alter table bar drop column a, drop column c, drop column d; 1818source include/diff_tables.inc; 1819drop table foo; drop table bar; 1820 1821 1822create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1823create table bar like foo; 1824alter table bar engine=MyISAM; 1825insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 1826insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 1827insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 1828insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 1829insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 1830insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 1831insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 1832insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 1833insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 1834insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 1835insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 1836insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 1837insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 1838insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 1839insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 1840insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 1841insert into bar select * from foo; 1842source include/diff_tables.inc; 1843alter table foo drop column b, drop column c, drop column d; 1844alter table bar drop column b, drop column c, drop column d; 1845source include/diff_tables.inc; 1846drop table foo; drop table bar; 1847 1848 1849create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1850create table bar like foo; 1851alter table bar engine=MyISAM; 1852insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 1853insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 1854insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 1855insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 1856insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 1857insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 1858insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 1859insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 1860insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 1861insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 1862insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 1863insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 1864insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 1865insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 1866insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 1867insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 1868insert into bar select * from foo; 1869source include/diff_tables.inc; 1870alter table foo drop column a, drop column b, drop column c, drop column d; 1871alter table bar drop column a, drop column b, drop column c, drop column d; 1872source include/diff_tables.inc; 1873drop table foo; drop table bar; 1874 1875 1876create table foo (a int, b bigint, c date, d tinyint, aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1877create table bar like foo; 1878alter table bar engine=MyISAM; 1879insert into foo values (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 1880insert into foo values (NULL,NULL,NULL,NULL,"adsf",NULL,"hjfdshj",NULL); 1881insert into foo values (NULL,NULL,NULL,NULL,NULL,"oifds",NULL,"fdsjfds"); 1882insert into foo values (NULL,NULL,NULL,NULL,"rewoiu","fds","fr","oiufdsrew"); 1883insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,NULL,NULL,NULL); 1884insert into foo values (-1,NULL,'2008-1-1',NULL,"adsf",NULL,"hjfdshj",NULL); 1885insert into foo values (-1,NULL,'2008-1-1',NULL,NULL,"oifds",NULL,"fdsjfds"); 1886insert into foo values (-1,NULL,'2008-1-1',NULL,"rewoiu","fds","fr","oiufdsrew"); 1887insert into foo values (NULL,12345678987,NULL,1,NULL,NULL,NULL,NULL); 1888insert into foo values (NULL,12345678987,NULL,1,"adsf",NULL,"hjfdshj",NULL); 1889insert into foo values (NULL,12345678987,NULL,1,NULL,"oifds",NULL,"fdsjfds"); 1890insert into foo values (NULL,12345678987,NULL,1,"rewoiu","fds","fr","oiufdsrew"); 1891insert into foo values (2,20,'1999-11-11',0,NULL,NULL,NULL,NULL); 1892insert into foo values (2,20,'1999-11-11',0,"adsf",NULL,"hjfdshj",NULL); 1893insert into foo values (2,20,'1999-11-11',0,NULL,"oifds",NULL,"fdsjfds"); 1894insert into foo values (2,20,'1999-11-11',0,"rewoiu","fds","fr","oiufdsrew"); 1895insert into bar select * from foo; 1896source include/diff_tables.inc; 1897alter table foo drop column aa, drop column bb, drop column cc, drop column dd; 1898alter table bar drop column aa, drop column bb, drop column cc, drop column dd; 1899source include/diff_tables.inc; 1900drop table foo; drop table bar; 1901