Debian Codegraph @

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

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3
4 CREATE TABLE t1 (a INT) ENGINE=InnoDB;
5 INSERT INTO t1 VALUES (1),(2);
6 CREATE TABLE t2 (a INT) ENGINE=Aria;
7 CREATE TRIGGER trg AFTER UPDATE ON t1 FOR EACH ROW INSERT INTO t2 VALUES (NEW.a);
8 SET GLOBAL wsrep_mode=replicate_aria;
9 --error ER_ERROR_DURING_COMMIT
10 UPDATE t1 SET a=10;
11 SELECT * FROM t1;
12 SELECT * FROM t2;
13
14 --connection node_2
15 SELECT * FROM t1;
16 SELECT * FROM t2;
17
18 --connection node_1
19 DROP TRIGGER trg;
20 DROP TABLE t1,t2;
21
22 CREATE TABLE t1 (a INT) ENGINE=InnoDB;
23 INSERT INTO t1 VALUES (1),(2);
24 CREATE TABLE t2 (a INT) ENGINE=InnoDB;
25 CREATE TRIGGER trg AFTER UPDATE ON t1 FOR EACH ROW INSERT INTO t2 VALUES (NEW.a);
26 UPDATE t1 SET a=10;
27 SELECT * FROM t1;
28 SELECT * FROM t2;
29
30 --connection node_2
31 SELECT * FROM t1;
32 SELECT * FROM t2;
33
34 --connection node_1
35 DROP TRIGGER trg;
36 DROP TABLE t1,t2;
37
38 call mtr.add_suppression("WSREP: Replication of non-transactional engines is experimental. Storage engine Aria for table \'test\'\.\'t2\' is not supported in Galera");
39 SET GLOBAL wsrep_mode=DEFAULT;