Debian Codegraph @

mysql-test/suite/galera/r/galera_binlog_stmt_autoinc.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 connection node_2;
5 connection node_1;
6 SET GLOBAL auto_increment_offset=1;
7 connection node_2;
8 SET GLOBAL auto_increment_offset=2;
9 connection node_2;
10 SET GLOBAL wsrep_forced_binlog_format='STATEMENT';
11 connection node_1;
12 SET GLOBAL wsrep_forced_binlog_format='STATEMENT';
13 CREATE TABLE t1 (
14 i int(11) NOT NULL primary key AUTO_INCREMENT,
15 c char(32) DEFAULT 'dummy_text'
16 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
17 show variables like 'auto_increment%';
18 Variable_name Value
19 auto_increment_increment 2
20 auto_increment_offset 1
21 insert into t1(i) values(null);
22 Warnings:
23 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the slave
24 select * from t1 order by i;
25 i c
26 1 dummy_text
27 insert into t1(i) values(null), (null), (null);
28 Warnings:
29 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the slave
30 select * from t1 order by i;
31 i c
32 1 dummy_text
33 3 dummy_text
34 5 dummy_text
35 7 dummy_text
36 insert into t1(i) values(null);
37 Warnings:
38 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the slave
39 insert into t1(i) values(null);
40 Warnings:
41 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the slave
42 insert into t1(i) values(null);
43 Warnings:
44 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the slave
45 insert into t1(i) values(null);
46 Warnings:
47 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the slave
48 select * from t1 order by i;
49 i c
50 1 dummy_text
51 3 dummy_text
52 5 dummy_text
53 7 dummy_text
54 9 dummy_text
55 11 dummy_text
56 13 dummy_text
57 15 dummy_text
58 connection node_2;
59 show variables like 'auto_increment%';
60 Variable_name Value
61 auto_increment_increment 2
62 auto_increment_offset 2
63 select * from t1 order by i;
64 i c
65 1 dummy_text
66 3 dummy_text
67 5 dummy_text
68 7 dummy_text
69 9 dummy_text
70 11 dummy_text
71 13 dummy_text
72 15 dummy_text
73 SET GLOBAL wsrep_forced_binlog_format='none';
74 connection node_1;
75 SET GLOBAL wsrep_forced_binlog_format='none';
76 drop table t1;
77 SET SESSION binlog_format='STATEMENT';
78 show variables like 'binlog_format';
79 Variable_name Value
80 binlog_format STATEMENT
81 SET GLOBAL wsrep_auto_increment_control='OFF';
82 SET SESSION auto_increment_increment = 3;
83 SET SESSION auto_increment_offset = 1;
84 CREATE TABLE t1 (
85 i int(11) NOT NULL primary key AUTO_INCREMENT,
86 c char(32) DEFAULT 'dummy_text'
87 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
88 show variables like 'auto_increment%';
89 Variable_name Value
90 auto_increment_increment 3
91 auto_increment_offset 1
92 insert into t1(i) values(null);
93 Warnings:
94 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the slave
95 select * from t1 order by i;
96 i c
97 1 dummy_text
98 insert into t1(i) values(null), (null), (null);
99 Warnings:
100 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the slave
101 select * from t1 order by i;
102 i c
103 1 dummy_text
104 4 dummy_text
105 7 dummy_text
106 10 dummy_text
107 connection node_2;
108 show variables like 'auto_increment%';
109 Variable_name Value
110 auto_increment_increment 2
111 auto_increment_offset 2
112 select * from t1 order by i;
113 i c
114 1 dummy_text
115 4 dummy_text
116 7 dummy_text
117 10 dummy_text
118 connection node_1;
119 SET GLOBAL wsrep_auto_increment_control='ON';
120 SET SESSION binlog_format='ROW';
121 connection node_1;
122 show variables like 'binlog_format';
123 Variable_name Value
124 binlog_format ROW
125 show variables like '%auto_increment%';
126 Variable_name Value
127 auto_increment_increment 2
128 auto_increment_offset 1
129 wsrep_auto_increment_control ON
130 SET GLOBAL wsrep_auto_increment_control='OFF';
131 show variables like '%auto_increment%';
132 Variable_name Value
133 auto_increment_increment 3
134 auto_increment_offset 1
135 wsrep_auto_increment_control OFF
136 SET GLOBAL wsrep_auto_increment_control='ON';
137 connection node_1;
138 drop table t1;
139 connection node_2;
140 SET GLOBAL wsrep_forced_binlog_format='ROW';
141 connection node_1;
142 SET GLOBAL wsrep_forced_binlog_format='ROW';
143 CREATE TABLE t1 (
144 i int(11) NOT NULL primary key AUTO_INCREMENT,
145 c char(32) DEFAULT 'dummy_text'
146 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
147 show variables like 'auto_increment%';
148 Variable_name Value
149 auto_increment_increment 2
150 auto_increment_offset 1
151 insert into t1(i) values(null);
152 select * from t1 order by i;
153 i c
154 1 dummy_text
155 insert into t1(i) values(null), (null), (null);
156 select * from t1 order by i;
157 i c
158 1 dummy_text
159 3 dummy_text
160 5 dummy_text
161 7 dummy_text
162 connection node_2;
163 show variables like 'auto_increment%';
164 Variable_name Value
165 auto_increment_increment 2
166 auto_increment_offset 2
167 select * from t1 order by i;
168 i c
169 1 dummy_text
170 3 dummy_text
171 5 dummy_text
172 7 dummy_text
173 SET GLOBAL wsrep_forced_binlog_format='none';
174 connection node_1;
175 SET GLOBAL wsrep_forced_binlog_format='none';
176 drop table t1;
177 SET SESSION binlog_format='ROW';
178 show variables like 'binlog_format';
179 Variable_name Value
180 binlog_format ROW
181 SET GLOBAL wsrep_auto_increment_control='OFF';
182 SET SESSION auto_increment_increment = 3;
183 SET SESSION auto_increment_offset = 1;
184 CREATE TABLE t1 (
185 i int(11) NOT NULL primary key AUTO_INCREMENT,
186 c char(32) DEFAULT 'dummy_text'
187 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
188 show variables like 'auto_increment%';
189 Variable_name Value
190 auto_increment_increment 3
191 auto_increment_offset 1
192 insert into t1(i) values(null);
193 select * from t1 order by i;
194 i c
195 1 dummy_text
196 insert into t1(i) values(null), (null), (null);
197 select * from t1 order by i;
198 i c
199 1 dummy_text
200 4 dummy_text
201 7 dummy_text
202 10 dummy_text
203 connection node_2;
204 show variables like 'auto_increment%';
205 Variable_name Value
206 auto_increment_increment 2
207 auto_increment_offset 2
208 select * from t1 order by i;
209 i c
210 1 dummy_text
211 4 dummy_text
212 7 dummy_text
213 10 dummy_text
214 connection node_1;
215 SET GLOBAL wsrep_auto_increment_control='ON';
216 show variables like 'binlog_format';
217 Variable_name Value
218 binlog_format ROW
219 show variables like '%auto_increment%';
220 Variable_name Value
221 auto_increment_increment 2
222 auto_increment_offset 2
223 wsrep_auto_increment_control ON
224 SET GLOBAL wsrep_auto_increment_control='OFF';
225 show variables like '%auto_increment%';
226 Variable_name Value
227 auto_increment_increment 2
228 auto_increment_offset 2
229 wsrep_auto_increment_control OFF
230 SET GLOBAL wsrep_auto_increment_control='ON';
231 drop table t1;