Debian Codegraph @

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

raw
1 #
2 # Test that identical updates can be delivered to two separate
3 # databases without this causing a certification conflict
4 #
5
6 --source include/galera_cluster.inc
7 --source include/have_innodb.inc
8
9 CREATE DATABASE d1;
10 CREATE TABLE d1.t1(f1 INTEGER) ENGINE=InnoDB;
11
12 CREATE DATABASE d2;
13 CREATE TABLE d2.t1(f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
14
15 --connection node_1
16 SET AUTOCOMMIT=OFF;
17 START TRANSACTION;
18 INSERT INTO d1.t1 VALUES (1);
19
20 --connection node_2
21 SET AUTOCOMMIT=OFF;
22 START TRANSACTION;
23 INSERT INTO d2.t1 VALUES (1);
24
25 --connection node_1
26 COMMIT;
27
28 --connection node_2
29 COMMIT;
30
31 SELECT COUNT(*) = 1 FROM d1.t1;
32 SELECT COUNT(*) = 1 FROM d2.t1;
33
34 --connection node_1
35
36 SELECT COUNT(*) = 1 FROM d1.t1;
37 SELECT COUNT(*) = 1 FROM d2.t1;
38
39 DROP TABLE d1.t1;
40 DROP TABLE d2.t1;
41
42 DROP DATABASE d1;
43 DROP DATABASE d2;