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 drop column aa; 23alter table bar drop column aa; 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 drop column bb; 38alter table bar drop column bb; 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 drop column cc; 53alter table bar drop column cc; 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 drop column dd; 68alter table bar drop column dd; 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 drop column aa, drop column bb; 83alter table bar drop column aa, drop column bb; 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 drop column aa, drop column cc; 98alter table bar drop column aa, drop column cc; 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 drop column aa, drop column dd; 113alter table bar drop column aa, drop column dd; 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 drop column bb, drop column aa; 128alter table bar drop column bb, drop column aa; 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 drop column bb, drop column cc; 143alter table bar drop column bb, drop column cc; 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 drop column bb, drop column dd; 158alter table bar drop column bb, drop column dd; 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 drop column cc, drop column aa; 173alter table bar drop column cc, drop column aa; 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 drop column cc, drop column bb; 188alter table bar drop column cc, drop column bb; 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 drop column cc, drop column dd; 203alter table bar drop column cc, drop column dd; 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 drop column dd, drop column aa; 218alter table bar drop column dd, drop column aa; 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 drop column dd, drop column bb; 233alter table bar drop column dd, drop column bb; 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 drop column dd, drop column cc; 248alter table bar drop column dd, drop column cc; 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 drop column aa, drop column bb, drop column cc; 263alter table bar drop column aa, drop column bb, drop column cc; 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 drop column aa, drop column bb, drop column dd; 278alter table bar drop column aa, drop column bb, drop column dd; 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 drop column aa, drop column cc, drop column dd; 293alter table bar drop column aa, drop column cc, drop column dd; 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 drop column bb, drop column cc, drop column dd; 308alter table bar drop column bb, drop column cc, drop column dd; 309source include/diff_tables.inc; 310drop table foo; drop table bar; 311