EVOLUTION-MANAGER

Edit File: auto_inc.test

--source include/have_tokudb.inc
#
# Attempt to change row format with and without
# other ALTER TABLE statements.
#
SET DEFAULT_STORAGE_ENGINE='tokudb';

--disable_warnings
DROP TABLE IF EXISTS foo;
--enable_warnings

set session tokudb_disable_slow_alter=ON;
create table foo(a int auto_increment, b int, primary key (a));

insert into foo (b) values (11),(21),(32);
select * from foo;

alter table foo auto_increment=1000;
show create table foo;
insert into foo (b) values (11),(21),(32);
select * from foo;
show create table foo;

alter table foo auto_increment=10;
insert into foo (b) values (11),(21),(32);
select * from foo;
show create table foo;

--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
--error ER_UNSUPPORTED_EXTENSION
alter table foo auto_increment=100000, add column c int;

--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
--error ER_UNSUPPORTED_EXTENSION
alter table foo auto_increment=100000, drop column b;

--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
--error ER_UNSUPPORTED_EXTENSION
alter table foo auto_increment=100000, add key b(b);

--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
--error ER_UNSUPPORTED_EXTENSION
alter table foo auto_increment=100000, change b b bigint;

--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
--error ER_UNSUPPORTED_EXTENSION
alter table foo auto_increment=100000, change b c int;

--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
--error ER_UNSUPPORTED_EXTENSION
alter table foo auto_increment=100000, COMPRESSION=TOKUDB_LZMA;

--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
--error ER_UNSUPPORTED_EXTENSION
alter table foo auto_increment=100000, change b b int DEFAULT 111;

DROP TABLE foo;