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