Debian Codegraph @

mysql-test/suite/innodb/r/innodb-get-fk.result

raw
1 CREATE SCHEMA `repro`;
2 CREATE TABLE `repro`.`crew` (
3 `id` int(11) NOT NULL AUTO_INCREMENT,
4 `code` varchar(50) NOT NULL,
5 `name` varchar(50) NOT NULL,
6 `created_at` timestamp NULL DEFAULT NULL,
7 `updated_at` timestamp NULL DEFAULT NULL,
8 PRIMARY KEY (`id`),
9 KEY `code` (`code`)
10 ) ENGINE=InnoDB;
11 CREATE TABLE `repro`.`pilot` (
12 `id` int(11) NOT NULL AUTO_INCREMENT,
13 `code` varchar(50) NOT NULL,
14 `name` varchar(50) NOT NULL,
15 `created_at` timestamp NULL DEFAULT NULL,
16 `updated_at` timestamp NULL DEFAULT NULL,
17 PRIMARY KEY (`id`),
18 KEY `code` (`code`)
19 ) ENGINE=InnoDB;
20 CREATE TABLE `repro`.`crew_role_assigned` (
21 `id` int(11) NOT NULL AUTO_INCREMENT,
22 `crew_id` int(11) NOT NULL,
23 `role_code` varchar(50) NOT NULL,
24 PRIMARY KEY (`id`),
25 KEY `fk_crewRoleAssigned_roleCode` (`role_code`),
26 CONSTRAINT `fk_crewRoleAssigned_crewId` FOREIGN KEY (`crew_id`) REFERENCES `repro`.`crew` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
27 CONSTRAINT `fk_crewRoleAssigned_pilotId` FOREIGN KEY (`crew_id`) REFERENCES `repro`.`pilot` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
28 ) ENGINE=InnoDB COMMENT="This is a comment about tables";
29 # restart: --innodb-read-only
30 ALTER TABLE `repro`.`crew_role_assigned` COMMENT = 'innodb_read_only';
31 ERROR HY000: Table 'crew_role_assigned' is read only
32 SHOW CREATE TABLE `repro`.`crew_role_assigned`;
33 Table Create Table
34 crew_role_assigned CREATE TABLE `crew_role_assigned` (
35 `id` int(11) NOT NULL AUTO_INCREMENT,
36 `crew_id` int(11) NOT NULL,
37 `role_code` varchar(50) NOT NULL,
38 PRIMARY KEY (`id`),
39 KEY `fk_crewRoleAssigned_roleCode` (`role_code`),
40 KEY `fk_crewRoleAssigned_pilotId` (`crew_id`),
41 CONSTRAINT `fk_crewRoleAssigned_crewId` FOREIGN KEY (`crew_id`) REFERENCES `crew` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
42 CONSTRAINT `fk_crewRoleAssigned_pilotId` FOREIGN KEY (`crew_id`) REFERENCES `pilot` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
43 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='This is a comment about tables'
44 SET GLOBAL innodb_buffer_pool_load_now = ON;
45 SET GLOBAL innodb_buffer_pool_dump_now = ON;
46 SET GLOBAL innodb_buffer_pool_load_abort = ON;
47 # restart
48 ALTER TABLE `repro`.`crew_role_assigned` COMMENT = "This is a new comment about tables";
49 SHOW CREATE TABLE `repro`.`crew_role_assigned`;
50 Table Create Table
51 crew_role_assigned CREATE TABLE `crew_role_assigned` (
52 `id` int(11) NOT NULL AUTO_INCREMENT,
53 `crew_id` int(11) NOT NULL,
54 `role_code` varchar(50) NOT NULL,
55 PRIMARY KEY (`id`),
56 KEY `fk_crewRoleAssigned_roleCode` (`role_code`),
57 KEY `fk_crewRoleAssigned_pilotId` (`crew_id`),
58 CONSTRAINT `fk_crewRoleAssigned_crewId` FOREIGN KEY (`crew_id`) REFERENCES `crew` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
59 CONSTRAINT `fk_crewRoleAssigned_pilotId` FOREIGN KEY (`crew_id`) REFERENCES `pilot` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
60 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='This is a new comment about tables'
61 # restart: --innodb-read-only
62 SHOW CREATE TABLE `repro`.`crew_role_assigned`;
63 Table Create Table
64 crew_role_assigned CREATE TABLE `crew_role_assigned` (
65 `id` int(11) NOT NULL AUTO_INCREMENT,
66 `crew_id` int(11) NOT NULL,
67 `role_code` varchar(50) NOT NULL,
68 PRIMARY KEY (`id`),
69 KEY `fk_crewRoleAssigned_roleCode` (`role_code`),
70 KEY `fk_crewRoleAssigned_pilotId` (`crew_id`),
71 CONSTRAINT `fk_crewRoleAssigned_crewId` FOREIGN KEY (`crew_id`) REFERENCES `crew` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
72 CONSTRAINT `fk_crewRoleAssigned_pilotId` FOREIGN KEY (`crew_id`) REFERENCES `pilot` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
73 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='This is a new comment about tables'
74 # restart
75 DROP TABLE `repro`.`crew_role_assigned`;
76 DROP TABLE `repro`.`pilot`;
77 DROP TABLE `repro`.`crew`;
78 DROP SCHEMA `repro`;