Debian Codegraph @

mysql-test/suite/galera/t/MDEV-34117.test

raw
1 --source include/galera_cluster.inc
2
3 --connection node_1
4 CREATE TABLE t1 (c INT);
5 INSERT INTO t1 VALUES (0),(0);
6 CREATE TABLE t2 (c INT);
7 SET SESSION wsrep_trx_fragment_unit='STATEMENTS';
8 SET SESSION wsrep_trx_fragment_size=2;
9 --error ER_TABLEACCESS_DENIED_ERROR
10 DROP TABLE mysql.wsrep_streaming_log;
11 CREATE TRIGGER tgr AFTER INSERT ON t2 FOR EACH ROW UPDATE t1 SET c=c+1;
12 INSERT INTO t2 VALUES (1),(2);
13 SELECT * FROM t1;
14 SELECT * FROM t2;
15
16 SET wsrep_trx_fragment_unit=DEFAULT;
17 SET GLOBAL wsrep_trx_fragment_size=DEFAULT;
18 DROP TRIGGER tgr;
19 DROP TABLE t1, t2;
20
21 --connection node_2
22 SET GLOBAL wsrep_on=OFF;
23 --error ER_WRONG_VALUE_FOR_VAR
24 SET SESSION wsrep_trx_fragment_unit='STATEMENTS';
25 SELECT @@wsrep_trx_fragment_unit;
26 SELECT @@wsrep_trx_fragment_size;
27 --error ER_WRONG_VALUE_FOR_VAR
28 SET SESSION wsrep_trx_fragment_size = 2;
29 SHOW WARNINGS;
30 SELECT @@wsrep_trx_fragment_unit;
31 SELECT @@wsrep_trx_fragment_size;
32 DROP TABLE mysql.wsrep_streaming_log;
33 --error ER_WRONG_VALUE_FOR_VAR
34 SET SESSION wsrep_trx_fragment_unit='STATEMENTS';
35 --error ER_WRONG_VALUE_FOR_VAR
36 SET SESSION wsrep_trx_fragment_size = 2;
37 SHOW WARNINGS;
38 SELECT @@wsrep_trx_fragment_unit;
39 SELECT @@wsrep_trx_fragment_size;
40 SET SESSION wsrep_trx_fragment_size = 0;
41 SELECT @@wsrep_trx_fragment_unit;
42 SELECT @@wsrep_trx_fragment_size;
43 SET GLOBAL wsrep_on=ON;
44 --error ER_WRONG_VALUE_FOR_VAR
45 SET SESSION wsrep_trx_fragment_unit='STATEMENTS';
46 --error ER_WRONG_VALUE_FOR_VAR
47 SET SESSION wsrep_trx_fragment_size = 2;
48 SHOW WARNINGS;
49 SELECT @@wsrep_trx_fragment_unit;
50 SELECT @@wsrep_trx_fragment_size;
51 SET GLOBAL wsrep_on=OFF;
52 CREATE TABLE IF NOT EXISTS mysql.wsrep_streaming_log
53 (
54 node_uuid CHAR(36),
55 trx_id BIGINT,
56 seqno BIGINT,
57 flags INT NOT NULL,
58 frag LONGBLOB NOT NULL,
59 PRIMARY KEY (node_uuid, trx_id, seqno)
60 ) ENGINE=InnoDB STATS_PERSISTENT=0 CHARSET=latin1;
61 SET GLOBAL wsrep_on=ON;
62
63 --connection node_1
64 CREATE TABLE t1 (c INT);
65 INSERT INTO t1 VALUES (0),(0);
66 CREATE TABLE t2 (c INT);
67 SET SESSION wsrep_trx_fragment_unit='STATEMENTS';
68 SET SESSION wsrep_trx_fragment_size=2;
69 CREATE TRIGGER tgr AFTER INSERT ON t2 FOR EACH ROW UPDATE t1 SET c=c+1;
70 INSERT INTO t2 VALUES (1),(2);
71 SELECT * FROM t1;
72 SELECT * FROM t2;
73
74 --connection node_2
75 INSERT INTO t2 VALUES (1),(2);
76 SELECT * FROM t1;
77 SELECT * FROM t2;
78
79 --connection node_1
80 SET wsrep_trx_fragment_unit=DEFAULT;
81 SET GLOBAL wsrep_trx_fragment_size=DEFAULT;
82 DROP TRIGGER tgr;
83 DROP TABLE t1, t2;