1--source include/have_tokudb.inc 2# 3# Attempt to change row format with and without 4# other ALTER TABLE statements. 5# 6SET DEFAULT_STORAGE_ENGINE='tokudb'; 7 8--disable_warnings 9DROP TABLE IF EXISTS foo; 10--enable_warnings 11 12set session tokudb_disable_slow_alter=ON; 13create table foo(a int auto_increment, b int, primary key (a)); 14 15insert into foo (b) values (11),(21),(32); 16select * from foo; 17 18alter table foo auto_increment=1000; 19show create table foo; 20insert into foo (b) values (11),(21),(32); 21select * from foo; 22show create table foo; 23 24alter table foo auto_increment=10; 25insert into foo (b) values (11),(21),(32); 26select * from foo; 27show create table foo; 28 29--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ 30--error ER_UNSUPPORTED_EXTENSION 31alter table foo auto_increment=100000, add column c int; 32 33--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ 34--error ER_UNSUPPORTED_EXTENSION 35alter table foo auto_increment=100000, drop column b; 36 37--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ 38--error ER_UNSUPPORTED_EXTENSION 39alter table foo auto_increment=100000, add key b(b); 40 41--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ 42--error ER_UNSUPPORTED_EXTENSION 43alter table foo auto_increment=100000, change b b bigint; 44 45--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ 46--error ER_UNSUPPORTED_EXTENSION 47alter table foo auto_increment=100000, change b c int; 48 49--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ 50--error ER_UNSUPPORTED_EXTENSION 51alter table foo auto_increment=100000, COMPRESSION=TOKUDB_LZMA; 52 53--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ 54--error ER_UNSUPPORTED_EXTENSION 55alter table foo auto_increment=100000, change b b int DEFAULT 111; 56 57 58DROP TABLE foo; 59