1source include/have_tokudb.inc; 2# test that varchar(X) to varchar(X) not null is not supported (different type) 3 4--disable_warnings 5DROP TABLE IF EXISTS t; 6--enable_warnings 7 8SET SESSION TOKUDB_DISABLE_SLOW_ALTER=ON; 9 10# nullable -> not null not supporte 11CREATE TABLE t (a VARCHAR(100), b VARCHAR(256)) ENGINE=TokuDB; 12 13--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ 14--error ER_UNSUPPORTED_EXTENSION 15ALTER TABLE t CHANGE COLUMN a a VARCHAR(1) NOT NULL; 16 17--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ 18--error ER_UNSUPPORTED_EXTENSION 19ALTER TABLE t CHANGE COLUMN a a VARCHAR(255) NOT NULL; 20 21--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ 22--error ER_UNSUPPORTED_EXTENSION 23ALTER TABLE t CHANGE COLUMN a a VARCHAR(256) NOT NULL; 24 25--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ 26--error ER_UNSUPPORTED_EXTENSION 27ALTER TABLE t CHANGE COLUMN b b VARCHAR(255) NOT NULL; 28 29--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ 30--error ER_UNSUPPORTED_EXTENSION 31ALTER TABLE t CHANGE COLUMN b b VARCHAR(1024) NOT NULL; 32 33--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ 34--error ER_UNSUPPORTED_EXTENSION 35ALTER TABLE t CHANGE COLUMN b b VARCHAR(256) NOT NULL; 36 37DROP TABLE t; 38 39# not null -> nullable not supported 40CREATE TABLE t (a VARCHAR(100) NOT NULL, b VARCHAR(256) NOT NULL) ENGINE=TokuDB; 41 42--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ 43--error ER_UNSUPPORTED_EXTENSION 44ALTER TABLE t CHANGE COLUMN a a VARCHAR(1); 45 46--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ 47--error ER_UNSUPPORTED_EXTENSION 48ALTER TABLE t CHANGE COLUMN a a VARCHAR(255); 49 50--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ 51--error ER_UNSUPPORTED_EXTENSION 52ALTER TABLE t CHANGE COLUMN a a VARCHAR(256); 53 54--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ 55--error ER_UNSUPPORTED_EXTENSION 56ALTER TABLE t CHANGE COLUMN b b VARCHAR(255); 57 58--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ 59--error ER_UNSUPPORTED_EXTENSION 60ALTER TABLE t CHANGE COLUMN b b VARCHAR(1024); 61 62--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ 63--error ER_UNSUPPORTED_EXTENSION 64ALTER TABLE t CHANGE COLUMN b b VARCHAR(256); 65 66DROP TABLE t; 67