blob: 9f6637826abe8bea629044cc37eaffde497fe067 (
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 `compression`='tokudb_zlib'
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 `compression`='tokudb_zlib'
DROP TABLE t;
|