source include/have_tokudb.inc; # test that varchar expansion + default change works --disable_warnings DROP TABLE IF EXISTS t; --enable_warnings SET SESSION TOKUDB_DISABLE_SLOW_ALTER=ON; CREATE TABLE t (a VARCHAR(100) NOT NULL DEFAULT '', b VARCHAR(256) NOT NULL DEFAULT '') ENGINE=TokuDB; SHOW CREATE TABLE t; ALTER TABLE t CHANGE COLUMN a a VARCHAR(255) NOT NULL DEFAULT 'a'; SHOW CREATE TABLE t; ALTER TABLE t CHANGE COLUMN a a VARCHAR(256) NOT NULL DEFAULT 'b'; SHOW CREATE TABLE t; # no shrinkage --replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ --error ER_UNSUPPORTED_EXTENSION ALTER TABLE t CHANGE COLUMN b b VARCHAR(255) NOT NULL DEFAULT 'c'; ALTER TABLE t CHANGE COLUMN b b VARCHAR(1024) NOT NULL DEFAULT 'd'; SHOW CREATE TABLE t; # no shrinkage --replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ --error ER_UNSUPPORTED_EXTENSION ALTER TABLE t CHANGE COLUMN b b VARCHAR(256) NOT NULL DEFAULT 'e'; DROP TABLE t;