1# 2# MDEV-5574 Set AUTO_INCREMENT below max value of column 3# 4--source include/have_innodb.inc 5create table t1(a int(10)unsigned not null auto_increment primary key, 6b varchar(255) not null) engine=innodb default charset=utf8; 7insert into t1 values(1,'aaa'),(2,'bbb'); 8alter table t1 auto_increment=1; 9insert into t1 values(NULL, 'ccc'); 10select * from t1; 11drop table t1; 12 13