Debian Codegraph @

mysql-test/suite/perfschema/t/mdl_update_lock.test

raw
1 # The LOCK_TYPE in table performance_schema.metadata_locks
2 # does not change after MDL upgrade or downgrade
3
4 --source include/have_debug.inc
5 --source include/have_debug_sync.inc
6
7 # Prepare
8 connect (con1, localhost, root, , );
9
10 create table t1 (id int key, c1 int);
11 insert into t1 values (1, 10);
12
13 # DDL and check MDL LOCK_TYPE
14 --connection con1
15
16 SET DEBUG_SYNC='RESET';
17 SET DEBUG_SYNC= 'alter_opened_table WAIT_FOR continue1';
18 SET DEBUG_SYNC= 'alter_table_copy_after_lock_upgrade WAIT_FOR continue2';
19 SET DEBUG_SYNC= 'alter_table_before_main_binlog WAIT_FOR continue3';
20
21 --echo # Sending:
22 --send alter table t1 change column c1 c1 bigint
23
24
25 --connection default
26
27 # Wait for the ALTER TABLE to reach the sync point 1.
28 let $wait_timeout= 5;
29 let $wait_condition=
30 SELECT COUNT(*) = 1 FROM performance_schema.metadata_locks
31 WHERE OBJECT_TYPE = 'TABLE' and OBJECT_NAME = 't1'
32 AND LOCK_TYPE = 'SHARED_UPGRADABLE';
33 --source include/wait_condition.inc
34
35 # expect SHARED_UPGRADABLE
36 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, LOCK_TYPE, LOCK_DURATION, LOCK_STATUS
37 FROM performance_schema.metadata_locks
38 WHERE OBJECT_TYPE = 'TABLE' and OBJECT_NAME = 't1';
39
40 SET DEBUG_SYNC= 'now SIGNAL continue1';
41
42 # Wait for the ALTER TABLE to reach the sync point 2.
43 let $wait_timeout= 5;
44 let $wait_condition=
45 SELECT COUNT(*) = 1 FROM performance_schema.metadata_locks
46 WHERE OBJECT_TYPE = 'TABLE' and OBJECT_NAME = 't1'
47 AND LOCK_TYPE = 'SHARED_NO_WRITE';
48 --source include/wait_condition.inc
49
50 # expect SHARED_NO_WRITE
51 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, LOCK_TYPE, LOCK_DURATION, LOCK_STATUS
52 FROM performance_schema.metadata_locks
53 WHERE OBJECT_TYPE = 'TABLE' and OBJECT_NAME = 't1';
54
55 SET DEBUG_SYNC= 'now SIGNAL continue2';
56
57 # Wait for the ALTER TABLE to reach the sync point 3.
58 let $wait_timeout= 5;
59 let $wait_condition=
60 SELECT COUNT(*) = 1 FROM performance_schema.metadata_locks
61 WHERE OBJECT_TYPE = 'TABLE' and OBJECT_NAME = 't1'
62 AND LOCK_TYPE = 'EXCLUSIVE';
63 --source include/wait_condition.inc
64
65 # expect EXCLUSIVE
66 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, LOCK_TYPE, LOCK_DURATION, LOCK_STATUS
67 FROM performance_schema.metadata_locks
68 WHERE OBJECT_TYPE = 'TABLE' and OBJECT_NAME = 't1';
69
70 SET DEBUG_SYNC= 'now SIGNAL continue3';
71
72 --connection con1
73 --echo # Reaping ALTER TABLE ...
74 --reap
75 SET DEBUG_SYNC= 'RESET';
76
77
78
79 # Cleanup
80 --connection default
81
82 drop table t1;
83