Debian Codegraph @

mysql-test/suite/galera/t/galera_fk_multicolumn.test

raw
1 #
2 # Test UPDATE on multiple columns with multiple FKs
3 #
4
5 --source include/galera_cluster.inc
6 --source include/have_innodb.inc
7
8 CREATE TABLE t0 (
9 f1 INT PRIMARY KEY,
10 f2 INT UNIQUE NOT NULL
11 );
12
13 CREATE TABLE t1 (
14 f1 INT PRIMARY KEY,
15 FOREIGN KEY (f1)
16 REFERENCES t0(f1)
17 ON UPDATE CASCADE
18 );
19
20 CREATE TABLE t2 (
21 f2 INT PRIMARY KEY,
22 FOREIGN KEY (f2)
23 REFERENCES t0(f2)
24 ON UPDATE CASCADE
25 );
26
27 INSERT INTO t0 VALUES (0, 0);
28 INSERT INTO t1 VALUES (0);
29 INSERT INTO t2 VALUES (0);
30
31 --connection node_2
32 UPDATE t0 SET f1 = 1, f2 = 2;
33
34 --connection node_1
35 SELECT f1 = 1 FROM t1 WHERE f1 = 1;
36 SELECT f2 = 2 FROM t2 WHERE f2 = 2;
37 SELECT f1 = 1 FROM t1;
38 SELECT f2 = 2 FROM t2;
39
40 DROP TABLE t2;
41 DROP TABLE t1;
42 DROP TABLE t0;