Debian Codegraph @

mysql-test/suite/galera/r/galera_toi_ddl_fk_update.result

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE ten (f1 INTEGER) ENGINE=InnoDB;
4 INSERT INTO ten VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
5 CREATE TABLE parent (
6 id INT PRIMARY KEY,
7 KEY (id)
8 ) ENGINE=InnoDB;
9 CREATE TABLE child (
10 id INT PRIMARY KEY AUTO_INCREMENT,
11 parent_id INT
12 ) ENGINE=InnoDB;
13 INSERT INTO parent VALUES (1);
14 INSERT INTO child (parent_id) SELECT 1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4;
15 connection node_1;
16 ALTER TABLE child ADD FOREIGN KEY (parent_id) REFERENCES parent(id) ON UPDATE CASCADE;;
17 connection node_2;
18 UPDATE parent SET id = 2 WHERE id = 1;;
19 connection node_1;
20 connection node_2;
21 connection node_2;
22 SELECT COUNT(*) = 10000 FROM child WHERE parent_id = 2;
23 COUNT(*) = 10000
24 1
25 connection node_1;
26 SELECT COUNT(*) = 10000 FROM child WHERE parent_id = 2;
27 COUNT(*) = 10000
28 1
29 DROP TABLE child;
30 DROP TABLE parent;
31 DROP TABLE ten;