1CREATE TABLE Bug_60196_FK1 (Primary_Key INT PRIMARY KEY) ENGINE=InnoDB; 2CREATE TABLE Bug_60196_FK2 (Primary_Key INT PRIMARY KEY) ENGINE=InnoDB; 3CREATE TABLE Bug_60196 ( 4FK1_Key INT NOT NULL, 5FK2_Key INT NOT NULL, 6PRIMARY KEY (FK2_Key, FK1_Key), 7KEY FK1_Key (FK1_Key), 8KEY FK2_Key (FK2_Key), 9CONSTRAINT FK_FK1 FOREIGN KEY (FK1_Key) 10REFERENCES Bug_60196_FK1 (Primary_Key) 11ON DELETE CASCADE 12ON UPDATE CASCADE, 13CONSTRAINT FK_FK2 FOREIGN KEY (FK2_Key) 14REFERENCES Bug_60196_FK2 (Primary_Key) 15ON DELETE CASCADE 16ON UPDATE CASCADE 17) ENGINE=InnoDB; 18INSERT INTO Bug_60196_FK1 VALUES (1), (2), (3), (4), (5); 19INSERT INTO Bug_60196_FK2 VALUES (1), (2), (3), (4), (5); 20INSERT INTO Bug_60196 VALUES (1, 1); 21INSERT INTO Bug_60196 VALUES (1, 2); 22INSERT INTO Bug_60196 VALUES (1, 3); 23INSERT INTO Bug_60196 VALUES (1, 99); 24ERROR 23000: Cannot add or update a child row: a foreign key constraint fails (`test`.`bug_60196`, CONSTRAINT `FK_FK2` FOREIGN KEY (`FK2_Key`) REFERENCES `Bug_60196_FK2` (`Primary_Key`) ON DELETE CASCADE ON UPDATE CASCADE) 25INSERT INTO Bug_60196 VALUES (99, 1); 26ERROR 23000: Cannot add or update a child row: a foreign key constraint fails (`test`.`bug_60196`, CONSTRAINT `FK_FK1` FOREIGN KEY (`FK1_Key`) REFERENCES `Bug_60196_FK1` (`Primary_Key`) ON DELETE CASCADE ON UPDATE CASCADE) 27SELECT * FROM bug_60196_FK1; 28Primary_Key 291 302 313 324 335 34SELECT * FROM bug_60196_FK2; 35Primary_Key 361 372 383 394 405 41SELECT * FROM bug_60196; 42FK1_Key FK2_Key 431 1 441 2 451 3 46# Stop server 47# Restart server. 48# 49# Try to insert more to the example table with foreign keys. 50# Bug60196 causes the foreign key file not to be found after 51# the resstart above. 52# 53SELECT * FROM Bug_60196; 54FK1_Key FK2_Key 551 1 561 2 571 3 58INSERT INTO Bug_60196 VALUES (2, 1); 59INSERT INTO Bug_60196 VALUES (2, 2); 60INSERT INTO Bug_60196 VALUES (2, 3); 61SELECT * FROM Bug_60196; 62FK1_Key FK2_Key 631 1 641 2 651 3 662 1 672 2 682 3 69 70# Clean up. 71DROP TABLE Bug_60196; 72DROP TABLE Bug_60196_FK1; 73DROP TABLE Bug_60196_FK2; 74CREATE TABLE Bug_60309_FK ( 75ID INT PRIMARY KEY, 76ID2 INT, 77KEY K2(ID2) 78) ENGINE=InnoDB; 79CREATE TABLE Bug_60309 ( 80ID INT PRIMARY KEY, 81FK_ID INT, 82KEY (FK_ID), 83CONSTRAINT FK FOREIGN KEY (FK_ID) REFERENCES Bug_60309_FK (ID) 84) ENGINE=InnoDB; 85INSERT INTO Bug_60309_FK (ID, ID2) VALUES (1, 1), (2, 2), (3, 3); 86INSERT INTO Bug_60309 VALUES (1, 1); 87INSERT INTO Bug_60309 VALUES (2, 99); 88ERROR 23000: Cannot add or update a child row: a foreign key constraint fails (`test`.`bug_60309`, CONSTRAINT `FK` FOREIGN KEY (`FK_ID`) REFERENCES `Bug_60309_FK` (`ID`)) 89SELECT * FROM Bug_60309_FK; 90ID ID2 911 1 922 2 933 3 94SELECT * FROM Bug_60309; 95ID FK_ID 961 1 97# Stop server 98# Restart server. 99# 100# Try to insert more to the example table with foreign keys. 101# Bug60309 causes the foreign key file not to be found after 102# the resstart above. 103# 104SELECT * FROM Bug_60309; 105ID FK_ID 1061 1 107INSERT INTO Bug_60309 VALUES (2, 2); 108INSERT INTO Bug_60309 VALUES (3, 3); 109SELECT * FROM Bug_60309; 110ID FK_ID 1111 1 1122 2 1133 3 114 115# Clean up. 116DROP TABLE Bug_60309; 117DROP TABLE Bug_60309_FK; 118