Debian Codegraph @

mysql-test/suite/galera/r/MDEV-36909.result

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE t1 (a INT) ENGINE=InnoDB;
4 INSERT INTO t1 VALUES (1),(2);
5 CREATE TABLE t2 (a INT) ENGINE=Aria;
6 CREATE TRIGGER trg AFTER UPDATE ON t1 FOR EACH ROW INSERT INTO t2 VALUES (NEW.a);
7 SET GLOBAL wsrep_mode=replicate_aria;
8 UPDATE t1 SET a=10;
9 ERROR HY000: Transactional commit not supported by involved engine(s)
10 SELECT * FROM t1;
11 a
12 1
13 2
14 SELECT * FROM t2;
15 a
16 connection node_2;
17 SELECT * FROM t1;
18 a
19 1
20 2
21 SELECT * FROM t2;
22 a
23 connection node_1;
24 DROP TRIGGER trg;
25 DROP TABLE t1,t2;
26 CREATE TABLE t1 (a INT) ENGINE=InnoDB;
27 INSERT INTO t1 VALUES (1),(2);
28 CREATE TABLE t2 (a INT) ENGINE=InnoDB;
29 CREATE TRIGGER trg AFTER UPDATE ON t1 FOR EACH ROW INSERT INTO t2 VALUES (NEW.a);
30 UPDATE t1 SET a=10;
31 SELECT * FROM t1;
32 a
33 10
34 10
35 SELECT * FROM t2;
36 a
37 10
38 10
39 connection node_2;
40 SELECT * FROM t1;
41 a
42 10
43 10
44 SELECT * FROM t2;
45 a
46 10
47 10
48 connection node_1;
49 DROP TRIGGER trg;
50 DROP TABLE t1,t2;
51 call mtr.add_suppression("WSREP: Replication of non-transactional engines is experimental. Storage engine Aria for table \'test\'\.\'t2\' is not supported in Galera");
52 SET GLOBAL wsrep_mode=DEFAULT;