--source include/galera_cluster.inc

CREATE TABLE parent(parent_id int not null AUTO_INCREMENT PRIMARY KEY,
parent_name varchar(80)) ENGINE=InnoDB;

CREATE TABLE child(child_id int not null AUTO_INCREMENT PRIMARY KEY,
child_name varchar(80),
child_parent_id int not null,
CONSTRAINT `fk_child_parent`
    FOREIGN KEY (child_parent_id) REFERENCES parent (parent_id)
    ON DELETE CASCADE
    ON UPDATE CASCADE) ENGINE=InnoDB;

INSERT INTO parent VALUES (1, 'first'),(2,'second'),(3,'foo'),(4,'tmp');
INSERT INTO child VALUES (NULL,'first_child',1);
INSERT INTO child VALUES (NULL,'second_child',1);
INSERT INTO child VALUES (NULL,'first_child2',2);
INSERT INTO child VALUES (NULL,'first_child3',2);
INSERT INTO child VALUES (NULL,'first_child4',3);

BEGIN;
UPDATE parent SET parent_name = 'bar' WHERE parent_id = 2;

--connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1
SET SESSION innodb_lock_wait_timeout=2;
--error ER_LOCK_WAIT_TIMEOUT
UPDATE child SET child_parent_id = 5 where child_parent_id = 2;

--connection node_1
COMMIT;
SELECT * FROM parent;
SELECT * FROM child;

--connection node_2

SELECT * FROM parent;
SELECT * FROM child;
DROP TABLE child, parent;

--disconnect node_1a