mysql-test/suite/galera/t/MDEV-39685.test
raw| 1 | --source include/galera_cluster.inc |
| 2 | --source include/have_innodb.inc |
| 3 | |
| 4 | CREATE TABLE t1 ( |
| 5 | pk int PRIMARY KEY, |
| 6 | c varchar(8), |
| 7 | i int |
| 8 | ) ENGINE=InnoDB; |
| 9 | |
| 10 | CREATE TABLE t2 (f int) ENGINE=InnoDB; |
| 11 | |
| 12 | CREATE TABLE t3 (x int, |
| 13 | FOREIGN KEY (x) REFERENCES t1 (pk) |
| 14 | ) ENGINE=InnoDB; |
| 15 | |
| 16 | UPDATE t1 JOIN t2 ON t1.i = t2.f SET t1.c = 'foo'; |
| 17 | |
| 18 | DROP TABLE t3, t2, t1; |