Debian Codegraph @

mysql-test/suite/galera_sr/t/GCF-851.test

raw
1 --source include/galera_cluster.inc
2
3 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
4
5 SET SESSION WSREP_TRX_FRAGMENT_SIZE=1;
6 SET SESSION AUTOCOMMIT=OFF;
7
8 INSERT INTO t1 VALUES (10);
9 SELECT COUNT(*) > 0 FROM mysql.wsrep_streaming_log;
10 --connection node_2
11 SELECT COUNT(*) > 0 FROM mysql.wsrep_streaming_log;
12
13 --connection node_1
14 START TRANSACTION;
15 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
16
17 --connection node_2
18 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
19 SELECT COUNT(*) > 0 FROM t1;
20
21 --connection node_1
22 SELECT COUNT(*) > 0 FROM t1;
23 DROP TABLE t1;