Debian Codegraph @

mysql-test/suite/innodb/r/instant_auto_inc.result

raw
1 create table t(id int primary key, a int) engine=InnoDB;
2 insert into t (id, a) values (1, 1);
3 alter table t modify column id int auto_increment;
4 check table t;
5 Table Op Msg_type Msg_text
6 test.t check status OK
7 insert into t (a) values (2);
8 alter table t modify column id int, algorithm=instant;
9 check table t;
10 Table Op Msg_type Msg_text
11 test.t check status OK
12 insert into t (id, a) values (3, 3);
13 select * from t;
14 id a
15 1 1
16 2 2
17 3 3
18 check table t;
19 Table Op Msg_type Msg_text
20 test.t check status OK
21 drop table t;