change_column_varbin_cross256.result 514 Bytes
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
DROP TABLE IF EXISTS t;
SET SESSION TOKUDB_DISABLE_SLOW_ALTER=ON;
CREATE TABLE t (a VARBINARY(100), b VARBINARY(256)) ENGINE=TokuDB;
INSERT INTO t VALUES ('hi','there'),('you','people');
ALTER TABLE t CHANGE COLUMN a a VARBINARY(256);
SELECT * FROM t;
a	b
hi	there
you	people
DROP TABLE t;
CREATE TABLE t (a VARBINARY(100), b VARBINARY(256)) ENGINE=TokuDB;
INSERT INTO t VALUES ('hi','there'),('you','people');
ALTER TABLE t CHANGE COLUMN a a VARBINARY(256);
SELECT * FROM t;
a	b
hi	there
you	people
DROP TABLE t;