Debian Codegraph @

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;