mysql-test/suite/galera/r/MDEV-39685.result
raw| 1 | connection node_2; |
| 2 | connection node_1; |
| 3 | CREATE TABLE t1 ( |
| 4 | pk int PRIMARY KEY, |
| 5 | c varchar(8), |
| 6 | i int |
| 7 | ) ENGINE=InnoDB; |
| 8 | CREATE TABLE t2 (f int) ENGINE=InnoDB; |
| 9 | CREATE TABLE t3 (x int, |
| 10 | FOREIGN KEY (x) REFERENCES t1 (pk) |
| 11 | ) ENGINE=InnoDB; |
| 12 | UPDATE t1 JOIN t2 ON t1.i = t2.f SET t1.c = 'foo'; |
| 13 | DROP TABLE t3, t2, t1; |