#
# Test self-referential foreign keys
#

--source include/galera_cluster.inc
--source include/have_innodb.inc

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;

DROP TABLE t1;