EVOLUTION-MANAGER

Edit File: change_column_carchar_sum_cross256.result

DROP TABLE IF EXISTS t; SET SESSION TOKUDB_DISABLE_SLOW_ALTER=ON; CREATE TABLE t (a VARCHAR(100), b VARCHAR(100)) ENGINE=Tokudb; INSERT INTO t VALUES ('hi','there'),('you','people'); SELECT * FROM t; a b hi there you people ALTER TABLE t CHANGE COLUMN a a VARCHAR(101); SHOW CREATE TABLE t; Table Create Table t CREATE TABLE `t` ( `a` varchar(101) DEFAULT NULL, `b` varchar(100) DEFAULT NULL ) ENGINE=TokuDB DEFAULT CHARSET=latin1 ALTER TABLE t CHANGE COLUMN a a VARCHAR(200); SHOW CREATE TABLE t; Table Create Table t CREATE TABLE `t` ( `a` varchar(200) DEFAULT NULL, `b` varchar(100) DEFAULT NULL ) ENGINE=TokuDB DEFAULT CHARSET=latin1 SELECT * FROM t; a b hi there you people DROP TABLE t; CREATE TABLE t (i INT, a VARCHAR(100), b VARCHAR(100)) ENGINE=Tokudb; INSERT INTO t VALUES (1, 'hi','there'),(2, 'you','people'); SELECT * FROM t; i a b 1 hi there 2 you people ALTER TABLE t CHANGE COLUMN a a VARCHAR(101); SHOW CREATE TABLE t; Table Create Table t CREATE TABLE `t` ( `i` int(11) DEFAULT NULL, `a` varchar(101) DEFAULT NULL, `b` varchar(100) DEFAULT NULL ) ENGINE=TokuDB DEFAULT CHARSET=latin1 ALTER TABLE t CHANGE COLUMN a a VARCHAR(200); SHOW CREATE TABLE t; Table Create Table t CREATE TABLE `t` ( `i` int(11) DEFAULT NULL, `a` varchar(200) DEFAULT NULL, `b` varchar(100) DEFAULT NULL ) ENGINE=TokuDB DEFAULT CHARSET=latin1 SELECT * FROM t; i a b 1 hi there 2 you people DROP TABLE t;