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