2
DROP TABLE IF EXISTS t, ti;
5
SET SESSION TOKUDB_DISABLE_SLOW_ALTER=1;
6
SET SESSION DEFAULT_STORAGE_ENGINE='TokuDB';
8
CREATE TABLE t (a INT, b INT, c INT, KEY(b), id INT PRIMARY KEY);
9
INSERT INTO t VALUES (1,2,3,1),(4,5,6,2),(7,8,9,3);
11
CREATE TABLE ti LIKE t;
12
ALTER TABLE ti ENGINE=myisam;
13
INSERT INTO ti SELECT * FROM t;
15
ALTER TABLE t CHANGE COLUMN a a BIGINT;
16
ALTER TABLE ti CHANGE COLUMN a a BIGINT;
21
INSERT INTO t VALUES (10,11,12,4);
22
INSERT INTO ti VALUES (10,11,12,4);
24
# should get the same result set
28
# tables should be the same
29
let $diff_tables = test.t, test.ti;
30
source include/diff_tables.inc;
b'\\ No newline at end of file'