Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 CREATE DATABASE d1;
4 CREATE TABLE d1.t1(f1 INTEGER) ENGINE=InnoDB;
5 CREATE DATABASE d2;
6 CREATE TABLE d2.t1(f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
7 connection node_1;
8 SET AUTOCOMMIT=OFF;
9 START TRANSACTION;
10 INSERT INTO d1.t1 VALUES (1);
11 connection node_2;
12 SET AUTOCOMMIT=OFF;
13 START TRANSACTION;
14 INSERT INTO d2.t1 VALUES (1);
15 connection node_1;
16 COMMIT;
17 connection node_2;
18 COMMIT;
19 SELECT COUNT(*) = 1 FROM d1.t1;
20 COUNT(*) = 1
21 1
22 SELECT COUNT(*) = 1 FROM d2.t1;
23 COUNT(*) = 1
24 1
25 connection node_1;
26 SELECT COUNT(*) = 1 FROM d1.t1;
27 COUNT(*) = 1
28 1
29 SELECT COUNT(*) = 1 FROM d2.t1;
30 COUNT(*) = 1
31 1
32 DROP TABLE d1.t1;
33 DROP TABLE d2.t1;
34 DROP DATABASE d1;
35 DROP DATABASE d2;