Debian Codegraph @

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

raw
1
2 --source include/have_debug_sync.inc
3
4 CREATE TABLE parent (
5 id INT NOT NULL,
6 PRIMARY KEY (id)
7 ) ENGINE=INNODB;
8
9 CREATE TABLE child (
10 id INT,
11 parent_id INT,
12 INDEX par_ind (parent_id),
13 FOREIGN KEY (parent_id)
14 REFERENCES parent(id)
15 ON DELETE CASCADE
16 ) ENGINE=INNODB;
17
18 connect (con1, localhost, root);
19
20 --connection default
21 SET DEBUG_SYNC= 'alter_table_after_mdl_lock_fk SIGNAL mdl_fk_acquired WAIT_FOR resume';
22 --send ALTER TABLE child DROP FOREIGN KEY `child_ibfk_1`;
23
24 --connection con1
25 SET DEBUG_SYNC= 'now WAIT_FOR mdl_fk_acquired';
26
27 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, COLUMN_NAME,
28 LOCK_TYPE, LOCK_DURATION, LOCK_STATUS
29 FROM performance_schema.metadata_locks
30 WHERE (OBJECT_TYPE = 'SCHEMA') AND (OBJECT_SCHEMA = 'test')
31 ORDER BY OBJECT_SCHEMA, LOCK_TYPE, LOCK_DURATION, LOCK_STATUS;
32
33 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, COLUMN_NAME,
34 LOCK_TYPE, LOCK_DURATION, LOCK_STATUS
35 FROM performance_schema.metadata_locks
36 WHERE (OBJECT_TYPE = 'TABLE') AND (OBJECT_SCHEMA = 'test')
37 ORDER BY OBJECT_SCHEMA, OBJECT_NAME, LOCK_TYPE, LOCK_DURATION, LOCK_STATUS;
38
39 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, COLUMN_NAME,
40 LOCK_TYPE, LOCK_DURATION, LOCK_STATUS
41 FROM performance_schema.metadata_locks
42 WHERE (OBJECT_TYPE = 'FOREIGN KEY') AND (OBJECT_SCHEMA = 'test')
43 ORDER BY OBJECT_SCHEMA, OBJECT_NAME, LOCK_TYPE, LOCK_DURATION, LOCK_STATUS;
44
45 SET DEBUG_SYNC= 'now SIGNAL resume';
46
47 --connection default
48 --reap
49
50 --connection con1
51 --disconnect con1
52 --source include/wait_until_disconnected.inc
53
54 --connection default
55 SET DEBUG_SYNC='RESET';
56
57 DROP TABLE child;
58 DROP TABLE parent;
59