1DROP TABLE IF EXISTS t, ti; 2SET SESSION TOKUDB_DISABLE_SLOW_ALTER=1; 3SET SESSION DEFAULT_STORAGE_ENGINE='TokuDB'; 4CREATE TABLE t (a BINARY(4), b BINARY(4), c BINARY(4), KEY(b), id INT PRIMARY KEY); 5INSERT INTO t VALUES ('a','b','c',1),('d','e','f',2),('g','h','i',3); 6CREATE TABLE ti LIKE t; 7ALTER TABLE ti ENGINE=myisam; 8INSERT INTO ti SELECT * FROM t; 9ALTER TABLE t CHANGE COLUMN a a BINARY(255); 10ALTER TABLE ti CHANGE COLUMN a a BINARY(255); 11SELECT HEX(b) FROM t; 12HEX(b) 1362000000 1465000000 1568000000 16SELECT HEX(b) FROM ti; 17HEX(b) 1862000000 1965000000 2068000000 21INSERT INTO t VALUES ('j','k','l',4); 22INSERT INTO ti VALUES ('j','k','l',4); 23SELECT HEX(b) FROM t; 24HEX(b) 2562000000 2665000000 2768000000 286B000000 29SELECT HEX(b) FROM ti; 30HEX(b) 3162000000 3265000000 3368000000 346B000000 35include/diff_tables.inc [test.t, test.ti] 36DROP TABLE t, ti; 37