Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 set global auto_increment_offset=1;
5 set global auto_increment_increment=1;
6 connection node_2;
7 set global auto_increment_offset=2;
8 set global auto_increment_increment=1;
9 connection node_1;
10 select @@auto_increment_increment,@@auto_increment_offset;
11 @@auto_increment_increment @@auto_increment_offset
12 1 1
13 create table t1(id serial, val varchar(100)) engine=myisam;
14 insert into t1 values(null, 'a');
15 insert into t1 values(null, 'b');
16 insert into t1 select null, 'c';
17 insert into t1 select null, 'd' from t1;
18 select * from t1 order by id;
19 id val
20 1 a
21 2 b
22 3 c
23 4 d
24 5 d
25 6 d
26 create table t2(id serial, val varchar(100)) engine=aria;
27 insert into t2 values(null, 'a');
28 insert into t2 values(null, 'b');
29 insert into t2 select null, 'c';
30 insert into t2 select null, 'd' from t2;
31 select * from t2 order by id;
32 id val
33 1 a
34 2 b
35 3 c
36 4 d
37 5 d
38 6 d
39 create table t3(id serial, val varchar(100)) engine=innodb;
40 insert into t3 values(null, 'a');
41 insert into t3 values(null, 'b');
42 insert into t3 select null, 'c';
43 insert into t3 select null, 'd' from t3;
44 select * from t3 order by id;
45 id val
46 1 a
47 2 b
48 3 c
49 4 d
50 5 d
51 6 d
52 set global wsrep_mode='REPLICATE_MYISAM,REPLICATE_ARIA';
53 create table t4(id serial, val varchar(100)) engine=myisam;
54 insert into t4 values(null, 'a');
55 insert into t4 values(null, 'b');
56 insert into t4 select null, 'c';
57 insert into t4 select null, 'd' from t4;
58 select * from t4 order by id;
59 id val
60 1 a
61 2 b
62 3 c
63 4 d
64 5 d
65 6 d
66 create table t5(id serial, val varchar(100)) engine=myisam;
67 insert into t5 values(null, 'a');
68 insert into t5 values(null, 'b');
69 insert into t5 select null, 'c';
70 insert into t5 select null, 'd' from t5;
71 select * from t5 order by id;
72 id val
73 1 a
74 2 b
75 3 c
76 4 d
77 5 d
78 6 d
79 connection node_2;
80 select @@auto_increment_increment,@@auto_increment_offset;
81 @@auto_increment_increment @@auto_increment_offset
82 1 2
83 select * from t1 order by id;
84 id val
85 select * from t2 order by id;
86 id val
87 select * from t3 order by id;
88 id val
89 1 a
90 2 b
91 3 c
92 4 d
93 5 d
94 6 d
95 select * from t4 order by id;
96 id val
97 1 a
98 2 b
99 3 c
100 4 d
101 5 d
102 6 d
103 select * from t5 order by id;
104 id val
105 1 a
106 2 b
107 3 c
108 4 d
109 5 d
110 6 d
111 connection node_1;
112 drop table t1,t2,t3,t4,t5;
113 set global wsrep_mode=default;