Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE t1 (
4 f1 INT NOT NULL PRIMARY KEY,
5 f2 INT,
6 FOREIGN KEY (f2)
7 REFERENCES t1(f1)
8 ON DELETE CASCADE
9 ) ENGINE=InnoDB;
10 INSERT INTO t1 VALUES (1, 1), (2, 1);
11 connection node_2;
12 DELETE FROM t1 WHERE f1 = 1;
13 connection node_1;
14 SELECT COUNT(*) = 0 FROM t1;
15 COUNT(*) = 0
16 1
17 DROP TABLE t1;