Debian Codegraph @

mysql-test/suite/innodb/t/instant_auto_inc.test

raw
1 --source include/have_innodb.inc
2
3 create table t(id int primary key, a int) engine=InnoDB;
4 insert into t (id, a) values (1, 1);
5 alter table t modify column id int auto_increment;
6 check table t;
7 insert into t (a) values (2);
8 alter table t modify column id int, algorithm=instant;
9 check table t;
10 insert into t (id, a) values (3, 3);
11 select * from t;
12 check table t;
13 drop table t;