Debian Codegraph @

mysql-test/suite/perfschema/r/pfs_fk.result

raw
1 CREATE TABLE parent (
2 id INT NOT NULL,
3 PRIMARY KEY (id)
4 ) ENGINE=INNODB;
5 CREATE TABLE child (
6 id INT,
7 parent_id INT,
8 INDEX par_ind (parent_id),
9 FOREIGN KEY (parent_id)
10 REFERENCES parent(id)
11 ON DELETE CASCADE
12 ) ENGINE=INNODB;
13 SET DEBUG_SYNC= 'alter_table_after_mdl_lock_fk SIGNAL mdl_fk_acquired WAIT_FOR resume';
14 ALTER TABLE child DROP FOREIGN KEY `child_ibfk_1`;;
15 SET DEBUG_SYNC= 'now WAIT_FOR mdl_fk_acquired';
16 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, COLUMN_NAME,
17 LOCK_TYPE, LOCK_DURATION, LOCK_STATUS
18 FROM performance_schema.metadata_locks
19 WHERE (OBJECT_TYPE = 'SCHEMA') AND (OBJECT_SCHEMA = 'test')
20 ORDER BY OBJECT_SCHEMA, LOCK_TYPE, LOCK_DURATION, LOCK_STATUS;
21 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME COLUMN_NAME LOCK_TYPE LOCK_DURATION LOCK_STATUS
22 SCHEMA test NULL NULL INTENTION_EXCLUSIVE STATEMENT GRANTED
23 SCHEMA test NULL NULL INTENTION_EXCLUSIVE TRANSACTION GRANTED
24 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, COLUMN_NAME,
25 LOCK_TYPE, LOCK_DURATION, LOCK_STATUS
26 FROM performance_schema.metadata_locks
27 WHERE (OBJECT_TYPE = 'TABLE') AND (OBJECT_SCHEMA = 'test')
28 ORDER BY OBJECT_SCHEMA, OBJECT_NAME, LOCK_TYPE, LOCK_DURATION, LOCK_STATUS;
29 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME COLUMN_NAME LOCK_TYPE LOCK_DURATION LOCK_STATUS
30 TABLE test child NULL SHARED_UPGRADABLE TRANSACTION GRANTED
31 TABLE test parent NULL SHARED_UPGRADABLE STATEMENT GRANTED
32 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, COLUMN_NAME,
33 LOCK_TYPE, LOCK_DURATION, LOCK_STATUS
34 FROM performance_schema.metadata_locks
35 WHERE (OBJECT_TYPE = 'FOREIGN KEY') AND (OBJECT_SCHEMA = 'test')
36 ORDER BY OBJECT_SCHEMA, OBJECT_NAME, LOCK_TYPE, LOCK_DURATION, LOCK_STATUS;
37 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME COLUMN_NAME LOCK_TYPE LOCK_DURATION LOCK_STATUS
38 FOREIGN KEY test child_ibfk_1 NULL EXCLUSIVE STATEMENT GRANTED
39 SET DEBUG_SYNC= 'now SIGNAL resume';
40 SET DEBUG_SYNC='RESET';
41 DROP TABLE child;
42 DROP TABLE parent;