1source include/have_tokudb.inc;
2--disable_warnings
3DROP TABLE IF EXISTS t;
4--enable_warnings
5
6SET SESSION TOKUDB_DISABLE_SLOW_ALTER=ON;
7
8CREATE TABLE t (a VARBINARY(100), b VARBINARY(256)) ENGINE=TokuDB;
9INSERT INTO t VALUES ('hi','there'),('you','people');
10# expand varbinary
11ALTER TABLE t CHANGE COLUMN a a VARBINARY(256);
12SELECT * FROM t;
13DROP TABLE t;
14
15CREATE TABLE t (a VARBINARY(100), b VARBINARY(256)) ENGINE=TokuDB;
16INSERT INTO t VALUES ('hi','there'),('you','people');
17# expand varbinary and rename column
18ALTER TABLE t CHANGE COLUMN a a VARBINARY(256);
19SELECT * FROM t;
20DROP TABLE t;