Debian Codegraph @

mysql-test/suite/galera_sr/t/galera_sr_v1_row_events.test

raw
1 #
2 # Test that Galera SR continues to run even with --log-bin-use-v1-row-events=1
3 #
4
5 --source include/galera_cluster.inc
6 --source include/have_innodb.inc
7
8 CREATE TABLE t1 (f1 INT PRIMARY KEY) ENGINE=InnoDB;
9
10 SET AUTOCOMMIT=OFF;
11 START TRANSACTION;
12 INSERT INTO t1 VALUES (1);
13
14 --connection node_2
15 SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
16 SELECT COUNT(*) = 1 FROM t1;
17
18 --connection node_1
19 COMMIT;
20
21 SET AUTOCOMMIT=ON;
22 UPDATE t1 SET f1 = 2 WHERE f1 = 1;
23
24 --connection node_2
25 SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 2;
26
27 DROP TABLE t1;