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; |