Debian Codegraph @

mysql-test/suite/galera_sr/r/galera_sr_ddl_slave.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 INTEGER) ENGINE=InnoDB;
5 SET SESSION wsrep_trx_fragment_size = 1;
6 SET AUTOCOMMIT=OFF;
7 START TRANSACTION;
8 INSERT INTO t1 VALUES (1, 1);
9 INSERT INTO t1 VALUES (2, 2);
10 INSERT INTO t1 VALUES (3, 3);
11 INSERT INTO t1 VALUES (4, 4);
12 INSERT INTO t1 VALUES (5, 5);
13 connection node_2;
14 SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
15 SELECT COUNT(*) > 0 FROM mysql.wsrep_streaming_log;
16 COUNT(*) > 0
17 1
18 ALTER TABLE t1 DROP COLUMN f2;
19 SELECT COUNT(*) = 0 FROM t1;
20 COUNT(*) = 0
21 1
22 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
23 COUNT(*) = 0
24 1
25 connection node_1;
26 INSERT INTO t1 VALUES (6, 6);
27 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
28 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
29 COUNT(*) = 0
30 1
31 INSERT INTO t1 VALUES (6, 6);
32 ERROR 21S01: Column count doesn't match value count at row 1
33 START TRANSACTION;
34 INSERT INTO t1 VALUES (1);
35 INSERT INTO t1 VALUES (2);
36 INSERT INTO t1 VALUES (3);
37 INSERT INTO t1 VALUES (4);
38 INSERT INTO t1 VALUES (5);
39 connection node_2;
40 SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
41 connection node_1;
42 COMMIT;
43 connection node_2;
44 SELECT COUNT(*) = 5 FROM t1;
45 COUNT(*) = 5
46 1
47 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
48 COUNT(*) = 0
49 1
50 DROP TABLE t1;