Debian Codegraph @

mysql-test/suite/galera_sr/r/galera-features#56.result

raw
1 connection node_2;
2 connection node_1;
3 SET SESSION wsrep_trx_fragment_size = 1;
4 connection node_1;
5 CREATE TABLE ten (f1 INTEGER NOT NULL PRIMARY KEY) Engine=InnoDB;
6 INSERT INTO ten VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
7 CREATE TABLE t1 (f1 INTEGER AUTO_INCREMENT PRIMARY KEY, f2 INTEGER) Engine=InnoDB;
8 SET SESSION wsrep_trx_fragment_size = 1;
9 connection node_2;
10 set session wsrep_sync_wait=15;
11 SELECT COUNT(*) from ten;
12 COUNT(*)
13 10
14 SELECT COUNT(*) from t1;
15 COUNT(*)
16 0
17 set session wsrep_sync_wait=0;
18 SET GLOBAL wsrep_slave_threads = 4;
19 SET SESSION wsrep_trx_fragment_size = 1;
20 connection node_1;
21 INSERT INTO t1 (f2) SELECT 1 FROM ten AS a1, ten AS a2;;
22 connection node_1a;
23 INSERT INTO t1 (f2) SELECT 1 FROM ten AS a1, ten AS a2;;
24 connection node_2;
25 INSERT INTO t1 (f2) SELECT 1 FROM ten AS a1, ten AS a2;;
26 connection node_1;
27 connection node_1a;
28 connection node_2;
29 set session wsrep_sync_wait=15;
30 SELECT COUNT(*) FROM t1;
31 COUNT(*)
32 300
33 SELECT COUNT(DISTINCT f1) FROM t1;
34 COUNT(DISTINCT f1)
35 300
36 connection default;
37 DROP TABLE t1;
38 DROP TABLE ten;