Debian Codegraph @

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

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3 --source include/have_aria.inc
4 --source include/force_restart.inc
5
6 --connection node_1
7 set global auto_increment_offset=1;
8 set global auto_increment_increment=1;
9
10 --connection node_2
11 set global auto_increment_offset=2;
12 set global auto_increment_increment=1;
13
14 --connection node_1
15 select @@auto_increment_increment,@@auto_increment_offset;
16 create table t1(id serial, val varchar(100)) engine=myisam;
17 insert into t1 values(null, 'a');
18 insert into t1 values(null, 'b');
19 insert into t1 select null, 'c';
20 insert into t1 select null, 'd' from t1;
21 select * from t1 order by id;
22
23 create table t2(id serial, val varchar(100)) engine=aria;
24 insert into t2 values(null, 'a');
25 insert into t2 values(null, 'b');
26 insert into t2 select null, 'c';
27 insert into t2 select null, 'd' from t2;
28 select * from t2 order by id;
29
30 create table t3(id serial, val varchar(100)) engine=innodb;
31 insert into t3 values(null, 'a');
32 insert into t3 values(null, 'b');
33 insert into t3 select null, 'c';
34 insert into t3 select null, 'd' from t3;
35 select * from t3 order by id;
36
37 set global wsrep_mode='REPLICATE_MYISAM,REPLICATE_ARIA';
38
39 create table t4(id serial, val varchar(100)) engine=myisam;
40 insert into t4 values(null, 'a');
41 insert into t4 values(null, 'b');
42 insert into t4 select null, 'c';
43 insert into t4 select null, 'd' from t4;
44 select * from t4 order by id;
45
46 create table t5(id serial, val varchar(100)) engine=myisam;
47 insert into t5 values(null, 'a');
48 insert into t5 values(null, 'b');
49 insert into t5 select null, 'c';
50 insert into t5 select null, 'd' from t5;
51 select * from t5 order by id;
52
53 --connection node_2
54 select @@auto_increment_increment,@@auto_increment_offset;
55 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't5'
56 --source include/wait_condition.inc
57 --let $wait_condition = SELECT COUNT(*) = 6 FROM t5
58 --source include/wait_condition.inc
59
60 select * from t1 order by id;
61 select * from t2 order by id;
62 select * from t3 order by id;
63 select * from t4 order by id;
64 select * from t5 order by id;
65
66 --connection node_1
67 drop table t1,t2,t3,t4,t5;
68 set global wsrep_mode=default;