Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 CREATE TABLE t1 (id INT PRIMARY KEY) ENGINE=InnoDB;
5 connection node_2;
6 connection node_1;
7 SET AUTOCOMMIT=OFF;
8 START TRANSACTION;
9 COMMIT;
10 connection node_2;
11 wsrep_last_committed_diff
12 1
13 connection node_2;
14 connection node_1;
15 START TRANSACTION READ ONLY;
16 SELECT COUNT(*) = 0 FROM t1;
17 COUNT(*) = 0
18 1
19 COMMIT;
20 connection node_2;
21 wsrep_last_committed_diff
22 1
23 connection node_1;
24 START TRANSACTION;
25 SELECT COUNT(*) = 0 FROM t1;
26 COUNT(*) = 0
27 1
28 COMMIT;
29 connection node_2;
30 wsrep_last_committed_diff
31 1
32 DROP TABLE t1;