EVOLUTION-MANAGER

Edit File: galera_fk_selfreferential.result

CREATE TABLE t1 ( f1 INT NOT NULL PRIMARY KEY, f2 INT, FOREIGN KEY (f2) REFERENCES t1(f1) ON DELETE CASCADE ) ENGINE=InnoDB; INSERT INTO t1 VALUES (1, 1), (2, 1); connection node_2; DELETE FROM t1 WHERE f1 = 1; connection node_1; SELECT COUNT(*) = 0 FROM t1; COUNT(*) = 0 1 DROP TABLE t1;