EVOLUTION-MANAGER

Edit File: alter_column_default.test

--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;