1# 2# Broken FK constraints cause assertions 3# 4 5--source include/galera_cluster.inc 6--source include/have_innodb.inc 7 8CREATE TABLE parent1 ( id INT PRIMARY KEY, KEY (id) ) ENGINE=InnoDB; 9CREATE TABLE parent2 ( id INT PRIMARY KEY, KEY (id) ) ENGINE=InnoDB; 10 11CREATE TABLE child ( 12 id INT PRIMARY KEY, 13 parent1_id INT, 14 parent2_id INT, 15 FOREIGN KEY (parent1_id) REFERENCES parent1(id), 16 FOREIGN KEY (parent1_id) REFERENCES parent2(id) 17) ENGINE=InnoDB; 18 19INSERT INTO parent1 VALUES (1); 20INSERT INTO parent2 VALUES (1); 21INSERT INTO child VALUES (1,1,1); 22INSERT INTO child VALUES (2,1,1); 23 24SET foreign_key_checks=OFF; 25DROP TABLE parent1; 26 27UPDATE child SET parent1_id=2 WHERE id=1; 28 29DROP TABLE child; 30DROP TABLE parent2; 31SET foreign_key_checks=ON; 32