--source include/galera_cluster.inc --source include/have_innodb.inc --connect (con1,localhost,root,,test) --connect (con2,localhost,root,,test) CREATE TABLE IF NOT EXISTS t1 (id INT AUTO_INCREMENT, f VARCHAR(16), start_time DATE, end_time DATE, PERIOD FOR per(start_time, end_time), PRIMARY KEY(id, per WITHOUT OVERLAPS)); CREATE TABLE IF NOT EXISTS t2 (id VARCHAR(32), f INT, start_time DATE, end_time DATE, PERIOD FOR per(start_time, end_time), PRIMARY KEY(id), UNIQUE(f, per WITHOUT OVERLAPS)); CREATE OR REPLACE TABLE t3 LIKE t1; INSERT IGNORE INTO t2 (start_time, end_time) VALUES ('1976-01-08', '1993-08-02'), ('1976-08-01', '2001-03-31') ORDER BY 1; START TRANSACTION; UPDATE IGNORE t2 SET start_time = '1976-03-27', end_time = '2037-08-14' ORDER BY start_time, end_time; --send DELETE t3.* FROM t1, t3; --connection con1 --send ALTER TABLE t1 FORCE; --connection con2 --reap CREATE TABLE IF NOT EXISTS t4 AS SELECT * FROM t3; # Cleanup DROP TABLE t1, t2, t3, t4; --source include/galera_end.inc