1source include/have_tokudb.inc; 2# test that expansion of a char field in a key is not supported 3 4--disable_warnings 5DROP TABLE IF EXISTS t; 6--enable_warnings 7 8SET SESSION TOKUDB_DISABLE_SLOW_ALTER=ON; 9SET SESSION DEFAULT_STORAGE_ENGINE='TokuDB'; 10 11CREATE TABLE t (a CHAR(100), b CHAR(200), KEY(a), KEY(b)); 12 13ALTER TABLE t CHANGE COLUMN a a CHAR(100); 14 15--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ 16--error ER_UNSUPPORTED_EXTENSION 17ALTER TABLE t CHANGE COLUMN a a CHAR(1); 18 19--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ 20--error ER_UNSUPPORTED_EXTENSION 21ALTER TABLE t CHANGE COLUMN a a CHAR(255); 22 23ALTER TABLE t CHANGE COLUMN b b CHAR(200); 24 25--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ 26--error ER_UNSUPPORTED_EXTENSION 27ALTER TABLE t CHANGE COLUMN b b CHAR(1); 28 29--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ 30--error ER_UNSUPPORTED_EXTENSION 31ALTER TABLE t CHANGE COLUMN b b CHAR(255); 32 33DROP TABLE t; 34 35CREATE TABLE t (a CHAR(1), b CHAR(2), KEY(a,b)); 36 37--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ 38--error ER_UNSUPPORTED_EXTENSION 39ALTER TABLE t CHANGE COLUMN a a CHAR(3); 40 41--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ 42--error ER_UNSUPPORTED_EXTENSION 43ALTER TABLE t CHANGE COLUMN b b CHAR(3); 44 45DROP TABLE t; 46 47 48