blob: 426834da11bc469d734b3b8ce3432f698d07bf10 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
set default_storage_engine='tokudb';
DROP TABLE IF EXISTS s, t;
CREATE TABLE s (a INT);
SHOW CREATE TABLE s;
Table Create Table
s CREATE TABLE `s` (
`a` int(11) DEFAULT NULL
) ENGINE=TokuDB DEFAULT CHARSET=latin1
SET tokudb_disable_slow_alter=1;
ALTER TABLE s RENAME TO t, ADD COLUMN b INT;
SHOW CREATE TABLE t;
Table Create Table
t CREATE TABLE `t` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL
) ENGINE=TokuDB DEFAULT CHARSET=latin1
DROP TABLE t;
|