Debian Codegraph @

mysql-test/suite/galera/r/galera_fk_multicolumn.result

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