Debian Codegraph @

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

raw
1 --source include/have_debug.inc
2
3 # Save the initial number of concurrent sessions
4 --source include/count_sessions.inc
5
6 --echo #
7 --echo # Bug# 20005279 ASSERT !OTHER_LOCK, LOCK_MOVE_REORGANIZE_PAGE()
8 --echo #
9
10 create table t1 (f1 int auto_increment primary key,
11 f2 char(255)) engine=innodb;
12
13 let $inc = 50;
14
15 start transaction;
16 --disable_query_log
17
18 while ($inc)
19 {
20 insert into t1(f2) values (repeat('~', 50));
21 dec $inc;
22 }
23
24 --enable_query_log
25 commit;
26
27 start transaction;
28 select f1, f2 from t1 where f1 = 20 for update;
29
30 --echo # Connection con1:
31 connect (con1,localhost,root,,);
32 --send
33 select f1 from t1 where f1 = 20 for update;
34
35 --echo # Connection default:
36 connection default;
37
38 let $wait_condition=
39 select count(*) = 1 from information_schema.processlist
40 where INFO = 'select f1 from t1 where f1 = 20 for update';
41
42 --source include/wait_condition.inc
43
44 SET DEBUG='+d,do_page_reorganize,do_lock_reverse_page_reorganize';
45 insert into t1(f2) values (repeat('+', 100));
46 SET DEBUG='-d,do_page_reorganize,do_lock_reverse_page_reorganize';
47 commit;
48
49 --echo # Connection con1:
50 connection con1;
51 --reap
52 disconnect con1;
53
54 --echo # Connection default:
55 connection default;
56
57 drop table t1;
58
59 # Wait till all disconnects are completed
60 --source include/wait_until_count_sessions.inc