blob: 6cbf0f9b5b7d22d441f8296f3dbe2f8042c4a1a7 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
DROP TABLE IF EXISTS t;
SET SESSION TOKUDB_DISABLE_SLOW_ALTER=ON;
SET SESSION DEFAULT_STORAGE_ENGINE='TokuDB';
CREATE TABLE t (a VARCHAR(32), b VARCHAR(32), KEY(a(2)));
SHOW CREATE TABLE t;
Table Create Table
t CREATE TABLE `t` (
`a` varchar(32) DEFAULT NULL,
`b` varchar(32) DEFAULT NULL,
KEY `a` (`a`(2))
) ENGINE=TokuDB DEFAULT CHARSET=latin1
ALTER TABLE t CHANGE COLUMN b b VARCHAR(100);
ALTER TABLE t CHANGE COLUMN b b VARCHAR(256);
DROP TABLE t;
|
