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 INT, b INT, c INT, KEY(b), id INT PRIMARY KEY); 10INSERT INTO t VALUES (1,2,3,1),(4,5,6,2),(7,8,9,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 BIGINT; 17ALTER TABLE ti CHANGE COLUMN a a BIGINT; 18 19SELECT b FROM t; 20SELECT b FROM ti; 21 22INSERT INTO t VALUES (10,11,12,4); 23INSERT INTO ti VALUES (10,11,12,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;