Debian Codegraph @

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

raw
1 create table t1 (a int not null, b int not null) engine=innodb;
2 insert t1 values (1,2),(3,4);
3 lock table t1 write, t1 tr read;
4 flush status;
5 alter table t1 add primary key (b);
6 show status like 'Handler_read_rnd_next';
7 Variable_name Value
8 Handler_read_rnd_next 0
9 unlock tables;
10 alter table t1 drop primary key;
11 lock table t1 write;
12 flush status;
13 alter table t1 add primary key (b);
14 show status like 'Handler_read_rnd_next';
15 Variable_name Value
16 Handler_read_rnd_next 0
17 unlock tables;
18 alter table t1 drop primary key;
19 flush status;
20 alter table t1 add primary key (b);
21 show status like 'Handler_read_rnd_next';
22 Variable_name Value
23 Handler_read_rnd_next 0
24 drop table t1;