1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
--source include/have_tokudb.inc
SET DEFAULT_STORAGE_ENGINE='TokuDB';
--disable_warnings
DROP TABLE IF EXISTS foo;
--enable_warnings
SET SESSION tokudb_disable_slow_alter=1;
CREATE TABLE foo (a INT NOT NULL DEFAULT 0, b INT DEFAULT NULL);
SHOW CREATE TABLE foo;
ALTER TABLE foo ALTER COLUMN a SET DEFAULT 100;
SHOW CREATE TABLE foo;
ALTER TABLE foo ALTER COLUMN a DROP DEFAULT;
SHOW CREATE TABLE foo;
ALTER TABLE foo ALTER COLUMN b SET DEFAULT 42;
SHOW CREATE TABLE foo;
ALTER TABLE foo ALTER COLUMN b DROP DEFAULT;
SHOW CREATE TABLE foo;
DROP TABLE foo;
|
