Debian Codegraph @

mysql-test/suite/galera/t/mdev-30653.test

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3 --source include/have_aria.inc
4
5 create table t1 (id serial, val int) engine=innodb;
6 create table t2 (id serial, val int) engine=aria;
7
8 insert into t1 values(1, 23);
9 insert into t2 values(2, 42);
10
11 call mtr.add_suppression("WSREP: Replication of non-transactional engines is experimental\\. Storage engine Aria for table 'test'\\.'t2' is not supported in Galera");
12
13 begin;
14 update t1 set val=24 where id=1;
15 update t2 set val=41 where id=2;
16 --error ER_ERROR_DURING_COMMIT
17 commit;
18
19 select * from t1;
20 select * from t2;
21
22 --connection node_2
23 select * from t1;
24 select * from t2;
25
26 --connection node_1
27 drop table t1, t2;
28
29 # case 2
30 SET GLOBAL wsrep_mode=REPLICATE_ARIA;
31 create table t1 (id serial, val int) engine=innodb;
32 create table t2 (id serial, val int) engine=aria;
33
34 insert into t1 values(1, 23);
35 insert into t2 values(2, 42);
36
37 begin;
38 update t1 set val=24 where id=1;
39 --error ER_ERROR_DURING_COMMIT
40 update t2 set val=41 where id=2;
41 commit;
42
43 select * from t1;
44 select * from t2;
45
46 --connection node_2
47 select * from t1;
48 select * from t2;
49
50 --connection node_1
51 drop table t1, t2;
52
53 # case 3
54 create table t2 (id serial, val int) engine=aria;
55 INSERT INTO t2 values(1,1);
56 UPDATE t2 set id=5,val=6 where id = 1;
57 SELECT * from t2;
58
59 --connection node_2
60 SELECT * from t2;
61 DROP TABLE t2;
62
63 --connection node_1
64 SET GLOBAL wsrep_mode=DEFAULT;