blob: 399bb56e9c537eb04b31aed10b491c4e3dce3938 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
DROP TABLE IF EXISTS s,t;
SET DEFAULT_STORAGE_ENGINE='TokuDB';
CREATE TABLE s (a BINARY(1));
INSERT INTO s VALUES (1),(2),(3);
CREATE TABLE t LIKE s;
INSERT INTO t SELECT * FROM s;
SET TOKUDB_DISABLE_HOT_ALTER=0;
ALTER TABLE s CHANGE COLUMN a a BINARY(2);
SELECT HEX(a) FROM s;
HEX(a)
3100
3200
3300
SET TOKUDB_DISABLE_HOT_ALTER=1;
ALTER TABLE t CHANGE COLUMN a a BINARY(2);
SELECT HEX(a) FROM t;
HEX(a)
3100
3200
3300
DROP TABLE s,t;
|
