1DROP TABLE IF EXISTS t; 2SET SESSION TOKUDB_DISABLE_SLOW_ALTER=ON; 3CREATE TABLE t (a VARCHAR(100), b VARCHAR(100)) ENGINE=Tokudb; 4INSERT INTO t VALUES ('hi','there'),('you','people'); 5SELECT * FROM t; 6a b 7hi there 8you people 9ALTER TABLE t CHANGE COLUMN a a VARCHAR(101); 10SHOW CREATE TABLE t; 11Table Create Table 12t CREATE TABLE `t` ( 13 `a` varchar(101) DEFAULT NULL, 14 `b` varchar(100) DEFAULT NULL 15) ENGINE=TokuDB DEFAULT CHARSET=latin1 16ALTER TABLE t CHANGE COLUMN a a VARCHAR(200); 17SHOW CREATE TABLE t; 18Table Create Table 19t CREATE TABLE `t` ( 20 `a` varchar(200) DEFAULT NULL, 21 `b` varchar(100) DEFAULT NULL 22) ENGINE=TokuDB DEFAULT CHARSET=latin1 23SELECT * FROM t; 24a b 25hi there 26you people 27DROP TABLE t; 28CREATE TABLE t (i INT, a VARCHAR(100), b VARCHAR(100)) ENGINE=Tokudb; 29INSERT INTO t VALUES (1, 'hi','there'),(2, 'you','people'); 30SELECT * FROM t; 31i a b 321 hi there 332 you people 34ALTER TABLE t CHANGE COLUMN a a VARCHAR(101); 35SHOW CREATE TABLE t; 36Table Create Table 37t CREATE TABLE `t` ( 38 `i` int(11) DEFAULT NULL, 39 `a` varchar(101) DEFAULT NULL, 40 `b` varchar(100) DEFAULT NULL 41) ENGINE=TokuDB DEFAULT CHARSET=latin1 42ALTER TABLE t CHANGE COLUMN a a VARCHAR(200); 43SHOW CREATE TABLE t; 44Table Create Table 45t CREATE TABLE `t` ( 46 `i` int(11) DEFAULT NULL, 47 `a` varchar(200) DEFAULT NULL, 48 `b` varchar(100) DEFAULT NULL 49) ENGINE=TokuDB DEFAULT CHARSET=latin1 50SELECT * FROM t; 51i a b 521 hi there 532 you people 54DROP TABLE t; 55