blob: a0b34cefef83e91cf6a9ca4531d33d1fd6aecc02 (
plain)
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;
|