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 (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); 17insert into foo values ("adsf",NULL,"hjfdshj",NULL); 18insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 19insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 20insert into bar select * from foo; 21source include/diff_tables.inc; 22alter table foo add column added_1 bigint default NULL; 23alter table bar add column added_1 bigint default NULL; 24source include/diff_tables.inc; 25drop table foo; drop table bar; 26 27 28create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 29create table bar like foo; 30alter table bar engine=MyISAM; 31insert into foo values (NULL,NULL,NULL,NULL); 32insert into foo values ("adsf",NULL,"hjfdshj",NULL); 33insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 34insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 35insert into bar select * from foo; 36source include/diff_tables.inc; 37alter table foo add column added_2 bigint default -1; 38alter table bar add column added_2 bigint default -1; 39source include/diff_tables.inc; 40drop table foo; drop table bar; 41 42 43create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 44create table bar like foo; 45alter table bar engine=MyISAM; 46insert into foo values (NULL,NULL,NULL,NULL); 47insert into foo values ("adsf",NULL,"hjfdshj",NULL); 48insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 49insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 50insert into bar select * from foo; 51source include/diff_tables.inc; 52alter table foo add column added_3 bigint NOT NULL default -1; 53alter table bar add column added_3 bigint NOT NULL default -1; 54source include/diff_tables.inc; 55drop table foo; drop table bar; 56 57 58create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 59create table bar like foo; 60alter table bar engine=MyISAM; 61insert into foo values (NULL,NULL,NULL,NULL); 62insert into foo values ("adsf",NULL,"hjfdshj",NULL); 63insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 64insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 65insert into bar select * from foo; 66source include/diff_tables.inc; 67alter table foo add column added_4 varchar(10) default NULL; 68alter table bar add column added_4 varchar(10) default NULL; 69source include/diff_tables.inc; 70drop table foo; drop table bar; 71 72 73create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 74create table bar like foo; 75alter table bar engine=MyISAM; 76insert into foo values (NULL,NULL,NULL,NULL); 77insert into foo values ("adsf",NULL,"hjfdshj",NULL); 78insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 79insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 80insert into bar select * from foo; 81source include/diff_tables.inc; 82alter table foo add column added_5 varchar(10) default "qwerty"; 83alter table bar add column added_5 varchar(10) default "qwerty"; 84source include/diff_tables.inc; 85drop table foo; drop table bar; 86 87 88create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 89create table bar like foo; 90alter table bar engine=MyISAM; 91insert into foo values (NULL,NULL,NULL,NULL); 92insert into foo values ("adsf",NULL,"hjfdshj",NULL); 93insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 94insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 95insert into bar select * from foo; 96source include/diff_tables.inc; 97alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt"; 98alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt"; 99source include/diff_tables.inc; 100drop table foo; drop table bar; 101 102 103create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 104create table bar like foo; 105alter table bar engine=MyISAM; 106insert into foo values (NULL,NULL,NULL,NULL); 107insert into foo values ("adsf",NULL,"hjfdshj",NULL); 108insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 109insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 110insert into bar select * from foo; 111source include/diff_tables.inc; 112alter table foo add column added_7 text default NULL; 113alter table bar add column added_7 text default NULL; 114source include/diff_tables.inc; 115drop table foo; drop table bar; 116 117 118create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 119create table bar like foo; 120alter table bar engine=MyISAM; 121insert into foo values (NULL,NULL,NULL,NULL); 122insert into foo values ("adsf",NULL,"hjfdshj",NULL); 123insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 124insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 125insert into bar select * from foo; 126source include/diff_tables.inc; 127alter table foo add column added_8 mediumtext default NULL; 128alter table bar add column added_8 mediumtext default NULL; 129source include/diff_tables.inc; 130drop table foo; drop table bar; 131 132 133create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 134create table bar like foo; 135alter table bar engine=MyISAM; 136insert into foo values (NULL,NULL,NULL,NULL); 137insert into foo values ("adsf",NULL,"hjfdshj",NULL); 138insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 139insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 140insert into bar select * from foo; 141source include/diff_tables.inc; 142alter table foo add column added_1 bigint default NULL first; 143alter table bar add column added_1 bigint default NULL first; 144source include/diff_tables.inc; 145drop table foo; drop table bar; 146 147 148create table foo (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); 152insert into foo values ("adsf",NULL,"hjfdshj",NULL); 153insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 154insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 155insert into bar select * from foo; 156source include/diff_tables.inc; 157alter table foo add column added_2 bigint default -1 first; 158alter table bar add column added_2 bigint default -1 first; 159source include/diff_tables.inc; 160drop table foo; drop table bar; 161 162 163create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 164create table bar like foo; 165alter table bar engine=MyISAM; 166insert into foo values (NULL,NULL,NULL,NULL); 167insert into foo values ("adsf",NULL,"hjfdshj",NULL); 168insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 169insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 170insert into bar select * from foo; 171source include/diff_tables.inc; 172alter table foo add column added_3 bigint NOT NULL default -1 first; 173alter table bar add column added_3 bigint NOT NULL default -1 first; 174source include/diff_tables.inc; 175drop table foo; drop table bar; 176 177 178create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 179create table bar like foo; 180alter table bar engine=MyISAM; 181insert into foo values (NULL,NULL,NULL,NULL); 182insert into foo values ("adsf",NULL,"hjfdshj",NULL); 183insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 184insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 185insert into bar select * from foo; 186source include/diff_tables.inc; 187alter table foo add column added_4 varchar(10) default NULL first; 188alter table bar add column added_4 varchar(10) default NULL first; 189source include/diff_tables.inc; 190drop table foo; drop table bar; 191 192 193create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 194create table bar like foo; 195alter table bar engine=MyISAM; 196insert into foo values (NULL,NULL,NULL,NULL); 197insert into foo values ("adsf",NULL,"hjfdshj",NULL); 198insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 199insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 200insert into bar select * from foo; 201source include/diff_tables.inc; 202alter table foo add column added_5 varchar(10) default "qwerty" first; 203alter table bar add column added_5 varchar(10) default "qwerty" first; 204source include/diff_tables.inc; 205drop table foo; drop table bar; 206 207 208create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 209create table bar like foo; 210alter table bar engine=MyISAM; 211insert into foo values (NULL,NULL,NULL,NULL); 212insert into foo values ("adsf",NULL,"hjfdshj",NULL); 213insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 214insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 215insert into bar select * from foo; 216source include/diff_tables.inc; 217alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" first; 218alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" first; 219source include/diff_tables.inc; 220drop table foo; drop table bar; 221 222 223create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 224create table bar like foo; 225alter table bar engine=MyISAM; 226insert into foo values (NULL,NULL,NULL,NULL); 227insert into foo values ("adsf",NULL,"hjfdshj",NULL); 228insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 229insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 230insert into bar select * from foo; 231source include/diff_tables.inc; 232alter table foo add column added_7 text default NULL first; 233alter table bar add column added_7 text default NULL first; 234source include/diff_tables.inc; 235drop table foo; drop table bar; 236 237 238create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 239create table bar like foo; 240alter table bar engine=MyISAM; 241insert into foo values (NULL,NULL,NULL,NULL); 242insert into foo values ("adsf",NULL,"hjfdshj",NULL); 243insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 244insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 245insert into bar select * from foo; 246source include/diff_tables.inc; 247alter table foo add column added_8 mediumtext default NULL first; 248alter table bar add column added_8 mediumtext default NULL first; 249source include/diff_tables.inc; 250drop table foo; drop table bar; 251 252 253create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 254create table bar like foo; 255alter table bar engine=MyISAM; 256insert into foo values (NULL,NULL,NULL,NULL); 257insert into foo values ("adsf",NULL,"hjfdshj",NULL); 258insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 259insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 260insert into bar select * from foo; 261source include/diff_tables.inc; 262alter table foo add column added_1 bigint default NULL after bb; 263alter table bar add column added_1 bigint default NULL after bb; 264source include/diff_tables.inc; 265drop table foo; drop table bar; 266 267 268create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 269create table bar like foo; 270alter table bar engine=MyISAM; 271insert into foo values (NULL,NULL,NULL,NULL); 272insert into foo values ("adsf",NULL,"hjfdshj",NULL); 273insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 274insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 275insert into bar select * from foo; 276source include/diff_tables.inc; 277alter table foo add column added_2 bigint default -1 after bb; 278alter table bar add column added_2 bigint default -1 after bb; 279source include/diff_tables.inc; 280drop table foo; drop table bar; 281 282 283create table foo (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); 287insert into foo values ("adsf",NULL,"hjfdshj",NULL); 288insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 289insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 290insert into bar select * from foo; 291source include/diff_tables.inc; 292alter table foo add column added_3 bigint NOT NULL default -1 after bb; 293alter table bar add column added_3 bigint NOT NULL default -1 after bb; 294source include/diff_tables.inc; 295drop table foo; drop table bar; 296 297 298create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 299create table bar like foo; 300alter table bar engine=MyISAM; 301insert into foo values (NULL,NULL,NULL,NULL); 302insert into foo values ("adsf",NULL,"hjfdshj",NULL); 303insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 304insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 305insert into bar select * from foo; 306source include/diff_tables.inc; 307alter table foo add column added_4 varchar(10) default NULL after bb; 308alter table bar add column added_4 varchar(10) default NULL after bb; 309source include/diff_tables.inc; 310drop table foo; drop table bar; 311 312 313create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 314create table bar like foo; 315alter table bar engine=MyISAM; 316insert into foo values (NULL,NULL,NULL,NULL); 317insert into foo values ("adsf",NULL,"hjfdshj",NULL); 318insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 319insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 320insert into bar select * from foo; 321source include/diff_tables.inc; 322alter table foo add column added_5 varchar(10) default "qwerty" after bb; 323alter table bar add column added_5 varchar(10) default "qwerty" after bb; 324source include/diff_tables.inc; 325drop table foo; drop table bar; 326 327 328create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 329create table bar like foo; 330alter table bar engine=MyISAM; 331insert into foo values (NULL,NULL,NULL,NULL); 332insert into foo values ("adsf",NULL,"hjfdshj",NULL); 333insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 334insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 335insert into bar select * from foo; 336source include/diff_tables.inc; 337alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" after bb; 338alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" after bb; 339source include/diff_tables.inc; 340drop table foo; drop table bar; 341 342 343create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 344create table bar like foo; 345alter table bar engine=MyISAM; 346insert into foo values (NULL,NULL,NULL,NULL); 347insert into foo values ("adsf",NULL,"hjfdshj",NULL); 348insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 349insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 350insert into bar select * from foo; 351source include/diff_tables.inc; 352alter table foo add column added_7 text default NULL after bb; 353alter table bar add column added_7 text default NULL after bb; 354source include/diff_tables.inc; 355drop table foo; drop table bar; 356 357 358create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 359create table bar like foo; 360alter table bar engine=MyISAM; 361insert into foo values (NULL,NULL,NULL,NULL); 362insert into foo values ("adsf",NULL,"hjfdshj",NULL); 363insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 364insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 365insert into bar select * from foo; 366source include/diff_tables.inc; 367alter table foo add column added_8 mediumtext default NULL after bb; 368alter table bar add column added_8 mediumtext default NULL after bb; 369source include/diff_tables.inc; 370drop table foo; drop table bar; 371 372 373create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 374create table bar like foo; 375alter table bar engine=MyISAM; 376insert into foo values (NULL,NULL,NULL,NULL); 377insert into foo values ("adsf",NULL,"hjfdshj",NULL); 378insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 379insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 380insert into bar select * from foo; 381source include/diff_tables.inc; 382alter table foo add column added_1 bigint default NULL, add column added_11 bigint default NULL; 383alter table bar add column added_1 bigint default NULL, add column added_11 bigint default NULL; 384source include/diff_tables.inc; 385drop table foo; drop table bar; 386 387 388create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 389create table bar like foo; 390alter table bar engine=MyISAM; 391insert into foo values (NULL,NULL,NULL,NULL); 392insert into foo values ("adsf",NULL,"hjfdshj",NULL); 393insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 394insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 395insert into bar select * from foo; 396source include/diff_tables.inc; 397alter table foo add column added_1 bigint default NULL, add column added_21 bigint default 1234; 398alter table bar add column added_1 bigint default NULL, add column added_21 bigint default 1234; 399source include/diff_tables.inc; 400drop table foo; drop table bar; 401 402 403create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 404create table bar like foo; 405alter table bar engine=MyISAM; 406insert into foo values (NULL,NULL,NULL,NULL); 407insert into foo values ("adsf",NULL,"hjfdshj",NULL); 408insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 409insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 410insert into bar select * from foo; 411source include/diff_tables.inc; 412alter table foo add column added_1 bigint default NULL, add column added_31 bigint NOT NULL default 54; 413alter table bar add column added_1 bigint default NULL, add column added_31 bigint NOT NULL default 54; 414source include/diff_tables.inc; 415drop table foo; drop table bar; 416 417 418create table foo (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); 422insert into foo values ("adsf",NULL,"hjfdshj",NULL); 423insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 424insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 425insert into bar select * from foo; 426source include/diff_tables.inc; 427alter table foo add column added_1 bigint default NULL, add column added_41 varchar(10) default NULL; 428alter table bar add column added_1 bigint default NULL, add column added_41 varchar(10) default NULL; 429source include/diff_tables.inc; 430drop table foo; drop table bar; 431 432 433create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 434create table bar like foo; 435alter table bar engine=MyISAM; 436insert into foo values (NULL,NULL,NULL,NULL); 437insert into foo values ("adsf",NULL,"hjfdshj",NULL); 438insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 439insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 440insert into bar select * from foo; 441source include/diff_tables.inc; 442alter table foo add column added_1 bigint default NULL, add column added_51 varchar(10) default "abracadab"; 443alter table bar add column added_1 bigint default NULL, add column added_51 varchar(10) default "abracadab"; 444source include/diff_tables.inc; 445drop table foo; drop table bar; 446 447 448create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 449create table bar like foo; 450alter table bar engine=MyISAM; 451insert into foo values (NULL,NULL,NULL,NULL); 452insert into foo values ("adsf",NULL,"hjfdshj",NULL); 453insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 454insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 455insert into bar select * from foo; 456source include/diff_tables.inc; 457alter table foo add column added_1 bigint default NULL, add column added_61 varchar(10) NOT NULL default "abracadab"; 458alter table bar add column added_1 bigint default NULL, add column added_61 varchar(10) NOT NULL default "abracadab"; 459source include/diff_tables.inc; 460drop table foo; drop table bar; 461 462 463create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 464create table bar like foo; 465alter table bar engine=MyISAM; 466insert into foo values (NULL,NULL,NULL,NULL); 467insert into foo values ("adsf",NULL,"hjfdshj",NULL); 468insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 469insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 470insert into bar select * from foo; 471source include/diff_tables.inc; 472alter table foo add column added_1 bigint default NULL, add column added_71 text default NULL; 473alter table bar add column added_1 bigint default NULL, add column added_71 text default NULL; 474source include/diff_tables.inc; 475drop table foo; drop table bar; 476 477 478create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 479create table bar like foo; 480alter table bar engine=MyISAM; 481insert into foo values (NULL,NULL,NULL,NULL); 482insert into foo values ("adsf",NULL,"hjfdshj",NULL); 483insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 484insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 485insert into bar select * from foo; 486source include/diff_tables.inc; 487alter table foo add column added_1 bigint default NULL, add column added_81 mediumtext default NULL; 488alter table bar add column added_1 bigint default NULL, add column added_81 mediumtext default NULL; 489source include/diff_tables.inc; 490drop table foo; drop table bar; 491 492 493create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 494create table bar like foo; 495alter table bar engine=MyISAM; 496insert into foo values (NULL,NULL,NULL,NULL); 497insert into foo values ("adsf",NULL,"hjfdshj",NULL); 498insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 499insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 500insert into bar select * from foo; 501source include/diff_tables.inc; 502alter table foo add column added_2 bigint default -1, add column added_11 bigint default NULL; 503alter table bar add column added_2 bigint default -1, add column added_11 bigint default NULL; 504source include/diff_tables.inc; 505drop table foo; drop table bar; 506 507 508create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 509create table bar like foo; 510alter table bar engine=MyISAM; 511insert into foo values (NULL,NULL,NULL,NULL); 512insert into foo values ("adsf",NULL,"hjfdshj",NULL); 513insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 514insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 515insert into bar select * from foo; 516source include/diff_tables.inc; 517alter table foo add column added_2 bigint default -1, add column added_21 bigint default 1234; 518alter table bar add column added_2 bigint default -1, add column added_21 bigint default 1234; 519source include/diff_tables.inc; 520drop table foo; drop table bar; 521 522 523create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 524create table bar like foo; 525alter table bar engine=MyISAM; 526insert into foo values (NULL,NULL,NULL,NULL); 527insert into foo values ("adsf",NULL,"hjfdshj",NULL); 528insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 529insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 530insert into bar select * from foo; 531source include/diff_tables.inc; 532alter table foo add column added_2 bigint default -1, add column added_31 bigint NOT NULL default 54; 533alter table bar add column added_2 bigint default -1, add column added_31 bigint NOT NULL default 54; 534source include/diff_tables.inc; 535drop table foo; drop table bar; 536 537 538create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 539create table bar like foo; 540alter table bar engine=MyISAM; 541insert into foo values (NULL,NULL,NULL,NULL); 542insert into foo values ("adsf",NULL,"hjfdshj",NULL); 543insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 544insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 545insert into bar select * from foo; 546source include/diff_tables.inc; 547alter table foo add column added_2 bigint default -1, add column added_41 varchar(10) default NULL; 548alter table bar add column added_2 bigint default -1, add column added_41 varchar(10) default NULL; 549source include/diff_tables.inc; 550drop table foo; drop table bar; 551 552 553create table foo (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); 557insert into foo values ("adsf",NULL,"hjfdshj",NULL); 558insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 559insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 560insert into bar select * from foo; 561source include/diff_tables.inc; 562alter table foo add column added_2 bigint default -1, add column added_51 varchar(10) default "abracadab"; 563alter table bar add column added_2 bigint default -1, add column added_51 varchar(10) default "abracadab"; 564source include/diff_tables.inc; 565drop table foo; drop table bar; 566 567 568create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 569create table bar like foo; 570alter table bar engine=MyISAM; 571insert into foo values (NULL,NULL,NULL,NULL); 572insert into foo values ("adsf",NULL,"hjfdshj",NULL); 573insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 574insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 575insert into bar select * from foo; 576source include/diff_tables.inc; 577alter table foo add column added_2 bigint default -1, add column added_61 varchar(10) NOT NULL default "abracadab"; 578alter table bar add column added_2 bigint default -1, add column added_61 varchar(10) NOT NULL default "abracadab"; 579source include/diff_tables.inc; 580drop table foo; drop table bar; 581 582 583create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 584create table bar like foo; 585alter table bar engine=MyISAM; 586insert into foo values (NULL,NULL,NULL,NULL); 587insert into foo values ("adsf",NULL,"hjfdshj",NULL); 588insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 589insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 590insert into bar select * from foo; 591source include/diff_tables.inc; 592alter table foo add column added_2 bigint default -1, add column added_71 text default NULL; 593alter table bar add column added_2 bigint default -1, add column added_71 text default NULL; 594source include/diff_tables.inc; 595drop table foo; drop table bar; 596 597 598create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 599create table bar like foo; 600alter table bar engine=MyISAM; 601insert into foo values (NULL,NULL,NULL,NULL); 602insert into foo values ("adsf",NULL,"hjfdshj",NULL); 603insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 604insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 605insert into bar select * from foo; 606source include/diff_tables.inc; 607alter table foo add column added_2 bigint default -1, add column added_81 mediumtext default NULL; 608alter table bar add column added_2 bigint default -1, add column added_81 mediumtext default NULL; 609source include/diff_tables.inc; 610drop table foo; drop table bar; 611 612 613create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 614create table bar like foo; 615alter table bar engine=MyISAM; 616insert into foo values (NULL,NULL,NULL,NULL); 617insert into foo values ("adsf",NULL,"hjfdshj",NULL); 618insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 619insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 620insert into bar select * from foo; 621source include/diff_tables.inc; 622alter table foo add column added_3 bigint NOT NULL default -1, add column added_11 bigint default NULL; 623alter table bar add column added_3 bigint NOT NULL default -1, add column added_11 bigint default NULL; 624source include/diff_tables.inc; 625drop table foo; drop table bar; 626 627 628create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 629create table bar like foo; 630alter table bar engine=MyISAM; 631insert into foo values (NULL,NULL,NULL,NULL); 632insert into foo values ("adsf",NULL,"hjfdshj",NULL); 633insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 634insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 635insert into bar select * from foo; 636source include/diff_tables.inc; 637alter table foo add column added_3 bigint NOT NULL default -1, add column added_21 bigint default 1234; 638alter table bar add column added_3 bigint NOT NULL default -1, add column added_21 bigint default 1234; 639source include/diff_tables.inc; 640drop table foo; drop table bar; 641 642 643create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 644create table bar like foo; 645alter table bar engine=MyISAM; 646insert into foo values (NULL,NULL,NULL,NULL); 647insert into foo values ("adsf",NULL,"hjfdshj",NULL); 648insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 649insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 650insert into bar select * from foo; 651source include/diff_tables.inc; 652alter table foo add column added_3 bigint NOT NULL default -1, add column added_31 bigint NOT NULL default 54; 653alter table bar add column added_3 bigint NOT NULL default -1, add column added_31 bigint NOT NULL default 54; 654source include/diff_tables.inc; 655drop table foo; drop table bar; 656 657 658create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 659create table bar like foo; 660alter table bar engine=MyISAM; 661insert into foo values (NULL,NULL,NULL,NULL); 662insert into foo values ("adsf",NULL,"hjfdshj",NULL); 663insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 664insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 665insert into bar select * from foo; 666source include/diff_tables.inc; 667alter table foo add column added_3 bigint NOT NULL default -1, add column added_41 varchar(10) default NULL; 668alter table bar add column added_3 bigint NOT NULL default -1, add column added_41 varchar(10) default NULL; 669source include/diff_tables.inc; 670drop table foo; drop table bar; 671 672 673create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 674create table bar like foo; 675alter table bar engine=MyISAM; 676insert into foo values (NULL,NULL,NULL,NULL); 677insert into foo values ("adsf",NULL,"hjfdshj",NULL); 678insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 679insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 680insert into bar select * from foo; 681source include/diff_tables.inc; 682alter table foo add column added_3 bigint NOT NULL default -1, add column added_51 varchar(10) default "abracadab"; 683alter table bar add column added_3 bigint NOT NULL default -1, add column added_51 varchar(10) default "abracadab"; 684source include/diff_tables.inc; 685drop table foo; drop table bar; 686 687 688create table foo (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); 692insert into foo values ("adsf",NULL,"hjfdshj",NULL); 693insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 694insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 695insert into bar select * from foo; 696source include/diff_tables.inc; 697alter table foo add column added_3 bigint NOT NULL default -1, add column added_61 varchar(10) NOT NULL default "abracadab"; 698alter table bar add column added_3 bigint NOT NULL default -1, add column added_61 varchar(10) NOT NULL default "abracadab"; 699source include/diff_tables.inc; 700drop table foo; drop table bar; 701 702 703create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 704create table bar like foo; 705alter table bar engine=MyISAM; 706insert into foo values (NULL,NULL,NULL,NULL); 707insert into foo values ("adsf",NULL,"hjfdshj",NULL); 708insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 709insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 710insert into bar select * from foo; 711source include/diff_tables.inc; 712alter table foo add column added_3 bigint NOT NULL default -1, add column added_71 text default NULL; 713alter table bar add column added_3 bigint NOT NULL default -1, add column added_71 text default NULL; 714source include/diff_tables.inc; 715drop table foo; drop table bar; 716 717 718create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 719create table bar like foo; 720alter table bar engine=MyISAM; 721insert into foo values (NULL,NULL,NULL,NULL); 722insert into foo values ("adsf",NULL,"hjfdshj",NULL); 723insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 724insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 725insert into bar select * from foo; 726source include/diff_tables.inc; 727alter table foo add column added_3 bigint NOT NULL default -1, add column added_81 mediumtext default NULL; 728alter table bar add column added_3 bigint NOT NULL default -1, add column added_81 mediumtext default NULL; 729source include/diff_tables.inc; 730drop table foo; drop table bar; 731 732 733create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 734create table bar like foo; 735alter table bar engine=MyISAM; 736insert into foo values (NULL,NULL,NULL,NULL); 737insert into foo values ("adsf",NULL,"hjfdshj",NULL); 738insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 739insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 740insert into bar select * from foo; 741source include/diff_tables.inc; 742alter table foo add column added_4 varchar(10) default NULL, add column added_11 bigint default NULL; 743alter table bar add column added_4 varchar(10) default NULL, add column added_11 bigint default NULL; 744source include/diff_tables.inc; 745drop table foo; drop table bar; 746 747 748create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 749create table bar like foo; 750alter table bar engine=MyISAM; 751insert into foo values (NULL,NULL,NULL,NULL); 752insert into foo values ("adsf",NULL,"hjfdshj",NULL); 753insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 754insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 755insert into bar select * from foo; 756source include/diff_tables.inc; 757alter table foo add column added_4 varchar(10) default NULL, add column added_21 bigint default 1234; 758alter table bar add column added_4 varchar(10) default NULL, add column added_21 bigint default 1234; 759source include/diff_tables.inc; 760drop table foo; drop table bar; 761 762 763create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 764create table bar like foo; 765alter table bar engine=MyISAM; 766insert into foo values (NULL,NULL,NULL,NULL); 767insert into foo values ("adsf",NULL,"hjfdshj",NULL); 768insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 769insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 770insert into bar select * from foo; 771source include/diff_tables.inc; 772alter table foo add column added_4 varchar(10) default NULL, add column added_31 bigint NOT NULL default 54; 773alter table bar add column added_4 varchar(10) default NULL, add column added_31 bigint NOT NULL default 54; 774source include/diff_tables.inc; 775drop table foo; drop table bar; 776 777 778create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 779create table bar like foo; 780alter table bar engine=MyISAM; 781insert into foo values (NULL,NULL,NULL,NULL); 782insert into foo values ("adsf",NULL,"hjfdshj",NULL); 783insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 784insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 785insert into bar select * from foo; 786source include/diff_tables.inc; 787alter table foo add column added_4 varchar(10) default NULL, add column added_41 varchar(10) default NULL; 788alter table bar add column added_4 varchar(10) default NULL, add column added_41 varchar(10) default NULL; 789source include/diff_tables.inc; 790drop table foo; drop table bar; 791 792 793create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 794create table bar like foo; 795alter table bar engine=MyISAM; 796insert into foo values (NULL,NULL,NULL,NULL); 797insert into foo values ("adsf",NULL,"hjfdshj",NULL); 798insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 799insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 800insert into bar select * from foo; 801source include/diff_tables.inc; 802alter table foo add column added_4 varchar(10) default NULL, add column added_51 varchar(10) default "abracadab"; 803alter table bar add column added_4 varchar(10) default NULL, add column added_51 varchar(10) default "abracadab"; 804source include/diff_tables.inc; 805drop table foo; drop table bar; 806 807 808create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 809create table bar like foo; 810alter table bar engine=MyISAM; 811insert into foo values (NULL,NULL,NULL,NULL); 812insert into foo values ("adsf",NULL,"hjfdshj",NULL); 813insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 814insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 815insert into bar select * from foo; 816source include/diff_tables.inc; 817alter table foo add column added_4 varchar(10) default NULL, add column added_61 varchar(10) NOT NULL default "abracadab"; 818alter table bar add column added_4 varchar(10) default NULL, add column added_61 varchar(10) NOT NULL default "abracadab"; 819source include/diff_tables.inc; 820drop table foo; drop table bar; 821 822 823create table foo (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); 827insert into foo values ("adsf",NULL,"hjfdshj",NULL); 828insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 829insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 830insert into bar select * from foo; 831source include/diff_tables.inc; 832alter table foo add column added_4 varchar(10) default NULL, add column added_71 text default NULL; 833alter table bar add column added_4 varchar(10) default NULL, add column added_71 text default NULL; 834source include/diff_tables.inc; 835drop table foo; drop table bar; 836 837 838create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 839create table bar like foo; 840alter table bar engine=MyISAM; 841insert into foo values (NULL,NULL,NULL,NULL); 842insert into foo values ("adsf",NULL,"hjfdshj",NULL); 843insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 844insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 845insert into bar select * from foo; 846source include/diff_tables.inc; 847alter table foo add column added_4 varchar(10) default NULL, add column added_81 mediumtext default NULL; 848alter table bar add column added_4 varchar(10) default NULL, add column added_81 mediumtext default NULL; 849source include/diff_tables.inc; 850drop table foo; drop table bar; 851 852 853create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 854create table bar like foo; 855alter table bar engine=MyISAM; 856insert into foo values (NULL,NULL,NULL,NULL); 857insert into foo values ("adsf",NULL,"hjfdshj",NULL); 858insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 859insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 860insert into bar select * from foo; 861source include/diff_tables.inc; 862alter table foo add column added_5 varchar(10) default "qwerty", add column added_11 bigint default NULL; 863alter table bar add column added_5 varchar(10) default "qwerty", add column added_11 bigint default NULL; 864source include/diff_tables.inc; 865drop table foo; drop table bar; 866 867 868create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 869create table bar like foo; 870alter table bar engine=MyISAM; 871insert into foo values (NULL,NULL,NULL,NULL); 872insert into foo values ("adsf",NULL,"hjfdshj",NULL); 873insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 874insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 875insert into bar select * from foo; 876source include/diff_tables.inc; 877alter table foo add column added_5 varchar(10) default "qwerty", add column added_21 bigint default 1234; 878alter table bar add column added_5 varchar(10) default "qwerty", add column added_21 bigint default 1234; 879source include/diff_tables.inc; 880drop table foo; drop table bar; 881 882 883create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 884create table bar like foo; 885alter table bar engine=MyISAM; 886insert into foo values (NULL,NULL,NULL,NULL); 887insert into foo values ("adsf",NULL,"hjfdshj",NULL); 888insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 889insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 890insert into bar select * from foo; 891source include/diff_tables.inc; 892alter table foo add column added_5 varchar(10) default "qwerty", add column added_31 bigint NOT NULL default 54; 893alter table bar add column added_5 varchar(10) default "qwerty", add column added_31 bigint NOT NULL default 54; 894source include/diff_tables.inc; 895drop table foo; drop table bar; 896 897 898create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 899create table bar like foo; 900alter table bar engine=MyISAM; 901insert into foo values (NULL,NULL,NULL,NULL); 902insert into foo values ("adsf",NULL,"hjfdshj",NULL); 903insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 904insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 905insert into bar select * from foo; 906source include/diff_tables.inc; 907alter table foo add column added_5 varchar(10) default "qwerty", add column added_41 varchar(10) default NULL; 908alter table bar add column added_5 varchar(10) default "qwerty", add column added_41 varchar(10) default NULL; 909source include/diff_tables.inc; 910drop table foo; drop table bar; 911 912 913create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 914create table bar like foo; 915alter table bar engine=MyISAM; 916insert into foo values (NULL,NULL,NULL,NULL); 917insert into foo values ("adsf",NULL,"hjfdshj",NULL); 918insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 919insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 920insert into bar select * from foo; 921source include/diff_tables.inc; 922alter table foo add column added_5 varchar(10) default "qwerty", add column added_51 varchar(10) default "abracadab"; 923alter table bar add column added_5 varchar(10) default "qwerty", add column added_51 varchar(10) default "abracadab"; 924source include/diff_tables.inc; 925drop table foo; drop table bar; 926 927 928create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 929create table bar like foo; 930alter table bar engine=MyISAM; 931insert into foo values (NULL,NULL,NULL,NULL); 932insert into foo values ("adsf",NULL,"hjfdshj",NULL); 933insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 934insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 935insert into bar select * from foo; 936source include/diff_tables.inc; 937alter table foo add column added_5 varchar(10) default "qwerty", add column added_61 varchar(10) NOT NULL default "abracadab"; 938alter table bar add column added_5 varchar(10) default "qwerty", add column added_61 varchar(10) NOT NULL default "abracadab"; 939source include/diff_tables.inc; 940drop table foo; drop table bar; 941 942 943create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 944create table bar like foo; 945alter table bar engine=MyISAM; 946insert into foo values (NULL,NULL,NULL,NULL); 947insert into foo values ("adsf",NULL,"hjfdshj",NULL); 948insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 949insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 950insert into bar select * from foo; 951source include/diff_tables.inc; 952alter table foo add column added_5 varchar(10) default "qwerty", add column added_71 text default NULL; 953alter table bar add column added_5 varchar(10) default "qwerty", add column added_71 text default NULL; 954source include/diff_tables.inc; 955drop table foo; drop table bar; 956 957 958create table foo (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); 962insert into foo values ("adsf",NULL,"hjfdshj",NULL); 963insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 964insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 965insert into bar select * from foo; 966source include/diff_tables.inc; 967alter table foo add column added_5 varchar(10) default "qwerty", add column added_81 mediumtext default NULL; 968alter table bar add column added_5 varchar(10) default "qwerty", add column added_81 mediumtext default NULL; 969source include/diff_tables.inc; 970drop table foo; drop table bar; 971 972 973create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 974create table bar like foo; 975alter table bar engine=MyISAM; 976insert into foo values (NULL,NULL,NULL,NULL); 977insert into foo values ("adsf",NULL,"hjfdshj",NULL); 978insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 979insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 980insert into bar select * from foo; 981source include/diff_tables.inc; 982alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_11 bigint default NULL; 983alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_11 bigint default NULL; 984source include/diff_tables.inc; 985drop table foo; drop table bar; 986 987 988create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 989create table bar like foo; 990alter table bar engine=MyISAM; 991insert into foo values (NULL,NULL,NULL,NULL); 992insert into foo values ("adsf",NULL,"hjfdshj",NULL); 993insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 994insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 995insert into bar select * from foo; 996source include/diff_tables.inc; 997alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_21 bigint default 1234; 998alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_21 bigint default 1234; 999source include/diff_tables.inc; 1000drop table foo; drop table bar; 1001 1002 1003create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1004create table bar like foo; 1005alter table bar engine=MyISAM; 1006insert into foo values (NULL,NULL,NULL,NULL); 1007insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1008insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1009insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1010insert into bar select * from foo; 1011source include/diff_tables.inc; 1012alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_31 bigint NOT NULL default 54; 1013alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_31 bigint NOT NULL default 54; 1014source include/diff_tables.inc; 1015drop table foo; drop table bar; 1016 1017 1018create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1019create table bar like foo; 1020alter table bar engine=MyISAM; 1021insert into foo values (NULL,NULL,NULL,NULL); 1022insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1023insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1024insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1025insert into bar select * from foo; 1026source include/diff_tables.inc; 1027alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_41 varchar(10) default NULL; 1028alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_41 varchar(10) default NULL; 1029source include/diff_tables.inc; 1030drop table foo; drop table bar; 1031 1032 1033create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1034create table bar like foo; 1035alter table bar engine=MyISAM; 1036insert into foo values (NULL,NULL,NULL,NULL); 1037insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1038insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1039insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1040insert into bar select * from foo; 1041source include/diff_tables.inc; 1042alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_51 varchar(10) default "abracadab"; 1043alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_51 varchar(10) default "abracadab"; 1044source include/diff_tables.inc; 1045drop table foo; drop table bar; 1046 1047 1048create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1049create table bar like foo; 1050alter table bar engine=MyISAM; 1051insert into foo values (NULL,NULL,NULL,NULL); 1052insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1053insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1054insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1055insert into bar select * from foo; 1056source include/diff_tables.inc; 1057alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_61 varchar(10) NOT NULL default "abracadab"; 1058alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_61 varchar(10) NOT NULL default "abracadab"; 1059source include/diff_tables.inc; 1060drop table foo; drop table bar; 1061 1062 1063create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1064create table bar like foo; 1065alter table bar engine=MyISAM; 1066insert into foo values (NULL,NULL,NULL,NULL); 1067insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1068insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1069insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1070insert into bar select * from foo; 1071source include/diff_tables.inc; 1072alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_71 text default NULL; 1073alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_71 text default NULL; 1074source include/diff_tables.inc; 1075drop table foo; drop table bar; 1076 1077 1078create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1079create table bar like foo; 1080alter table bar engine=MyISAM; 1081insert into foo values (NULL,NULL,NULL,NULL); 1082insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1083insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1084insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1085insert into bar select * from foo; 1086source include/diff_tables.inc; 1087alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_81 mediumtext default NULL; 1088alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt", add column added_81 mediumtext default NULL; 1089source include/diff_tables.inc; 1090drop table foo; drop table bar; 1091 1092 1093create table foo (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); 1097insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1098insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1099insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1100insert into bar select * from foo; 1101source include/diff_tables.inc; 1102alter table foo add column added_7 text default NULL, add column added_11 bigint default NULL; 1103alter table bar add column added_7 text default NULL, add column added_11 bigint default NULL; 1104source include/diff_tables.inc; 1105drop table foo; drop table bar; 1106 1107 1108create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1109create table bar like foo; 1110alter table bar engine=MyISAM; 1111insert into foo values (NULL,NULL,NULL,NULL); 1112insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1113insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1114insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1115insert into bar select * from foo; 1116source include/diff_tables.inc; 1117alter table foo add column added_7 text default NULL, add column added_21 bigint default 1234; 1118alter table bar add column added_7 text default NULL, add column added_21 bigint default 1234; 1119source include/diff_tables.inc; 1120drop table foo; drop table bar; 1121 1122 1123create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1124create table bar like foo; 1125alter table bar engine=MyISAM; 1126insert into foo values (NULL,NULL,NULL,NULL); 1127insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1128insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1129insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1130insert into bar select * from foo; 1131source include/diff_tables.inc; 1132alter table foo add column added_7 text default NULL, add column added_31 bigint NOT NULL default 54; 1133alter table bar add column added_7 text default NULL, add column added_31 bigint NOT NULL default 54; 1134source include/diff_tables.inc; 1135drop table foo; drop table bar; 1136 1137 1138create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1139create table bar like foo; 1140alter table bar engine=MyISAM; 1141insert into foo values (NULL,NULL,NULL,NULL); 1142insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1143insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1144insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1145insert into bar select * from foo; 1146source include/diff_tables.inc; 1147alter table foo add column added_7 text default NULL, add column added_41 varchar(10) default NULL; 1148alter table bar add column added_7 text default NULL, add column added_41 varchar(10) default NULL; 1149source include/diff_tables.inc; 1150drop table foo; drop table bar; 1151 1152 1153create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1154create table bar like foo; 1155alter table bar engine=MyISAM; 1156insert into foo values (NULL,NULL,NULL,NULL); 1157insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1158insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1159insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1160insert into bar select * from foo; 1161source include/diff_tables.inc; 1162alter table foo add column added_7 text default NULL, add column added_51 varchar(10) default "abracadab"; 1163alter table bar add column added_7 text default NULL, add column added_51 varchar(10) default "abracadab"; 1164source include/diff_tables.inc; 1165drop table foo; drop table bar; 1166 1167 1168create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1169create table bar like foo; 1170alter table bar engine=MyISAM; 1171insert into foo values (NULL,NULL,NULL,NULL); 1172insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1173insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1174insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1175insert into bar select * from foo; 1176source include/diff_tables.inc; 1177alter table foo add column added_7 text default NULL, add column added_61 varchar(10) NOT NULL default "abracadab"; 1178alter table bar add column added_7 text default NULL, add column added_61 varchar(10) NOT NULL default "abracadab"; 1179source include/diff_tables.inc; 1180drop table foo; drop table bar; 1181 1182 1183create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1184create table bar like foo; 1185alter table bar engine=MyISAM; 1186insert into foo values (NULL,NULL,NULL,NULL); 1187insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1188insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1189insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1190insert into bar select * from foo; 1191source include/diff_tables.inc; 1192alter table foo add column added_7 text default NULL, add column added_71 text default NULL; 1193alter table bar add column added_7 text default NULL, add column added_71 text default NULL; 1194source include/diff_tables.inc; 1195drop table foo; drop table bar; 1196 1197 1198create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1199create table bar like foo; 1200alter table bar engine=MyISAM; 1201insert into foo values (NULL,NULL,NULL,NULL); 1202insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1203insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1204insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1205insert into bar select * from foo; 1206source include/diff_tables.inc; 1207alter table foo add column added_7 text default NULL, add column added_81 mediumtext default NULL; 1208alter table bar add column added_7 text default NULL, add column added_81 mediumtext default NULL; 1209source include/diff_tables.inc; 1210drop table foo; drop table bar; 1211 1212 1213create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1214create table bar like foo; 1215alter table bar engine=MyISAM; 1216insert into foo values (NULL,NULL,NULL,NULL); 1217insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1218insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1219insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1220insert into bar select * from foo; 1221source include/diff_tables.inc; 1222alter table foo add column added_8 mediumtext default NULL, add column added_11 bigint default NULL; 1223alter table bar add column added_8 mediumtext default NULL, add column added_11 bigint default NULL; 1224source include/diff_tables.inc; 1225drop table foo; drop table bar; 1226 1227 1228create table foo (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); 1232insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1233insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1234insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1235insert into bar select * from foo; 1236source include/diff_tables.inc; 1237alter table foo add column added_8 mediumtext default NULL, add column added_21 bigint default 1234; 1238alter table bar add column added_8 mediumtext default NULL, add column added_21 bigint default 1234; 1239source include/diff_tables.inc; 1240drop table foo; drop table bar; 1241 1242 1243create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1244create table bar like foo; 1245alter table bar engine=MyISAM; 1246insert into foo values (NULL,NULL,NULL,NULL); 1247insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1248insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1249insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1250insert into bar select * from foo; 1251source include/diff_tables.inc; 1252alter table foo add column added_8 mediumtext default NULL, add column added_31 bigint NOT NULL default 54; 1253alter table bar add column added_8 mediumtext default NULL, add column added_31 bigint NOT NULL default 54; 1254source include/diff_tables.inc; 1255drop table foo; drop table bar; 1256 1257 1258create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1259create table bar like foo; 1260alter table bar engine=MyISAM; 1261insert into foo values (NULL,NULL,NULL,NULL); 1262insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1263insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1264insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1265insert into bar select * from foo; 1266source include/diff_tables.inc; 1267alter table foo add column added_8 mediumtext default NULL, add column added_41 varchar(10) default NULL; 1268alter table bar add column added_8 mediumtext default NULL, add column added_41 varchar(10) default NULL; 1269source include/diff_tables.inc; 1270drop table foo; drop table bar; 1271 1272 1273create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1274create table bar like foo; 1275alter table bar engine=MyISAM; 1276insert into foo values (NULL,NULL,NULL,NULL); 1277insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1278insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1279insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1280insert into bar select * from foo; 1281source include/diff_tables.inc; 1282alter table foo add column added_8 mediumtext default NULL, add column added_51 varchar(10) default "abracadab"; 1283alter table bar add column added_8 mediumtext default NULL, add column added_51 varchar(10) default "abracadab"; 1284source include/diff_tables.inc; 1285drop table foo; drop table bar; 1286 1287 1288create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1289create table bar like foo; 1290alter table bar engine=MyISAM; 1291insert into foo values (NULL,NULL,NULL,NULL); 1292insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1293insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1294insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1295insert into bar select * from foo; 1296source include/diff_tables.inc; 1297alter table foo add column added_8 mediumtext default NULL, add column added_61 varchar(10) NOT NULL default "abracadab"; 1298alter table bar add column added_8 mediumtext default NULL, add column added_61 varchar(10) NOT NULL default "abracadab"; 1299source include/diff_tables.inc; 1300drop table foo; drop table bar; 1301 1302 1303create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1304create table bar like foo; 1305alter table bar engine=MyISAM; 1306insert into foo values (NULL,NULL,NULL,NULL); 1307insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1308insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1309insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1310insert into bar select * from foo; 1311source include/diff_tables.inc; 1312alter table foo add column added_8 mediumtext default NULL, add column added_71 text default NULL; 1313alter table bar add column added_8 mediumtext default NULL, add column added_71 text default NULL; 1314source include/diff_tables.inc; 1315drop table foo; drop table bar; 1316 1317 1318create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1319create table bar like foo; 1320alter table bar engine=MyISAM; 1321insert into foo values (NULL,NULL,NULL,NULL); 1322insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1323insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1324insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1325insert into bar select * from foo; 1326source include/diff_tables.inc; 1327alter table foo add column added_8 mediumtext default NULL, add column added_81 mediumtext default NULL; 1328alter table bar add column added_8 mediumtext default NULL, add column added_81 mediumtext default NULL; 1329source include/diff_tables.inc; 1330drop table foo; drop table bar; 1331 1332 1333create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1334create table bar like foo; 1335alter table bar engine=MyISAM; 1336insert into foo values (NULL,NULL,NULL,NULL); 1337insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1338insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1339insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1340insert into bar select * from foo; 1341source include/diff_tables.inc; 1342alter table foo add column added_1 bigint default NULL first, add column added_11 bigint default NULL; 1343alter table bar add column added_1 bigint default NULL first, add column added_11 bigint default NULL; 1344source include/diff_tables.inc; 1345drop table foo; drop table bar; 1346 1347 1348create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1349create table bar like foo; 1350alter table bar engine=MyISAM; 1351insert into foo values (NULL,NULL,NULL,NULL); 1352insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1353insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1354insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1355insert into bar select * from foo; 1356source include/diff_tables.inc; 1357alter table foo add column added_1 bigint default NULL first, add column added_21 bigint default 1234; 1358alter table bar add column added_1 bigint default NULL first, add column added_21 bigint default 1234; 1359source include/diff_tables.inc; 1360drop table foo; drop table bar; 1361 1362 1363create table foo (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); 1367insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1368insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1369insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1370insert into bar select * from foo; 1371source include/diff_tables.inc; 1372alter table foo add column added_1 bigint default NULL first, add column added_31 bigint NOT NULL default 54; 1373alter table bar add column added_1 bigint default NULL first, add column added_31 bigint NOT NULL default 54; 1374source include/diff_tables.inc; 1375drop table foo; drop table bar; 1376 1377 1378create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1379create table bar like foo; 1380alter table bar engine=MyISAM; 1381insert into foo values (NULL,NULL,NULL,NULL); 1382insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1383insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1384insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1385insert into bar select * from foo; 1386source include/diff_tables.inc; 1387alter table foo add column added_1 bigint default NULL first, add column added_41 varchar(10) default NULL; 1388alter table bar add column added_1 bigint default NULL first, add column added_41 varchar(10) default NULL; 1389source include/diff_tables.inc; 1390drop table foo; drop table bar; 1391 1392 1393create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1394create table bar like foo; 1395alter table bar engine=MyISAM; 1396insert into foo values (NULL,NULL,NULL,NULL); 1397insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1398insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1399insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1400insert into bar select * from foo; 1401source include/diff_tables.inc; 1402alter table foo add column added_1 bigint default NULL first, add column added_51 varchar(10) default "abracadab"; 1403alter table bar add column added_1 bigint default NULL first, add column added_51 varchar(10) default "abracadab"; 1404source include/diff_tables.inc; 1405drop table foo; drop table bar; 1406 1407 1408create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1409create table bar like foo; 1410alter table bar engine=MyISAM; 1411insert into foo values (NULL,NULL,NULL,NULL); 1412insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1413insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1414insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1415insert into bar select * from foo; 1416source include/diff_tables.inc; 1417alter table foo add column added_1 bigint default NULL first, add column added_61 varchar(10) NOT NULL default "abracadab"; 1418alter table bar add column added_1 bigint default NULL first, add column added_61 varchar(10) NOT NULL default "abracadab"; 1419source include/diff_tables.inc; 1420drop table foo; drop table bar; 1421 1422 1423create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1424create table bar like foo; 1425alter table bar engine=MyISAM; 1426insert into foo values (NULL,NULL,NULL,NULL); 1427insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1428insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1429insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1430insert into bar select * from foo; 1431source include/diff_tables.inc; 1432alter table foo add column added_1 bigint default NULL first, add column added_71 text default NULL; 1433alter table bar add column added_1 bigint default NULL first, add column added_71 text default NULL; 1434source include/diff_tables.inc; 1435drop table foo; drop table bar; 1436 1437 1438create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1439create table bar like foo; 1440alter table bar engine=MyISAM; 1441insert into foo values (NULL,NULL,NULL,NULL); 1442insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1443insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1444insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1445insert into bar select * from foo; 1446source include/diff_tables.inc; 1447alter table foo add column added_1 bigint default NULL first, add column added_81 mediumtext default NULL; 1448alter table bar add column added_1 bigint default NULL first, add column added_81 mediumtext default NULL; 1449source include/diff_tables.inc; 1450drop table foo; drop table bar; 1451 1452 1453create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1454create table bar like foo; 1455alter table bar engine=MyISAM; 1456insert into foo values (NULL,NULL,NULL,NULL); 1457insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1458insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1459insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1460insert into bar select * from foo; 1461source include/diff_tables.inc; 1462alter table foo add column added_2 bigint default -1 first, add column added_11 bigint default NULL; 1463alter table bar add column added_2 bigint default -1 first, add column added_11 bigint default NULL; 1464source include/diff_tables.inc; 1465drop table foo; drop table bar; 1466 1467 1468create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1469create table bar like foo; 1470alter table bar engine=MyISAM; 1471insert into foo values (NULL,NULL,NULL,NULL); 1472insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1473insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1474insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1475insert into bar select * from foo; 1476source include/diff_tables.inc; 1477alter table foo add column added_2 bigint default -1 first, add column added_21 bigint default 1234; 1478alter table bar add column added_2 bigint default -1 first, add column added_21 bigint default 1234; 1479source include/diff_tables.inc; 1480drop table foo; drop table bar; 1481 1482 1483create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1484create table bar like foo; 1485alter table bar engine=MyISAM; 1486insert into foo values (NULL,NULL,NULL,NULL); 1487insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1488insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1489insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1490insert into bar select * from foo; 1491source include/diff_tables.inc; 1492alter table foo add column added_2 bigint default -1 first, add column added_31 bigint NOT NULL default 54; 1493alter table bar add column added_2 bigint default -1 first, add column added_31 bigint NOT NULL default 54; 1494source include/diff_tables.inc; 1495drop table foo; drop table bar; 1496 1497 1498create table foo (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); 1502insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1503insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1504insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1505insert into bar select * from foo; 1506source include/diff_tables.inc; 1507alter table foo add column added_2 bigint default -1 first, add column added_41 varchar(10) default NULL; 1508alter table bar add column added_2 bigint default -1 first, add column added_41 varchar(10) default NULL; 1509source include/diff_tables.inc; 1510drop table foo; drop table bar; 1511 1512 1513create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1514create table bar like foo; 1515alter table bar engine=MyISAM; 1516insert into foo values (NULL,NULL,NULL,NULL); 1517insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1518insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1519insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1520insert into bar select * from foo; 1521source include/diff_tables.inc; 1522alter table foo add column added_2 bigint default -1 first, add column added_51 varchar(10) default "abracadab"; 1523alter table bar add column added_2 bigint default -1 first, add column added_51 varchar(10) default "abracadab"; 1524source include/diff_tables.inc; 1525drop table foo; drop table bar; 1526 1527 1528create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1529create table bar like foo; 1530alter table bar engine=MyISAM; 1531insert into foo values (NULL,NULL,NULL,NULL); 1532insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1533insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1534insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1535insert into bar select * from foo; 1536source include/diff_tables.inc; 1537alter table foo add column added_2 bigint default -1 first, add column added_61 varchar(10) NOT NULL default "abracadab"; 1538alter table bar add column added_2 bigint default -1 first, add column added_61 varchar(10) NOT NULL default "abracadab"; 1539source include/diff_tables.inc; 1540drop table foo; drop table bar; 1541 1542 1543create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1544create table bar like foo; 1545alter table bar engine=MyISAM; 1546insert into foo values (NULL,NULL,NULL,NULL); 1547insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1548insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1549insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1550insert into bar select * from foo; 1551source include/diff_tables.inc; 1552alter table foo add column added_2 bigint default -1 first, add column added_71 text default NULL; 1553alter table bar add column added_2 bigint default -1 first, add column added_71 text default NULL; 1554source include/diff_tables.inc; 1555drop table foo; drop table bar; 1556 1557 1558create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1559create table bar like foo; 1560alter table bar engine=MyISAM; 1561insert into foo values (NULL,NULL,NULL,NULL); 1562insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1563insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1564insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1565insert into bar select * from foo; 1566source include/diff_tables.inc; 1567alter table foo add column added_2 bigint default -1 first, add column added_81 mediumtext default NULL; 1568alter table bar add column added_2 bigint default -1 first, add column added_81 mediumtext default NULL; 1569source include/diff_tables.inc; 1570drop table foo; drop table bar; 1571 1572 1573create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1574create table bar like foo; 1575alter table bar engine=MyISAM; 1576insert into foo values (NULL,NULL,NULL,NULL); 1577insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1578insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1579insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1580insert into bar select * from foo; 1581source include/diff_tables.inc; 1582alter table foo add column added_3 bigint NOT NULL default -1 first, add column added_11 bigint default NULL; 1583alter table bar add column added_3 bigint NOT NULL default -1 first, add column added_11 bigint default NULL; 1584source include/diff_tables.inc; 1585drop table foo; drop table bar; 1586 1587 1588create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1589create table bar like foo; 1590alter table bar engine=MyISAM; 1591insert into foo values (NULL,NULL,NULL,NULL); 1592insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1593insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1594insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1595insert into bar select * from foo; 1596source include/diff_tables.inc; 1597alter table foo add column added_3 bigint NOT NULL default -1 first, add column added_21 bigint default 1234; 1598alter table bar add column added_3 bigint NOT NULL default -1 first, add column added_21 bigint default 1234; 1599source include/diff_tables.inc; 1600drop table foo; drop table bar; 1601 1602 1603create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1604create table bar like foo; 1605alter table bar engine=MyISAM; 1606insert into foo values (NULL,NULL,NULL,NULL); 1607insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1608insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1609insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1610insert into bar select * from foo; 1611source include/diff_tables.inc; 1612alter table foo add column added_3 bigint NOT NULL default -1 first, add column added_31 bigint NOT NULL default 54; 1613alter table bar add column added_3 bigint NOT NULL default -1 first, add column added_31 bigint NOT NULL default 54; 1614source include/diff_tables.inc; 1615drop table foo; drop table bar; 1616 1617 1618create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1619create table bar like foo; 1620alter table bar engine=MyISAM; 1621insert into foo values (NULL,NULL,NULL,NULL); 1622insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1623insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1624insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1625insert into bar select * from foo; 1626source include/diff_tables.inc; 1627alter table foo add column added_3 bigint NOT NULL default -1 first, add column added_41 varchar(10) default NULL; 1628alter table bar add column added_3 bigint NOT NULL default -1 first, add column added_41 varchar(10) default NULL; 1629source include/diff_tables.inc; 1630drop table foo; drop table bar; 1631 1632 1633create table foo (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); 1637insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1638insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1639insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1640insert into bar select * from foo; 1641source include/diff_tables.inc; 1642alter table foo add column added_3 bigint NOT NULL default -1 first, add column added_51 varchar(10) default "abracadab"; 1643alter table bar add column added_3 bigint NOT NULL default -1 first, add column added_51 varchar(10) default "abracadab"; 1644source include/diff_tables.inc; 1645drop table foo; drop table bar; 1646 1647 1648create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1649create table bar like foo; 1650alter table bar engine=MyISAM; 1651insert into foo values (NULL,NULL,NULL,NULL); 1652insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1653insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1654insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1655insert into bar select * from foo; 1656source include/diff_tables.inc; 1657alter table foo add column added_3 bigint NOT NULL default -1 first, add column added_61 varchar(10) NOT NULL default "abracadab"; 1658alter table bar add column added_3 bigint NOT NULL default -1 first, add column added_61 varchar(10) NOT NULL default "abracadab"; 1659source include/diff_tables.inc; 1660drop table foo; drop table bar; 1661 1662 1663create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1664create table bar like foo; 1665alter table bar engine=MyISAM; 1666insert into foo values (NULL,NULL,NULL,NULL); 1667insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1668insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1669insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1670insert into bar select * from foo; 1671source include/diff_tables.inc; 1672alter table foo add column added_3 bigint NOT NULL default -1 first, add column added_71 text default NULL; 1673alter table bar add column added_3 bigint NOT NULL default -1 first, add column added_71 text default NULL; 1674source include/diff_tables.inc; 1675drop table foo; drop table bar; 1676 1677 1678create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1679create table bar like foo; 1680alter table bar engine=MyISAM; 1681insert into foo values (NULL,NULL,NULL,NULL); 1682insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1683insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1684insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1685insert into bar select * from foo; 1686source include/diff_tables.inc; 1687alter table foo add column added_3 bigint NOT NULL default -1 first, add column added_81 mediumtext default NULL; 1688alter table bar add column added_3 bigint NOT NULL default -1 first, add column added_81 mediumtext default NULL; 1689source include/diff_tables.inc; 1690drop table foo; drop table bar; 1691 1692 1693create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1694create table bar like foo; 1695alter table bar engine=MyISAM; 1696insert into foo values (NULL,NULL,NULL,NULL); 1697insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1698insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1699insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1700insert into bar select * from foo; 1701source include/diff_tables.inc; 1702alter table foo add column added_4 varchar(10) default NULL first, add column added_11 bigint default NULL; 1703alter table bar add column added_4 varchar(10) default NULL first, add column added_11 bigint default NULL; 1704source include/diff_tables.inc; 1705drop table foo; drop table bar; 1706 1707 1708create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1709create table bar like foo; 1710alter table bar engine=MyISAM; 1711insert into foo values (NULL,NULL,NULL,NULL); 1712insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1713insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1714insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1715insert into bar select * from foo; 1716source include/diff_tables.inc; 1717alter table foo add column added_4 varchar(10) default NULL first, add column added_21 bigint default 1234; 1718alter table bar add column added_4 varchar(10) default NULL first, add column added_21 bigint default 1234; 1719source include/diff_tables.inc; 1720drop table foo; drop table bar; 1721 1722 1723create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1724create table bar like foo; 1725alter table bar engine=MyISAM; 1726insert into foo values (NULL,NULL,NULL,NULL); 1727insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1728insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1729insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1730insert into bar select * from foo; 1731source include/diff_tables.inc; 1732alter table foo add column added_4 varchar(10) default NULL first, add column added_31 bigint NOT NULL default 54; 1733alter table bar add column added_4 varchar(10) default NULL first, add column added_31 bigint NOT NULL default 54; 1734source include/diff_tables.inc; 1735drop table foo; drop table bar; 1736 1737 1738create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1739create table bar like foo; 1740alter table bar engine=MyISAM; 1741insert into foo values (NULL,NULL,NULL,NULL); 1742insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1743insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1744insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1745insert into bar select * from foo; 1746source include/diff_tables.inc; 1747alter table foo add column added_4 varchar(10) default NULL first, add column added_41 varchar(10) default NULL; 1748alter table bar add column added_4 varchar(10) default NULL first, add column added_41 varchar(10) default NULL; 1749source include/diff_tables.inc; 1750drop table foo; drop table bar; 1751 1752 1753create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1754create table bar like foo; 1755alter table bar engine=MyISAM; 1756insert into foo values (NULL,NULL,NULL,NULL); 1757insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1758insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1759insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1760insert into bar select * from foo; 1761source include/diff_tables.inc; 1762alter table foo add column added_4 varchar(10) default NULL first, add column added_51 varchar(10) default "abracadab"; 1763alter table bar add column added_4 varchar(10) default NULL first, add column added_51 varchar(10) default "abracadab"; 1764source include/diff_tables.inc; 1765drop table foo; drop table bar; 1766 1767 1768create table foo (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); 1772insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1773insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1774insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1775insert into bar select * from foo; 1776source include/diff_tables.inc; 1777alter table foo add column added_4 varchar(10) default NULL first, add column added_61 varchar(10) NOT NULL default "abracadab"; 1778alter table bar add column added_4 varchar(10) default NULL first, add column added_61 varchar(10) NOT NULL default "abracadab"; 1779source include/diff_tables.inc; 1780drop table foo; drop table bar; 1781 1782 1783create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1784create table bar like foo; 1785alter table bar engine=MyISAM; 1786insert into foo values (NULL,NULL,NULL,NULL); 1787insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1788insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1789insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1790insert into bar select * from foo; 1791source include/diff_tables.inc; 1792alter table foo add column added_4 varchar(10) default NULL first, add column added_71 text default NULL; 1793alter table bar add column added_4 varchar(10) default NULL first, add column added_71 text default NULL; 1794source include/diff_tables.inc; 1795drop table foo; drop table bar; 1796 1797 1798create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1799create table bar like foo; 1800alter table bar engine=MyISAM; 1801insert into foo values (NULL,NULL,NULL,NULL); 1802insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1803insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1804insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1805insert into bar select * from foo; 1806source include/diff_tables.inc; 1807alter table foo add column added_4 varchar(10) default NULL first, add column added_81 mediumtext default NULL; 1808alter table bar add column added_4 varchar(10) default NULL first, add column added_81 mediumtext default NULL; 1809source include/diff_tables.inc; 1810drop table foo; drop table bar; 1811 1812 1813create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1814create table bar like foo; 1815alter table bar engine=MyISAM; 1816insert into foo values (NULL,NULL,NULL,NULL); 1817insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1818insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1819insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1820insert into bar select * from foo; 1821source include/diff_tables.inc; 1822alter table foo add column added_5 varchar(10) default "qwerty" first, add column added_11 bigint default NULL; 1823alter table bar add column added_5 varchar(10) default "qwerty" first, add column added_11 bigint default NULL; 1824source include/diff_tables.inc; 1825drop table foo; drop table bar; 1826 1827 1828create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1829create table bar like foo; 1830alter table bar engine=MyISAM; 1831insert into foo values (NULL,NULL,NULL,NULL); 1832insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1833insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1834insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1835insert into bar select * from foo; 1836source include/diff_tables.inc; 1837alter table foo add column added_5 varchar(10) default "qwerty" first, add column added_21 bigint default 1234; 1838alter table bar add column added_5 varchar(10) default "qwerty" first, add column added_21 bigint default 1234; 1839source include/diff_tables.inc; 1840drop table foo; drop table bar; 1841 1842 1843create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1844create table bar like foo; 1845alter table bar engine=MyISAM; 1846insert into foo values (NULL,NULL,NULL,NULL); 1847insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1848insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1849insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1850insert into bar select * from foo; 1851source include/diff_tables.inc; 1852alter table foo add column added_5 varchar(10) default "qwerty" first, add column added_31 bigint NOT NULL default 54; 1853alter table bar add column added_5 varchar(10) default "qwerty" first, add column added_31 bigint NOT NULL default 54; 1854source include/diff_tables.inc; 1855drop table foo; drop table bar; 1856 1857 1858create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1859create table bar like foo; 1860alter table bar engine=MyISAM; 1861insert into foo values (NULL,NULL,NULL,NULL); 1862insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1863insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1864insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1865insert into bar select * from foo; 1866source include/diff_tables.inc; 1867alter table foo add column added_5 varchar(10) default "qwerty" first, add column added_41 varchar(10) default NULL; 1868alter table bar add column added_5 varchar(10) default "qwerty" first, add column added_41 varchar(10) default NULL; 1869source include/diff_tables.inc; 1870drop table foo; drop table bar; 1871 1872 1873create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1874create table bar like foo; 1875alter table bar engine=MyISAM; 1876insert into foo values (NULL,NULL,NULL,NULL); 1877insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1878insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1879insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1880insert into bar select * from foo; 1881source include/diff_tables.inc; 1882alter table foo add column added_5 varchar(10) default "qwerty" first, add column added_51 varchar(10) default "abracadab"; 1883alter table bar add column added_5 varchar(10) default "qwerty" first, add column added_51 varchar(10) default "abracadab"; 1884source include/diff_tables.inc; 1885drop table foo; drop table bar; 1886 1887 1888create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1889create table bar like foo; 1890alter table bar engine=MyISAM; 1891insert into foo values (NULL,NULL,NULL,NULL); 1892insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1893insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1894insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1895insert into bar select * from foo; 1896source include/diff_tables.inc; 1897alter table foo add column added_5 varchar(10) default "qwerty" first, add column added_61 varchar(10) NOT NULL default "abracadab"; 1898alter table bar add column added_5 varchar(10) default "qwerty" first, add column added_61 varchar(10) NOT NULL default "abracadab"; 1899source include/diff_tables.inc; 1900drop table foo; drop table bar; 1901 1902 1903create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1904create table bar like foo; 1905alter table bar engine=MyISAM; 1906insert into foo values (NULL,NULL,NULL,NULL); 1907insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1908insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1909insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1910insert into bar select * from foo; 1911source include/diff_tables.inc; 1912alter table foo add column added_5 varchar(10) default "qwerty" first, add column added_71 text default NULL; 1913alter table bar add column added_5 varchar(10) default "qwerty" first, add column added_71 text default NULL; 1914source include/diff_tables.inc; 1915drop table foo; drop table bar; 1916 1917 1918create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1919create table bar like foo; 1920alter table bar engine=MyISAM; 1921insert into foo values (NULL,NULL,NULL,NULL); 1922insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1923insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1924insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1925insert into bar select * from foo; 1926source include/diff_tables.inc; 1927alter table foo add column added_5 varchar(10) default "qwerty" first, add column added_81 mediumtext default NULL; 1928alter table bar add column added_5 varchar(10) default "qwerty" first, add column added_81 mediumtext default NULL; 1929source include/diff_tables.inc; 1930drop table foo; drop table bar; 1931 1932 1933create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1934create table bar like foo; 1935alter table bar engine=MyISAM; 1936insert into foo values (NULL,NULL,NULL,NULL); 1937insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1938insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1939insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1940insert into bar select * from foo; 1941source include/diff_tables.inc; 1942alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_11 bigint default NULL; 1943alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_11 bigint default NULL; 1944source include/diff_tables.inc; 1945drop table foo; drop table bar; 1946 1947 1948create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1949create table bar like foo; 1950alter table bar engine=MyISAM; 1951insert into foo values (NULL,NULL,NULL,NULL); 1952insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1953insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1954insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1955insert into bar select * from foo; 1956source include/diff_tables.inc; 1957alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_21 bigint default 1234; 1958alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_21 bigint default 1234; 1959source include/diff_tables.inc; 1960drop table foo; drop table bar; 1961 1962 1963create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1964create table bar like foo; 1965alter table bar engine=MyISAM; 1966insert into foo values (NULL,NULL,NULL,NULL); 1967insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1968insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1969insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1970insert into bar select * from foo; 1971source include/diff_tables.inc; 1972alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_31 bigint NOT NULL default 54; 1973alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_31 bigint NOT NULL default 54; 1974source include/diff_tables.inc; 1975drop table foo; drop table bar; 1976 1977 1978create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1979create table bar like foo; 1980alter table bar engine=MyISAM; 1981insert into foo values (NULL,NULL,NULL,NULL); 1982insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1983insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1984insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 1985insert into bar select * from foo; 1986source include/diff_tables.inc; 1987alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_41 varchar(10) default NULL; 1988alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_41 varchar(10) default NULL; 1989source include/diff_tables.inc; 1990drop table foo; drop table bar; 1991 1992 1993create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 1994create table bar like foo; 1995alter table bar engine=MyISAM; 1996insert into foo values (NULL,NULL,NULL,NULL); 1997insert into foo values ("adsf",NULL,"hjfdshj",NULL); 1998insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 1999insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2000insert into bar select * from foo; 2001source include/diff_tables.inc; 2002alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_51 varchar(10) default "abracadab"; 2003alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_51 varchar(10) default "abracadab"; 2004source include/diff_tables.inc; 2005drop table foo; drop table bar; 2006 2007 2008create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2009create table bar like foo; 2010alter table bar engine=MyISAM; 2011insert into foo values (NULL,NULL,NULL,NULL); 2012insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2013insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2014insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2015insert into bar select * from foo; 2016source include/diff_tables.inc; 2017alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_61 varchar(10) NOT NULL default "abracadab"; 2018alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_61 varchar(10) NOT NULL default "abracadab"; 2019source include/diff_tables.inc; 2020drop table foo; drop table bar; 2021 2022 2023create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2024create table bar like foo; 2025alter table bar engine=MyISAM; 2026insert into foo values (NULL,NULL,NULL,NULL); 2027insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2028insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2029insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2030insert into bar select * from foo; 2031source include/diff_tables.inc; 2032alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_71 text default NULL; 2033alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_71 text default NULL; 2034source include/diff_tables.inc; 2035drop table foo; drop table bar; 2036 2037 2038create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2039create table bar like foo; 2040alter table bar engine=MyISAM; 2041insert into foo values (NULL,NULL,NULL,NULL); 2042insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2043insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2044insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2045insert into bar select * from foo; 2046source include/diff_tables.inc; 2047alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_81 mediumtext default NULL; 2048alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" first, add column added_81 mediumtext default NULL; 2049source include/diff_tables.inc; 2050drop table foo; drop table bar; 2051 2052 2053create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2054create table bar like foo; 2055alter table bar engine=MyISAM; 2056insert into foo values (NULL,NULL,NULL,NULL); 2057insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2058insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2059insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2060insert into bar select * from foo; 2061source include/diff_tables.inc; 2062alter table foo add column added_7 text default NULL first, add column added_11 bigint default NULL; 2063alter table bar add column added_7 text default NULL first, add column added_11 bigint default NULL; 2064source include/diff_tables.inc; 2065drop table foo; drop table bar; 2066 2067 2068create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2069create table bar like foo; 2070alter table bar engine=MyISAM; 2071insert into foo values (NULL,NULL,NULL,NULL); 2072insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2073insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2074insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2075insert into bar select * from foo; 2076source include/diff_tables.inc; 2077alter table foo add column added_7 text default NULL first, add column added_21 bigint default 1234; 2078alter table bar add column added_7 text default NULL first, add column added_21 bigint default 1234; 2079source include/diff_tables.inc; 2080drop table foo; drop table bar; 2081 2082 2083create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2084create table bar like foo; 2085alter table bar engine=MyISAM; 2086insert into foo values (NULL,NULL,NULL,NULL); 2087insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2088insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2089insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2090insert into bar select * from foo; 2091source include/diff_tables.inc; 2092alter table foo add column added_7 text default NULL first, add column added_31 bigint NOT NULL default 54; 2093alter table bar add column added_7 text default NULL first, add column added_31 bigint NOT NULL default 54; 2094source include/diff_tables.inc; 2095drop table foo; drop table bar; 2096 2097 2098create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2099create table bar like foo; 2100alter table bar engine=MyISAM; 2101insert into foo values (NULL,NULL,NULL,NULL); 2102insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2103insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2104insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2105insert into bar select * from foo; 2106source include/diff_tables.inc; 2107alter table foo add column added_7 text default NULL first, add column added_41 varchar(10) default NULL; 2108alter table bar add column added_7 text default NULL first, add column added_41 varchar(10) default NULL; 2109source include/diff_tables.inc; 2110drop table foo; drop table bar; 2111 2112 2113create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2114create table bar like foo; 2115alter table bar engine=MyISAM; 2116insert into foo values (NULL,NULL,NULL,NULL); 2117insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2118insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2119insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2120insert into bar select * from foo; 2121source include/diff_tables.inc; 2122alter table foo add column added_7 text default NULL first, add column added_51 varchar(10) default "abracadab"; 2123alter table bar add column added_7 text default NULL first, add column added_51 varchar(10) default "abracadab"; 2124source include/diff_tables.inc; 2125drop table foo; drop table bar; 2126 2127 2128create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2129create table bar like foo; 2130alter table bar engine=MyISAM; 2131insert into foo values (NULL,NULL,NULL,NULL); 2132insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2133insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2134insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2135insert into bar select * from foo; 2136source include/diff_tables.inc; 2137alter table foo add column added_7 text default NULL first, add column added_61 varchar(10) NOT NULL default "abracadab"; 2138alter table bar add column added_7 text default NULL first, add column added_61 varchar(10) NOT NULL default "abracadab"; 2139source include/diff_tables.inc; 2140drop table foo; drop table bar; 2141 2142 2143create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2144create table bar like foo; 2145alter table bar engine=MyISAM; 2146insert into foo values (NULL,NULL,NULL,NULL); 2147insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2148insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2149insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2150insert into bar select * from foo; 2151source include/diff_tables.inc; 2152alter table foo add column added_7 text default NULL first, add column added_71 text default NULL; 2153alter table bar add column added_7 text default NULL first, add column added_71 text default NULL; 2154source include/diff_tables.inc; 2155drop table foo; drop table bar; 2156 2157 2158create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2159create table bar like foo; 2160alter table bar engine=MyISAM; 2161insert into foo values (NULL,NULL,NULL,NULL); 2162insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2163insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2164insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2165insert into bar select * from foo; 2166source include/diff_tables.inc; 2167alter table foo add column added_7 text default NULL first, add column added_81 mediumtext default NULL; 2168alter table bar add column added_7 text default NULL first, add column added_81 mediumtext default NULL; 2169source include/diff_tables.inc; 2170drop table foo; drop table bar; 2171 2172 2173create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2174create table bar like foo; 2175alter table bar engine=MyISAM; 2176insert into foo values (NULL,NULL,NULL,NULL); 2177insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2178insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2179insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2180insert into bar select * from foo; 2181source include/diff_tables.inc; 2182alter table foo add column added_8 mediumtext default NULL first, add column added_11 bigint default NULL; 2183alter table bar add column added_8 mediumtext default NULL first, add column added_11 bigint default NULL; 2184source include/diff_tables.inc; 2185drop table foo; drop table bar; 2186 2187 2188create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2189create table bar like foo; 2190alter table bar engine=MyISAM; 2191insert into foo values (NULL,NULL,NULL,NULL); 2192insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2193insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2194insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2195insert into bar select * from foo; 2196source include/diff_tables.inc; 2197alter table foo add column added_8 mediumtext default NULL first, add column added_21 bigint default 1234; 2198alter table bar add column added_8 mediumtext default NULL first, add column added_21 bigint default 1234; 2199source include/diff_tables.inc; 2200drop table foo; drop table bar; 2201 2202 2203create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2204create table bar like foo; 2205alter table bar engine=MyISAM; 2206insert into foo values (NULL,NULL,NULL,NULL); 2207insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2208insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2209insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2210insert into bar select * from foo; 2211source include/diff_tables.inc; 2212alter table foo add column added_8 mediumtext default NULL first, add column added_31 bigint NOT NULL default 54; 2213alter table bar add column added_8 mediumtext default NULL first, add column added_31 bigint NOT NULL default 54; 2214source include/diff_tables.inc; 2215drop table foo; drop table bar; 2216 2217 2218create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2219create table bar like foo; 2220alter table bar engine=MyISAM; 2221insert into foo values (NULL,NULL,NULL,NULL); 2222insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2223insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2224insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2225insert into bar select * from foo; 2226source include/diff_tables.inc; 2227alter table foo add column added_8 mediumtext default NULL first, add column added_41 varchar(10) default NULL; 2228alter table bar add column added_8 mediumtext default NULL first, add column added_41 varchar(10) default NULL; 2229source include/diff_tables.inc; 2230drop table foo; drop table bar; 2231 2232 2233create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2234create table bar like foo; 2235alter table bar engine=MyISAM; 2236insert into foo values (NULL,NULL,NULL,NULL); 2237insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2238insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2239insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2240insert into bar select * from foo; 2241source include/diff_tables.inc; 2242alter table foo add column added_8 mediumtext default NULL first, add column added_51 varchar(10) default "abracadab"; 2243alter table bar add column added_8 mediumtext default NULL first, add column added_51 varchar(10) default "abracadab"; 2244source include/diff_tables.inc; 2245drop table foo; drop table bar; 2246 2247 2248create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2249create table bar like foo; 2250alter table bar engine=MyISAM; 2251insert into foo values (NULL,NULL,NULL,NULL); 2252insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2253insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2254insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2255insert into bar select * from foo; 2256source include/diff_tables.inc; 2257alter table foo add column added_8 mediumtext default NULL first, add column added_61 varchar(10) NOT NULL default "abracadab"; 2258alter table bar add column added_8 mediumtext default NULL first, add column added_61 varchar(10) NOT NULL default "abracadab"; 2259source include/diff_tables.inc; 2260drop table foo; drop table bar; 2261 2262 2263create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2264create table bar like foo; 2265alter table bar engine=MyISAM; 2266insert into foo values (NULL,NULL,NULL,NULL); 2267insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2268insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2269insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2270insert into bar select * from foo; 2271source include/diff_tables.inc; 2272alter table foo add column added_8 mediumtext default NULL first, add column added_71 text default NULL; 2273alter table bar add column added_8 mediumtext default NULL first, add column added_71 text default NULL; 2274source include/diff_tables.inc; 2275drop table foo; drop table bar; 2276 2277 2278create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2279create table bar like foo; 2280alter table bar engine=MyISAM; 2281insert into foo values (NULL,NULL,NULL,NULL); 2282insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2283insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2284insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2285insert into bar select * from foo; 2286source include/diff_tables.inc; 2287alter table foo add column added_8 mediumtext default NULL first, add column added_81 mediumtext default NULL; 2288alter table bar add column added_8 mediumtext default NULL first, add column added_81 mediumtext default NULL; 2289source include/diff_tables.inc; 2290drop table foo; drop table bar; 2291 2292 2293create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2294create table bar like foo; 2295alter table bar engine=MyISAM; 2296insert into foo values (NULL,NULL,NULL,NULL); 2297insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2298insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2299insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2300insert into bar select * from foo; 2301source include/diff_tables.inc; 2302alter table foo add column added_1 bigint default NULL after bb, add column added_11 bigint default NULL after bb; 2303alter table bar add column added_1 bigint default NULL after bb, add column added_11 bigint default NULL after bb; 2304source include/diff_tables.inc; 2305drop table foo; drop table bar; 2306 2307 2308create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2309create table bar like foo; 2310alter table bar engine=MyISAM; 2311insert into foo values (NULL,NULL,NULL,NULL); 2312insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2313insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2314insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2315insert into bar select * from foo; 2316source include/diff_tables.inc; 2317alter table foo add column added_1 bigint default NULL after bb, add column added_21 bigint default 1234 after bb; 2318alter table bar add column added_1 bigint default NULL after bb, add column added_21 bigint default 1234 after bb; 2319source include/diff_tables.inc; 2320drop table foo; drop table bar; 2321 2322 2323create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2324create table bar like foo; 2325alter table bar engine=MyISAM; 2326insert into foo values (NULL,NULL,NULL,NULL); 2327insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2328insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2329insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2330insert into bar select * from foo; 2331source include/diff_tables.inc; 2332alter table foo add column added_1 bigint default NULL after bb, add column added_31 bigint NOT NULL default 54 after bb; 2333alter table bar add column added_1 bigint default NULL after bb, add column added_31 bigint NOT NULL default 54 after bb; 2334source include/diff_tables.inc; 2335drop table foo; drop table bar; 2336 2337 2338create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2339create table bar like foo; 2340alter table bar engine=MyISAM; 2341insert into foo values (NULL,NULL,NULL,NULL); 2342insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2343insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2344insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2345insert into bar select * from foo; 2346source include/diff_tables.inc; 2347alter table foo add column added_1 bigint default NULL after bb, add column added_41 varchar(10) default NULL after bb; 2348alter table bar add column added_1 bigint default NULL after bb, add column added_41 varchar(10) default NULL after bb; 2349source include/diff_tables.inc; 2350drop table foo; drop table bar; 2351 2352 2353create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2354create table bar like foo; 2355alter table bar engine=MyISAM; 2356insert into foo values (NULL,NULL,NULL,NULL); 2357insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2358insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2359insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2360insert into bar select * from foo; 2361source include/diff_tables.inc; 2362alter table foo add column added_1 bigint default NULL after bb, add column added_51 varchar(10) default "abracadab" after bb; 2363alter table bar add column added_1 bigint default NULL after bb, add column added_51 varchar(10) default "abracadab" after bb; 2364source include/diff_tables.inc; 2365drop table foo; drop table bar; 2366 2367 2368create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2369create table bar like foo; 2370alter table bar engine=MyISAM; 2371insert into foo values (NULL,NULL,NULL,NULL); 2372insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2373insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2374insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2375insert into bar select * from foo; 2376source include/diff_tables.inc; 2377alter table foo add column added_1 bigint default NULL after bb, add column added_61 varchar(10) NOT NULL default "abracadab" after bb; 2378alter table bar add column added_1 bigint default NULL after bb, add column added_61 varchar(10) NOT NULL default "abracadab" after bb; 2379source include/diff_tables.inc; 2380drop table foo; drop table bar; 2381 2382 2383create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2384create table bar like foo; 2385alter table bar engine=MyISAM; 2386insert into foo values (NULL,NULL,NULL,NULL); 2387insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2388insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2389insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2390insert into bar select * from foo; 2391source include/diff_tables.inc; 2392alter table foo add column added_1 bigint default NULL after bb, add column added_71 text default NULL after bb; 2393alter table bar add column added_1 bigint default NULL after bb, add column added_71 text default NULL after bb; 2394source include/diff_tables.inc; 2395drop table foo; drop table bar; 2396 2397 2398create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2399create table bar like foo; 2400alter table bar engine=MyISAM; 2401insert into foo values (NULL,NULL,NULL,NULL); 2402insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2403insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2404insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2405insert into bar select * from foo; 2406source include/diff_tables.inc; 2407alter table foo add column added_1 bigint default NULL after bb, add column added_81 mediumtext default NULL after bb; 2408alter table bar add column added_1 bigint default NULL after bb, add column added_81 mediumtext default NULL after bb; 2409source include/diff_tables.inc; 2410drop table foo; drop table bar; 2411 2412 2413create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2414create table bar like foo; 2415alter table bar engine=MyISAM; 2416insert into foo values (NULL,NULL,NULL,NULL); 2417insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2418insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2419insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2420insert into bar select * from foo; 2421source include/diff_tables.inc; 2422alter table foo add column added_2 bigint default -1 after bb, add column added_11 bigint default NULL after bb; 2423alter table bar add column added_2 bigint default -1 after bb, add column added_11 bigint default NULL after bb; 2424source include/diff_tables.inc; 2425drop table foo; drop table bar; 2426 2427 2428create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2429create table bar like foo; 2430alter table bar engine=MyISAM; 2431insert into foo values (NULL,NULL,NULL,NULL); 2432insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2433insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2434insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2435insert into bar select * from foo; 2436source include/diff_tables.inc; 2437alter table foo add column added_2 bigint default -1 after bb, add column added_21 bigint default 1234 after bb; 2438alter table bar add column added_2 bigint default -1 after bb, add column added_21 bigint default 1234 after bb; 2439source include/diff_tables.inc; 2440drop table foo; drop table bar; 2441 2442 2443create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2444create table bar like foo; 2445alter table bar engine=MyISAM; 2446insert into foo values (NULL,NULL,NULL,NULL); 2447insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2448insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2449insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2450insert into bar select * from foo; 2451source include/diff_tables.inc; 2452alter table foo add column added_2 bigint default -1 after bb, add column added_31 bigint NOT NULL default 54 after bb; 2453alter table bar add column added_2 bigint default -1 after bb, add column added_31 bigint NOT NULL default 54 after bb; 2454source include/diff_tables.inc; 2455drop table foo; drop table bar; 2456 2457 2458create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2459create table bar like foo; 2460alter table bar engine=MyISAM; 2461insert into foo values (NULL,NULL,NULL,NULL); 2462insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2463insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2464insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2465insert into bar select * from foo; 2466source include/diff_tables.inc; 2467alter table foo add column added_2 bigint default -1 after bb, add column added_41 varchar(10) default NULL after bb; 2468alter table bar add column added_2 bigint default -1 after bb, add column added_41 varchar(10) default NULL after bb; 2469source include/diff_tables.inc; 2470drop table foo; drop table bar; 2471 2472 2473create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2474create table bar like foo; 2475alter table bar engine=MyISAM; 2476insert into foo values (NULL,NULL,NULL,NULL); 2477insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2478insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2479insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2480insert into bar select * from foo; 2481source include/diff_tables.inc; 2482alter table foo add column added_2 bigint default -1 after bb, add column added_51 varchar(10) default "abracadab" after bb; 2483alter table bar add column added_2 bigint default -1 after bb, add column added_51 varchar(10) default "abracadab" after bb; 2484source include/diff_tables.inc; 2485drop table foo; drop table bar; 2486 2487 2488create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2489create table bar like foo; 2490alter table bar engine=MyISAM; 2491insert into foo values (NULL,NULL,NULL,NULL); 2492insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2493insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2494insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2495insert into bar select * from foo; 2496source include/diff_tables.inc; 2497alter table foo add column added_2 bigint default -1 after bb, add column added_61 varchar(10) NOT NULL default "abracadab" after bb; 2498alter table bar add column added_2 bigint default -1 after bb, add column added_61 varchar(10) NOT NULL default "abracadab" after bb; 2499source include/diff_tables.inc; 2500drop table foo; drop table bar; 2501 2502 2503create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2504create table bar like foo; 2505alter table bar engine=MyISAM; 2506insert into foo values (NULL,NULL,NULL,NULL); 2507insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2508insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2509insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2510insert into bar select * from foo; 2511source include/diff_tables.inc; 2512alter table foo add column added_2 bigint default -1 after bb, add column added_71 text default NULL after bb; 2513alter table bar add column added_2 bigint default -1 after bb, add column added_71 text default NULL after bb; 2514source include/diff_tables.inc; 2515drop table foo; drop table bar; 2516 2517 2518create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2519create table bar like foo; 2520alter table bar engine=MyISAM; 2521insert into foo values (NULL,NULL,NULL,NULL); 2522insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2523insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2524insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2525insert into bar select * from foo; 2526source include/diff_tables.inc; 2527alter table foo add column added_2 bigint default -1 after bb, add column added_81 mediumtext default NULL after bb; 2528alter table bar add column added_2 bigint default -1 after bb, add column added_81 mediumtext default NULL after bb; 2529source include/diff_tables.inc; 2530drop table foo; drop table bar; 2531 2532 2533create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2534create table bar like foo; 2535alter table bar engine=MyISAM; 2536insert into foo values (NULL,NULL,NULL,NULL); 2537insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2538insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2539insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2540insert into bar select * from foo; 2541source include/diff_tables.inc; 2542alter table foo add column added_3 bigint NOT NULL default -1 after bb, add column added_11 bigint default NULL after bb; 2543alter table bar add column added_3 bigint NOT NULL default -1 after bb, add column added_11 bigint default NULL after bb; 2544source include/diff_tables.inc; 2545drop table foo; drop table bar; 2546 2547 2548create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2549create table bar like foo; 2550alter table bar engine=MyISAM; 2551insert into foo values (NULL,NULL,NULL,NULL); 2552insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2553insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2554insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2555insert into bar select * from foo; 2556source include/diff_tables.inc; 2557alter table foo add column added_3 bigint NOT NULL default -1 after bb, add column added_21 bigint default 1234 after bb; 2558alter table bar add column added_3 bigint NOT NULL default -1 after bb, add column added_21 bigint default 1234 after bb; 2559source include/diff_tables.inc; 2560drop table foo; drop table bar; 2561 2562 2563create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2564create table bar like foo; 2565alter table bar engine=MyISAM; 2566insert into foo values (NULL,NULL,NULL,NULL); 2567insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2568insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2569insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2570insert into bar select * from foo; 2571source include/diff_tables.inc; 2572alter table foo add column added_3 bigint NOT NULL default -1 after bb, add column added_31 bigint NOT NULL default 54 after bb; 2573alter table bar add column added_3 bigint NOT NULL default -1 after bb, add column added_31 bigint NOT NULL default 54 after bb; 2574source include/diff_tables.inc; 2575drop table foo; drop table bar; 2576 2577 2578create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2579create table bar like foo; 2580alter table bar engine=MyISAM; 2581insert into foo values (NULL,NULL,NULL,NULL); 2582insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2583insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2584insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2585insert into bar select * from foo; 2586source include/diff_tables.inc; 2587alter table foo add column added_3 bigint NOT NULL default -1 after bb, add column added_41 varchar(10) default NULL after bb; 2588alter table bar add column added_3 bigint NOT NULL default -1 after bb, add column added_41 varchar(10) default NULL after bb; 2589source include/diff_tables.inc; 2590drop table foo; drop table bar; 2591 2592 2593create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2594create table bar like foo; 2595alter table bar engine=MyISAM; 2596insert into foo values (NULL,NULL,NULL,NULL); 2597insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2598insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2599insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2600insert into bar select * from foo; 2601source include/diff_tables.inc; 2602alter table foo add column added_3 bigint NOT NULL default -1 after bb, add column added_51 varchar(10) default "abracadab" after bb; 2603alter table bar add column added_3 bigint NOT NULL default -1 after bb, add column added_51 varchar(10) default "abracadab" after bb; 2604source include/diff_tables.inc; 2605drop table foo; drop table bar; 2606 2607 2608create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2609create table bar like foo; 2610alter table bar engine=MyISAM; 2611insert into foo values (NULL,NULL,NULL,NULL); 2612insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2613insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2614insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2615insert into bar select * from foo; 2616source include/diff_tables.inc; 2617alter table foo add column added_3 bigint NOT NULL default -1 after bb, add column added_61 varchar(10) NOT NULL default "abracadab" after bb; 2618alter table bar add column added_3 bigint NOT NULL default -1 after bb, add column added_61 varchar(10) NOT NULL default "abracadab" after bb; 2619source include/diff_tables.inc; 2620drop table foo; drop table bar; 2621 2622 2623create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2624create table bar like foo; 2625alter table bar engine=MyISAM; 2626insert into foo values (NULL,NULL,NULL,NULL); 2627insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2628insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2629insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2630insert into bar select * from foo; 2631source include/diff_tables.inc; 2632alter table foo add column added_3 bigint NOT NULL default -1 after bb, add column added_71 text default NULL after bb; 2633alter table bar add column added_3 bigint NOT NULL default -1 after bb, add column added_71 text default NULL after bb; 2634source include/diff_tables.inc; 2635drop table foo; drop table bar; 2636 2637 2638create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2639create table bar like foo; 2640alter table bar engine=MyISAM; 2641insert into foo values (NULL,NULL,NULL,NULL); 2642insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2643insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2644insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2645insert into bar select * from foo; 2646source include/diff_tables.inc; 2647alter table foo add column added_3 bigint NOT NULL default -1 after bb, add column added_81 mediumtext default NULL after bb; 2648alter table bar add column added_3 bigint NOT NULL default -1 after bb, add column added_81 mediumtext default NULL after bb; 2649source include/diff_tables.inc; 2650drop table foo; drop table bar; 2651 2652 2653create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2654create table bar like foo; 2655alter table bar engine=MyISAM; 2656insert into foo values (NULL,NULL,NULL,NULL); 2657insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2658insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2659insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2660insert into bar select * from foo; 2661source include/diff_tables.inc; 2662alter table foo add column added_4 varchar(10) default NULL after bb, add column added_11 bigint default NULL after bb; 2663alter table bar add column added_4 varchar(10) default NULL after bb, add column added_11 bigint default NULL after bb; 2664source include/diff_tables.inc; 2665drop table foo; drop table bar; 2666 2667 2668create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2669create table bar like foo; 2670alter table bar engine=MyISAM; 2671insert into foo values (NULL,NULL,NULL,NULL); 2672insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2673insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2674insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2675insert into bar select * from foo; 2676source include/diff_tables.inc; 2677alter table foo add column added_4 varchar(10) default NULL after bb, add column added_21 bigint default 1234 after bb; 2678alter table bar add column added_4 varchar(10) default NULL after bb, add column added_21 bigint default 1234 after bb; 2679source include/diff_tables.inc; 2680drop table foo; drop table bar; 2681 2682 2683create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2684create table bar like foo; 2685alter table bar engine=MyISAM; 2686insert into foo values (NULL,NULL,NULL,NULL); 2687insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2688insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2689insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2690insert into bar select * from foo; 2691source include/diff_tables.inc; 2692alter table foo add column added_4 varchar(10) default NULL after bb, add column added_31 bigint NOT NULL default 54 after bb; 2693alter table bar add column added_4 varchar(10) default NULL after bb, add column added_31 bigint NOT NULL default 54 after bb; 2694source include/diff_tables.inc; 2695drop table foo; drop table bar; 2696 2697 2698create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2699create table bar like foo; 2700alter table bar engine=MyISAM; 2701insert into foo values (NULL,NULL,NULL,NULL); 2702insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2703insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2704insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2705insert into bar select * from foo; 2706source include/diff_tables.inc; 2707alter table foo add column added_4 varchar(10) default NULL after bb, add column added_41 varchar(10) default NULL after bb; 2708alter table bar add column added_4 varchar(10) default NULL after bb, add column added_41 varchar(10) default NULL after bb; 2709source include/diff_tables.inc; 2710drop table foo; drop table bar; 2711 2712 2713create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2714create table bar like foo; 2715alter table bar engine=MyISAM; 2716insert into foo values (NULL,NULL,NULL,NULL); 2717insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2718insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2719insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2720insert into bar select * from foo; 2721source include/diff_tables.inc; 2722alter table foo add column added_4 varchar(10) default NULL after bb, add column added_51 varchar(10) default "abracadab" after bb; 2723alter table bar add column added_4 varchar(10) default NULL after bb, add column added_51 varchar(10) default "abracadab" after bb; 2724source include/diff_tables.inc; 2725drop table foo; drop table bar; 2726 2727 2728create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2729create table bar like foo; 2730alter table bar engine=MyISAM; 2731insert into foo values (NULL,NULL,NULL,NULL); 2732insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2733insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2734insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2735insert into bar select * from foo; 2736source include/diff_tables.inc; 2737alter table foo add column added_4 varchar(10) default NULL after bb, add column added_61 varchar(10) NOT NULL default "abracadab" after bb; 2738alter table bar add column added_4 varchar(10) default NULL after bb, add column added_61 varchar(10) NOT NULL default "abracadab" after bb; 2739source include/diff_tables.inc; 2740drop table foo; drop table bar; 2741 2742 2743create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2744create table bar like foo; 2745alter table bar engine=MyISAM; 2746insert into foo values (NULL,NULL,NULL,NULL); 2747insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2748insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2749insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2750insert into bar select * from foo; 2751source include/diff_tables.inc; 2752alter table foo add column added_4 varchar(10) default NULL after bb, add column added_71 text default NULL after bb; 2753alter table bar add column added_4 varchar(10) default NULL after bb, add column added_71 text default NULL after bb; 2754source include/diff_tables.inc; 2755drop table foo; drop table bar; 2756 2757 2758create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2759create table bar like foo; 2760alter table bar engine=MyISAM; 2761insert into foo values (NULL,NULL,NULL,NULL); 2762insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2763insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2764insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2765insert into bar select * from foo; 2766source include/diff_tables.inc; 2767alter table foo add column added_4 varchar(10) default NULL after bb, add column added_81 mediumtext default NULL after bb; 2768alter table bar add column added_4 varchar(10) default NULL after bb, add column added_81 mediumtext default NULL after bb; 2769source include/diff_tables.inc; 2770drop table foo; drop table bar; 2771 2772 2773create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2774create table bar like foo; 2775alter table bar engine=MyISAM; 2776insert into foo values (NULL,NULL,NULL,NULL); 2777insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2778insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2779insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2780insert into bar select * from foo; 2781source include/diff_tables.inc; 2782alter table foo add column added_5 varchar(10) default "qwerty" after bb, add column added_11 bigint default NULL after bb; 2783alter table bar add column added_5 varchar(10) default "qwerty" after bb, add column added_11 bigint default NULL after bb; 2784source include/diff_tables.inc; 2785drop table foo; drop table bar; 2786 2787 2788create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2789create table bar like foo; 2790alter table bar engine=MyISAM; 2791insert into foo values (NULL,NULL,NULL,NULL); 2792insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2793insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2794insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2795insert into bar select * from foo; 2796source include/diff_tables.inc; 2797alter table foo add column added_5 varchar(10) default "qwerty" after bb, add column added_21 bigint default 1234 after bb; 2798alter table bar add column added_5 varchar(10) default "qwerty" after bb, add column added_21 bigint default 1234 after bb; 2799source include/diff_tables.inc; 2800drop table foo; drop table bar; 2801 2802 2803create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2804create table bar like foo; 2805alter table bar engine=MyISAM; 2806insert into foo values (NULL,NULL,NULL,NULL); 2807insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2808insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2809insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2810insert into bar select * from foo; 2811source include/diff_tables.inc; 2812alter table foo add column added_5 varchar(10) default "qwerty" after bb, add column added_31 bigint NOT NULL default 54 after bb; 2813alter table bar add column added_5 varchar(10) default "qwerty" after bb, add column added_31 bigint NOT NULL default 54 after bb; 2814source include/diff_tables.inc; 2815drop table foo; drop table bar; 2816 2817 2818create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2819create table bar like foo; 2820alter table bar engine=MyISAM; 2821insert into foo values (NULL,NULL,NULL,NULL); 2822insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2823insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2824insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2825insert into bar select * from foo; 2826source include/diff_tables.inc; 2827alter table foo add column added_5 varchar(10) default "qwerty" after bb, add column added_41 varchar(10) default NULL after bb; 2828alter table bar add column added_5 varchar(10) default "qwerty" after bb, add column added_41 varchar(10) default NULL after bb; 2829source include/diff_tables.inc; 2830drop table foo; drop table bar; 2831 2832 2833create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2834create table bar like foo; 2835alter table bar engine=MyISAM; 2836insert into foo values (NULL,NULL,NULL,NULL); 2837insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2838insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2839insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2840insert into bar select * from foo; 2841source include/diff_tables.inc; 2842alter table foo add column added_5 varchar(10) default "qwerty" after bb, add column added_51 varchar(10) default "abracadab" after bb; 2843alter table bar add column added_5 varchar(10) default "qwerty" after bb, add column added_51 varchar(10) default "abracadab" after bb; 2844source include/diff_tables.inc; 2845drop table foo; drop table bar; 2846 2847 2848create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2849create table bar like foo; 2850alter table bar engine=MyISAM; 2851insert into foo values (NULL,NULL,NULL,NULL); 2852insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2853insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2854insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2855insert into bar select * from foo; 2856source include/diff_tables.inc; 2857alter table foo add column added_5 varchar(10) default "qwerty" after bb, add column added_61 varchar(10) NOT NULL default "abracadab" after bb; 2858alter table bar add column added_5 varchar(10) default "qwerty" after bb, add column added_61 varchar(10) NOT NULL default "abracadab" after bb; 2859source include/diff_tables.inc; 2860drop table foo; drop table bar; 2861 2862 2863create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2864create table bar like foo; 2865alter table bar engine=MyISAM; 2866insert into foo values (NULL,NULL,NULL,NULL); 2867insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2868insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2869insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2870insert into bar select * from foo; 2871source include/diff_tables.inc; 2872alter table foo add column added_5 varchar(10) default "qwerty" after bb, add column added_71 text default NULL after bb; 2873alter table bar add column added_5 varchar(10) default "qwerty" after bb, add column added_71 text default NULL after bb; 2874source include/diff_tables.inc; 2875drop table foo; drop table bar; 2876 2877 2878create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2879create table bar like foo; 2880alter table bar engine=MyISAM; 2881insert into foo values (NULL,NULL,NULL,NULL); 2882insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2883insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2884insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2885insert into bar select * from foo; 2886source include/diff_tables.inc; 2887alter table foo add column added_5 varchar(10) default "qwerty" after bb, add column added_81 mediumtext default NULL after bb; 2888alter table bar add column added_5 varchar(10) default "qwerty" after bb, add column added_81 mediumtext default NULL after bb; 2889source include/diff_tables.inc; 2890drop table foo; drop table bar; 2891 2892 2893create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2894create table bar like foo; 2895alter table bar engine=MyISAM; 2896insert into foo values (NULL,NULL,NULL,NULL); 2897insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2898insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2899insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2900insert into bar select * from foo; 2901source include/diff_tables.inc; 2902alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" after bb, add column added_11 bigint default NULL after bb; 2903alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" after bb, add column added_11 bigint default NULL after bb; 2904source include/diff_tables.inc; 2905drop table foo; drop table bar; 2906 2907 2908create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2909create table bar like foo; 2910alter table bar engine=MyISAM; 2911insert into foo values (NULL,NULL,NULL,NULL); 2912insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2913insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2914insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2915insert into bar select * from foo; 2916source include/diff_tables.inc; 2917alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" after bb, add column added_21 bigint default 1234 after bb; 2918alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" after bb, add column added_21 bigint default 1234 after bb; 2919source include/diff_tables.inc; 2920drop table foo; drop table bar; 2921 2922 2923create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2924create table bar like foo; 2925alter table bar engine=MyISAM; 2926insert into foo values (NULL,NULL,NULL,NULL); 2927insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2928insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2929insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2930insert into bar select * from foo; 2931source include/diff_tables.inc; 2932alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" after bb, add column added_31 bigint NOT NULL default 54 after bb; 2933alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" after bb, add column added_31 bigint NOT NULL default 54 after bb; 2934source include/diff_tables.inc; 2935drop table foo; drop table bar; 2936 2937 2938create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2939create table bar like foo; 2940alter table bar engine=MyISAM; 2941insert into foo values (NULL,NULL,NULL,NULL); 2942insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2943insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2944insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2945insert into bar select * from foo; 2946source include/diff_tables.inc; 2947alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" after bb, add column added_41 varchar(10) default NULL after bb; 2948alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" after bb, add column added_41 varchar(10) default NULL after bb; 2949source include/diff_tables.inc; 2950drop table foo; drop table bar; 2951 2952 2953create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2954create table bar like foo; 2955alter table bar engine=MyISAM; 2956insert into foo values (NULL,NULL,NULL,NULL); 2957insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2958insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2959insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2960insert into bar select * from foo; 2961source include/diff_tables.inc; 2962alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" after bb, add column added_51 varchar(10) default "abracadab" after bb; 2963alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" after bb, add column added_51 varchar(10) default "abracadab" after bb; 2964source include/diff_tables.inc; 2965drop table foo; drop table bar; 2966 2967 2968create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2969create table bar like foo; 2970alter table bar engine=MyISAM; 2971insert into foo values (NULL,NULL,NULL,NULL); 2972insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2973insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2974insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2975insert into bar select * from foo; 2976source include/diff_tables.inc; 2977alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" after bb, add column added_61 varchar(10) NOT NULL default "abracadab" after bb; 2978alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" after bb, add column added_61 varchar(10) NOT NULL default "abracadab" after bb; 2979source include/diff_tables.inc; 2980drop table foo; drop table bar; 2981 2982 2983create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2984create table bar like foo; 2985alter table bar engine=MyISAM; 2986insert into foo values (NULL,NULL,NULL,NULL); 2987insert into foo values ("adsf",NULL,"hjfdshj",NULL); 2988insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 2989insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 2990insert into bar select * from foo; 2991source include/diff_tables.inc; 2992alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" after bb, add column added_71 text default NULL after bb; 2993alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" after bb, add column added_71 text default NULL after bb; 2994source include/diff_tables.inc; 2995drop table foo; drop table bar; 2996 2997 2998create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 2999create table bar like foo; 3000alter table bar engine=MyISAM; 3001insert into foo values (NULL,NULL,NULL,NULL); 3002insert into foo values ("adsf",NULL,"hjfdshj",NULL); 3003insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 3004insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 3005insert into bar select * from foo; 3006source include/diff_tables.inc; 3007alter table foo add column added_6 varchar(10) NOT NULL default "ruyrtt" after bb, add column added_81 mediumtext default NULL after bb; 3008alter table bar add column added_6 varchar(10) NOT NULL default "ruyrtt" after bb, add column added_81 mediumtext default NULL after bb; 3009source include/diff_tables.inc; 3010drop table foo; drop table bar; 3011 3012 3013create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 3014create table bar like foo; 3015alter table bar engine=MyISAM; 3016insert into foo values (NULL,NULL,NULL,NULL); 3017insert into foo values ("adsf",NULL,"hjfdshj",NULL); 3018insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 3019insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 3020insert into bar select * from foo; 3021source include/diff_tables.inc; 3022alter table foo add column added_7 text default NULL after bb, add column added_11 bigint default NULL after bb; 3023alter table bar add column added_7 text default NULL after bb, add column added_11 bigint default NULL after bb; 3024source include/diff_tables.inc; 3025drop table foo; drop table bar; 3026 3027 3028create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 3029create table bar like foo; 3030alter table bar engine=MyISAM; 3031insert into foo values (NULL,NULL,NULL,NULL); 3032insert into foo values ("adsf",NULL,"hjfdshj",NULL); 3033insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 3034insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 3035insert into bar select * from foo; 3036source include/diff_tables.inc; 3037alter table foo add column added_7 text default NULL after bb, add column added_21 bigint default 1234 after bb; 3038alter table bar add column added_7 text default NULL after bb, add column added_21 bigint default 1234 after bb; 3039source include/diff_tables.inc; 3040drop table foo; drop table bar; 3041 3042 3043create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 3044create table bar like foo; 3045alter table bar engine=MyISAM; 3046insert into foo values (NULL,NULL,NULL,NULL); 3047insert into foo values ("adsf",NULL,"hjfdshj",NULL); 3048insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 3049insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 3050insert into bar select * from foo; 3051source include/diff_tables.inc; 3052alter table foo add column added_7 text default NULL after bb, add column added_31 bigint NOT NULL default 54 after bb; 3053alter table bar add column added_7 text default NULL after bb, add column added_31 bigint NOT NULL default 54 after bb; 3054source include/diff_tables.inc; 3055drop table foo; drop table bar; 3056 3057 3058create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 3059create table bar like foo; 3060alter table bar engine=MyISAM; 3061insert into foo values (NULL,NULL,NULL,NULL); 3062insert into foo values ("adsf",NULL,"hjfdshj",NULL); 3063insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 3064insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 3065insert into bar select * from foo; 3066source include/diff_tables.inc; 3067alter table foo add column added_7 text default NULL after bb, add column added_41 varchar(10) default NULL after bb; 3068alter table bar add column added_7 text default NULL after bb, add column added_41 varchar(10) default NULL after bb; 3069source include/diff_tables.inc; 3070drop table foo; drop table bar; 3071 3072 3073create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 3074create table bar like foo; 3075alter table bar engine=MyISAM; 3076insert into foo values (NULL,NULL,NULL,NULL); 3077insert into foo values ("adsf",NULL,"hjfdshj",NULL); 3078insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 3079insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 3080insert into bar select * from foo; 3081source include/diff_tables.inc; 3082alter table foo add column added_7 text default NULL after bb, add column added_51 varchar(10) default "abracadab" after bb; 3083alter table bar add column added_7 text default NULL after bb, add column added_51 varchar(10) default "abracadab" after bb; 3084source include/diff_tables.inc; 3085drop table foo; drop table bar; 3086 3087 3088create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 3089create table bar like foo; 3090alter table bar engine=MyISAM; 3091insert into foo values (NULL,NULL,NULL,NULL); 3092insert into foo values ("adsf",NULL,"hjfdshj",NULL); 3093insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 3094insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 3095insert into bar select * from foo; 3096source include/diff_tables.inc; 3097alter table foo add column added_7 text default NULL after bb, add column added_61 varchar(10) NOT NULL default "abracadab" after bb; 3098alter table bar add column added_7 text default NULL after bb, add column added_61 varchar(10) NOT NULL default "abracadab" after bb; 3099source include/diff_tables.inc; 3100drop table foo; drop table bar; 3101 3102 3103create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 3104create table bar like foo; 3105alter table bar engine=MyISAM; 3106insert into foo values (NULL,NULL,NULL,NULL); 3107insert into foo values ("adsf",NULL,"hjfdshj",NULL); 3108insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 3109insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 3110insert into bar select * from foo; 3111source include/diff_tables.inc; 3112alter table foo add column added_7 text default NULL after bb, add column added_71 text default NULL after bb; 3113alter table bar add column added_7 text default NULL after bb, add column added_71 text default NULL after bb; 3114source include/diff_tables.inc; 3115drop table foo; drop table bar; 3116 3117 3118create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 3119create table bar like foo; 3120alter table bar engine=MyISAM; 3121insert into foo values (NULL,NULL,NULL,NULL); 3122insert into foo values ("adsf",NULL,"hjfdshj",NULL); 3123insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 3124insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 3125insert into bar select * from foo; 3126source include/diff_tables.inc; 3127alter table foo add column added_7 text default NULL after bb, add column added_81 mediumtext default NULL after bb; 3128alter table bar add column added_7 text default NULL after bb, add column added_81 mediumtext default NULL after bb; 3129source include/diff_tables.inc; 3130drop table foo; drop table bar; 3131 3132 3133create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 3134create table bar like foo; 3135alter table bar engine=MyISAM; 3136insert into foo values (NULL,NULL,NULL,NULL); 3137insert into foo values ("adsf",NULL,"hjfdshj",NULL); 3138insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 3139insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 3140insert into bar select * from foo; 3141source include/diff_tables.inc; 3142alter table foo add column added_8 mediumtext default NULL after bb, add column added_11 bigint default NULL after bb; 3143alter table bar add column added_8 mediumtext default NULL after bb, add column added_11 bigint default NULL after bb; 3144source include/diff_tables.inc; 3145drop table foo; drop table bar; 3146 3147 3148create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 3149create table bar like foo; 3150alter table bar engine=MyISAM; 3151insert into foo values (NULL,NULL,NULL,NULL); 3152insert into foo values ("adsf",NULL,"hjfdshj",NULL); 3153insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 3154insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 3155insert into bar select * from foo; 3156source include/diff_tables.inc; 3157alter table foo add column added_8 mediumtext default NULL after bb, add column added_21 bigint default 1234 after bb; 3158alter table bar add column added_8 mediumtext default NULL after bb, add column added_21 bigint default 1234 after bb; 3159source include/diff_tables.inc; 3160drop table foo; drop table bar; 3161 3162 3163create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 3164create table bar like foo; 3165alter table bar engine=MyISAM; 3166insert into foo values (NULL,NULL,NULL,NULL); 3167insert into foo values ("adsf",NULL,"hjfdshj",NULL); 3168insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 3169insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 3170insert into bar select * from foo; 3171source include/diff_tables.inc; 3172alter table foo add column added_8 mediumtext default NULL after bb, add column added_31 bigint NOT NULL default 54 after bb; 3173alter table bar add column added_8 mediumtext default NULL after bb, add column added_31 bigint NOT NULL default 54 after bb; 3174source include/diff_tables.inc; 3175drop table foo; drop table bar; 3176 3177 3178create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 3179create table bar like foo; 3180alter table bar engine=MyISAM; 3181insert into foo values (NULL,NULL,NULL,NULL); 3182insert into foo values ("adsf",NULL,"hjfdshj",NULL); 3183insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 3184insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 3185insert into bar select * from foo; 3186source include/diff_tables.inc; 3187alter table foo add column added_8 mediumtext default NULL after bb, add column added_41 varchar(10) default NULL after bb; 3188alter table bar add column added_8 mediumtext default NULL after bb, add column added_41 varchar(10) default NULL after bb; 3189source include/diff_tables.inc; 3190drop table foo; drop table bar; 3191 3192 3193create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 3194create table bar like foo; 3195alter table bar engine=MyISAM; 3196insert into foo values (NULL,NULL,NULL,NULL); 3197insert into foo values ("adsf",NULL,"hjfdshj",NULL); 3198insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 3199insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 3200insert into bar select * from foo; 3201source include/diff_tables.inc; 3202alter table foo add column added_8 mediumtext default NULL after bb, add column added_51 varchar(10) default "abracadab" after bb; 3203alter table bar add column added_8 mediumtext default NULL after bb, add column added_51 varchar(10) default "abracadab" after bb; 3204source include/diff_tables.inc; 3205drop table foo; drop table bar; 3206 3207 3208create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 3209create table bar like foo; 3210alter table bar engine=MyISAM; 3211insert into foo values (NULL,NULL,NULL,NULL); 3212insert into foo values ("adsf",NULL,"hjfdshj",NULL); 3213insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 3214insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 3215insert into bar select * from foo; 3216source include/diff_tables.inc; 3217alter table foo add column added_8 mediumtext default NULL after bb, add column added_61 varchar(10) NOT NULL default "abracadab" after bb; 3218alter table bar add column added_8 mediumtext default NULL after bb, add column added_61 varchar(10) NOT NULL default "abracadab" after bb; 3219source include/diff_tables.inc; 3220drop table foo; drop table bar; 3221 3222 3223create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 3224create table bar like foo; 3225alter table bar engine=MyISAM; 3226insert into foo values (NULL,NULL,NULL,NULL); 3227insert into foo values ("adsf",NULL,"hjfdshj",NULL); 3228insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 3229insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 3230insert into bar select * from foo; 3231source include/diff_tables.inc; 3232alter table foo add column added_8 mediumtext default NULL after bb, add column added_71 text default NULL after bb; 3233alter table bar add column added_8 mediumtext default NULL after bb, add column added_71 text default NULL after bb; 3234source include/diff_tables.inc; 3235drop table foo; drop table bar; 3236 3237 3238create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 3239create table bar like foo; 3240alter table bar engine=MyISAM; 3241insert into foo values (NULL,NULL,NULL,NULL); 3242insert into foo values ("adsf",NULL,"hjfdshj",NULL); 3243insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 3244insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 3245insert into bar select * from foo; 3246source include/diff_tables.inc; 3247alter table foo add column added_8 mediumtext default NULL after bb, add column added_81 mediumtext default NULL after bb; 3248alter table bar add column added_8 mediumtext default NULL after bb, add column added_81 mediumtext default NULL after bb; 3249source include/diff_tables.inc; 3250drop table foo; drop table bar; 3251 3252 3253create table foo (aa blob, bb longblob, cc tinyblob, dd mediumblob) engine=TokuDB; 3254create table bar like foo; 3255alter table bar engine=MyISAM; 3256insert into foo values (NULL,NULL,NULL,NULL); 3257insert into foo values ("adsf",NULL,"hjfdshj",NULL); 3258insert into foo values (NULL,"oifds",NULL,"fdsjfds"); 3259insert into foo values ("rewoiu","fds","fr","oiufdsrew"); 3260insert into bar select * from foo; 3261source include/diff_tables.inc; 3262alter table foo add column added_1 bigint default NULL, add column added_2 bigint default -1 after bb, add column added_3 bigint NOT NULL default -1; 3263alter table bar add column added_1 bigint default NULL, add column added_2 bigint default -1 after bb, add column added_3 bigint NOT NULL default -1; 3264source include/diff_tables.inc; 3265drop table foo; drop table bar; 3266