1source include/have_tokudb.inc; 2--disable_warnings 3DROP TABLE IF EXISTS t, ti; 4--enable_warnings 5 6SET SESSION TOKUDB_DISABLE_SLOW_ALTER=1; 7SET SESSION DEFAULT_STORAGE_ENGINE='TokuDB'; 8 9CREATE TABLE t (a CHAR(4), b CHAR(4), c CHAR(4), KEY(b), id INT PRIMARY KEY); 10INSERT INTO t VALUES ('a','b','c',1),('d','e','f',2),('g','h','i',3); 11 12CREATE TABLE ti LIKE t; 13ALTER TABLE ti ENGINE=myisam; 14INSERT INTO ti SELECT * FROM t; 15 16ALTER TABLE t CHANGE COLUMN a a CHAR(255); 17ALTER TABLE ti CHANGE COLUMN a a CHAR(255); 18 19SELECT b FROM t; 20SELECT b FROM ti; 21 22INSERT INTO t VALUES ('j','k','l',4); 23INSERT INTO ti VALUES ('j','k','l',4); 24 25# should get the same result set 26SELECT b FROM t; 27SELECT b FROM ti; 28 29# tables should be the same 30let $diff_tables = test.t, test.ti; 31source include/diff_tables.inc; 32 33DROP TABLE t, ti;