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;