Debian Codegraph @

mysql-test/suite/ndb_binlog/r/ndb_binlog_variants.result

raw
1 create table ab(a1 int, a2 int, a3 int, a4 int, a5 int, primary key(a2,a5)) engine = ndb;
2 create table ba(ks int primary key, st int, lp int) engine = ndb;
3 create table cpk(nonchar int, charone varchar(100), chartwo varchar(100),
4 other int,
5 primary key (nonchar, charone, chartwo)) engine=ndb;
6 insert into ab values (1,1,1,1,1), (2,2,2,2,2), (3,3,3,3,3), (4,4,4,4,4);
7 update ab set a3=111 where a2=1;
8 update ab set a1=222, a4=222 where a2=2;
9 insert into ba values (1, 1, 1), (2,2,2), (3,3,3), (4,4,4);
10 update ba set lp=40 where ks=4;
11 delete from ba where ks=2;
12 insert into cpk values(1, "ABCD", "WXYZ", 100);
13 insert into cpk values(2, "ABCD", "WXYZ", 100);
14 insert into cpk values(3, "ABCD", "WXYZ", 100);
15 insert into cpk values(4, "ABCD", "WXYZ", 100);
16 insert into cpk values(5, "ABCD", "WXYZ", 100);
17 insert into cpk values(6, "ABCD", "WXYZ", 100);
18 Change one char key
19 update cpk set charone="abcd" where charone="ABCD" and nonchar=1 and chartwo="WXYZ";
20 Change other char key
21 update cpk set chartwo="wxyz" where charone="ABCD" and nonchar=2 and chartwo="WXYZ";
22 Change both char keys
23 update cpk set charone="abcd", chartwo="wxyz" where charone="ABCD" and nonchar=3 and chartwo="WXYZ";
24 Null change
25 update cpk set charone="ABCD", chartwo="WXYZ" where charone="ABCD" and nonchar=4 and chartwo="WXYZ";
26 Null change + data change
27 update cpk set charone="ABCD", chartwo="WXYZ", other=200 where charone="ABCD" and nonchar=5 and chartwo="WXYZ";
28 Change both char keys + data
29 update cpk set charone="abcd", chartwo="wxyz", other=200 where charone="ABCD" and nonchar=6 and chartwo="WXYZ";
30 flush logs;
31 flush logs;
32 flush logs;
33 flush logs;
34 flush logs;
35 flush logs;
36 delete from ba;
37 show variables like 'ndb_log_update%';
38 Variable_name Value
39 ndb_log_update_as_write ON
40 ndb_log_update_minimal OFF
41 ndb_log_updated_only ON
42 select txt from binlog_stmts where txt not like '%ndb_apply_status%' order by txt;
43 txt
44 DELETE FROM `test`.`ba` WHERE @1=2
45 INSERT INTO `test`.`ab` SET @1=1 @2=1 @3=1 @4=1 @5=1
46 INSERT INTO `test`.`ab` SET @1=2 @2=2 @3=2 @4=2 @5=2
47 INSERT INTO `test`.`ab` SET @1=222 @2=2 @4=222 @5=2
48 INSERT INTO `test`.`ab` SET @1=3 @2=3 @3=3 @4=3 @5=3
49 INSERT INTO `test`.`ab` SET @1=4 @2=4 @3=4 @4=4 @5=4
50 INSERT INTO `test`.`ab` SET @2=1 @3=111 @5=1
51 INSERT INTO `test`.`ba` SET @1=1 @2=1 @3=1
52 INSERT INTO `test`.`ba` SET @1=2 @2=2 @3=2
53 INSERT INTO `test`.`ba` SET @1=3 @2=3 @3=3
54 INSERT INTO `test`.`ba` SET @1=4 @2=4 @3=4
55 INSERT INTO `test`.`ba` SET @1=4 @3=40
56 INSERT INTO `test`.`cpk` SET @1=1 @2='ABCD' @3='WXYZ' @4=100
57 INSERT INTO `test`.`cpk` SET @1=1 @2='abcd' @3='WXYZ' @4=100
58 INSERT INTO `test`.`cpk` SET @1=2 @2='ABCD' @3='WXYZ' @4=100
59 INSERT INTO `test`.`cpk` SET @1=2 @2='ABCD' @3='wxyz' @4=100
60 INSERT INTO `test`.`cpk` SET @1=3 @2='ABCD' @3='WXYZ' @4=100
61 INSERT INTO `test`.`cpk` SET @1=3 @2='abcd' @3='wxyz' @4=100
62 INSERT INTO `test`.`cpk` SET @1=4 @2='ABCD' @3='WXYZ' @4=100
63 INSERT INTO `test`.`cpk` SET @1=5 @2='ABCD' @3='WXYZ' @4=100
64 INSERT INTO `test`.`cpk` SET @1=5 @2='ABCD' @3='WXYZ' @4=200
65 INSERT INTO `test`.`cpk` SET @1=6 @2='ABCD' @3='WXYZ' @4=100
66 INSERT INTO `test`.`cpk` SET @1=6 @2='abcd' @3='wxyz' @4=200
67 select * from ab order by a2,a4;
68 a1 a2 a3 a4 a5
69 1 1 111 1 1
70 222 2 2 222 2
71 3 3 3 3 3
72 4 4 4 4 4
73 delete from ab;
74 select * from ba order by ks;
75 ks st lp
76 1 1 1
77 3 3 3
78 4 4 40
79 delete from ba;
80 select * from cpk order by nonchar;
81 nonchar charone chartwo other
82 1 abcd WXYZ 100
83 2 ABCD wxyz 100
84 3 abcd wxyz 100
85 4 ABCD WXYZ 100
86 5 ABCD WXYZ 200
87 6 abcd wxyz 200
88 delete from cpk;
89 show variables like 'ndb_log_update%';
90 Variable_name Value
91 ndb_log_update_as_write ON
92 ndb_log_update_minimal OFF
93 ndb_log_updated_only OFF
94 select txt from binlog_stmts where txt not like '%ndb_apply_status%' order by txt;
95 txt
96 DELETE FROM `test`.`ba` WHERE @1=2 @2=2 @3=2
97 INSERT INTO `test`.`ab` SET @1=1 @2=1 @3=1 @4=1 @5=1
98 INSERT INTO `test`.`ab` SET @1=1 @2=1 @3=111 @4=1 @5=1
99 INSERT INTO `test`.`ab` SET @1=2 @2=2 @3=2 @4=2 @5=2
100 INSERT INTO `test`.`ab` SET @1=222 @2=2 @3=2 @4=222 @5=2
101 INSERT INTO `test`.`ab` SET @1=3 @2=3 @3=3 @4=3 @5=3
102 INSERT INTO `test`.`ab` SET @1=4 @2=4 @3=4 @4=4 @5=4
103 INSERT INTO `test`.`ba` SET @1=1 @2=1 @3=1
104 INSERT INTO `test`.`ba` SET @1=2 @2=2 @3=2
105 INSERT INTO `test`.`ba` SET @1=3 @2=3 @3=3
106 INSERT INTO `test`.`ba` SET @1=4 @2=4 @3=4
107 INSERT INTO `test`.`ba` SET @1=4 @2=4 @3=40
108 INSERT INTO `test`.`cpk` SET @1=1 @2='ABCD' @3='WXYZ' @4=100
109 INSERT INTO `test`.`cpk` SET @1=1 @2='abcd' @3='WXYZ' @4=100
110 INSERT INTO `test`.`cpk` SET @1=2 @2='ABCD' @3='WXYZ' @4=100
111 INSERT INTO `test`.`cpk` SET @1=2 @2='ABCD' @3='wxyz' @4=100
112 INSERT INTO `test`.`cpk` SET @1=3 @2='ABCD' @3='WXYZ' @4=100
113 INSERT INTO `test`.`cpk` SET @1=3 @2='abcd' @3='wxyz' @4=100
114 INSERT INTO `test`.`cpk` SET @1=4 @2='ABCD' @3='WXYZ' @4=100
115 INSERT INTO `test`.`cpk` SET @1=5 @2='ABCD' @3='WXYZ' @4=100
116 INSERT INTO `test`.`cpk` SET @1=5 @2='ABCD' @3='WXYZ' @4=200
117 INSERT INTO `test`.`cpk` SET @1=6 @2='ABCD' @3='WXYZ' @4=100
118 INSERT INTO `test`.`cpk` SET @1=6 @2='abcd' @3='wxyz' @4=200
119 select * from ab order by a2,a4;
120 a1 a2 a3 a4 a5
121 1 1 111 1 1
122 222 2 2 222 2
123 3 3 3 3 3
124 4 4 4 4 4
125 delete from ab;
126 select * from ba order by ks;
127 ks st lp
128 1 1 1
129 3 3 3
130 4 4 40
131 delete from ba;
132 select * from cpk order by nonchar;
133 nonchar charone chartwo other
134 1 abcd WXYZ 100
135 2 ABCD wxyz 100
136 3 abcd wxyz 100
137 4 ABCD WXYZ 100
138 5 ABCD WXYZ 200
139 6 abcd wxyz 200
140 delete from cpk;
141 show variables like 'ndb_log_update%';
142 Variable_name Value
143 ndb_log_update_as_write OFF
144 ndb_log_update_minimal OFF
145 ndb_log_updated_only ON
146 select txt from binlog_stmts where txt not like '%ndb_apply_status%' order by txt;
147 txt
148 DELETE FROM `test`.`ba` WHERE @1=2
149 INSERT INTO `test`.`ab` SET @1=1 @2=1 @3=1 @4=1 @5=1
150 INSERT INTO `test`.`ab` SET @1=2 @2=2 @3=2 @4=2 @5=2
151 INSERT INTO `test`.`ab` SET @1=3 @2=3 @3=3 @4=3 @5=3
152 INSERT INTO `test`.`ab` SET @1=4 @2=4 @3=4 @4=4 @5=4
153 INSERT INTO `test`.`ba` SET @1=1 @2=1 @3=1
154 INSERT INTO `test`.`ba` SET @1=2 @2=2 @3=2
155 INSERT INTO `test`.`ba` SET @1=3 @2=3 @3=3
156 INSERT INTO `test`.`ba` SET @1=4 @2=4 @3=4
157 INSERT INTO `test`.`cpk` SET @1=1 @2='ABCD' @3='WXYZ' @4=100
158 INSERT INTO `test`.`cpk` SET @1=2 @2='ABCD' @3='WXYZ' @4=100
159 INSERT INTO `test`.`cpk` SET @1=3 @2='ABCD' @3='WXYZ' @4=100
160 INSERT INTO `test`.`cpk` SET @1=4 @2='ABCD' @3='WXYZ' @4=100
161 INSERT INTO `test`.`cpk` SET @1=5 @2='ABCD' @3='WXYZ' @4=100
162 INSERT INTO `test`.`cpk` SET @1=6 @2='ABCD' @3='WXYZ' @4=100
163 UPDATE `test`.`ab` WHERE @1=2 @2=2 @4=2 @5=2 SET @1=222 @2=2 @4=222 @5=2
164 UPDATE `test`.`ab` WHERE @2=1 @3=1 @5=1 SET @2=1 @3=111 @5=1
165 UPDATE `test`.`ba` WHERE @1=4 @3=4 SET @1=4 @3=40
166 UPDATE `test`.`cpk` WHERE @1=1 @2='ABCD' @3='WXYZ' @4=100 SET @1=1 @2='abcd' @3='WXYZ' @4=100
167 UPDATE `test`.`cpk` WHERE @1=2 @2='ABCD' @3='WXYZ' @4=100 SET @1=2 @2='ABCD' @3='wxyz' @4=100
168 UPDATE `test`.`cpk` WHERE @1=3 @2='ABCD' @3='WXYZ' @4=100 SET @1=3 @2='abcd' @3='wxyz' @4=100
169 UPDATE `test`.`cpk` WHERE @1=5 @2='ABCD' @3='WXYZ' @4=100 SET @1=5 @2='ABCD' @3='WXYZ' @4=200
170 UPDATE `test`.`cpk` WHERE @1=6 @2='ABCD' @3='WXYZ' @4=100 SET @1=6 @2='abcd' @3='wxyz' @4=200
171 select * from ab order by a2,a4;
172 a1 a2 a3 a4 a5
173 1 1 111 1 1
174 222 2 2 222 2
175 3 3 3 3 3
176 4 4 4 4 4
177 delete from ab;
178 select * from ba order by ks;
179 ks st lp
180 1 1 1
181 3 3 3
182 4 4 40
183 delete from ba;
184 select * from cpk order by nonchar;
185 nonchar charone chartwo other
186 1 abcd WXYZ 100
187 2 ABCD wxyz 100
188 3 abcd wxyz 100
189 4 ABCD WXYZ 100
190 5 ABCD WXYZ 200
191 6 abcd wxyz 200
192 delete from cpk;
193 show variables like 'ndb_log_update%';
194 Variable_name Value
195 ndb_log_update_as_write OFF
196 ndb_log_update_minimal OFF
197 ndb_log_updated_only OFF
198 select txt from binlog_stmts where txt not like '%ndb_apply_status%' order by txt;
199 txt
200 DELETE FROM `test`.`ba` WHERE @1=2 @2=2 @3=2
201 INSERT INTO `test`.`ab` SET @1=1 @2=1 @3=1 @4=1 @5=1
202 INSERT INTO `test`.`ab` SET @1=2 @2=2 @3=2 @4=2 @5=2
203 INSERT INTO `test`.`ab` SET @1=3 @2=3 @3=3 @4=3 @5=3
204 INSERT INTO `test`.`ab` SET @1=4 @2=4 @3=4 @4=4 @5=4
205 INSERT INTO `test`.`ba` SET @1=1 @2=1 @3=1
206 INSERT INTO `test`.`ba` SET @1=2 @2=2 @3=2
207 INSERT INTO `test`.`ba` SET @1=3 @2=3 @3=3
208 INSERT INTO `test`.`ba` SET @1=4 @2=4 @3=4
209 INSERT INTO `test`.`cpk` SET @1=1 @2='ABCD' @3='WXYZ' @4=100
210 INSERT INTO `test`.`cpk` SET @1=2 @2='ABCD' @3='WXYZ' @4=100
211 INSERT INTO `test`.`cpk` SET @1=3 @2='ABCD' @3='WXYZ' @4=100
212 INSERT INTO `test`.`cpk` SET @1=4 @2='ABCD' @3='WXYZ' @4=100
213 INSERT INTO `test`.`cpk` SET @1=5 @2='ABCD' @3='WXYZ' @4=100
214 INSERT INTO `test`.`cpk` SET @1=6 @2='ABCD' @3='WXYZ' @4=100
215 UPDATE `test`.`ab` WHERE @1=1 @2=1 @3=1 @4=1 @5=1 SET @1=1 @2=1 @3=111 @4=1 @5=1
216 UPDATE `test`.`ab` WHERE @1=2 @2=2 @3=2 @4=2 @5=2 SET @1=222 @2=2 @3=2 @4=222 @5=2
217 UPDATE `test`.`ba` WHERE @1=4 @2=4 @3=4 SET @1=4 @2=4 @3=40
218 UPDATE `test`.`cpk` WHERE @1=1 @2='ABCD' @3='WXYZ' @4=100 SET @1=1 @2='abcd' @3='WXYZ' @4=100
219 UPDATE `test`.`cpk` WHERE @1=2 @2='ABCD' @3='WXYZ' @4=100 SET @1=2 @2='ABCD' @3='wxyz' @4=100
220 UPDATE `test`.`cpk` WHERE @1=3 @2='ABCD' @3='WXYZ' @4=100 SET @1=3 @2='abcd' @3='wxyz' @4=100
221 UPDATE `test`.`cpk` WHERE @1=5 @2='ABCD' @3='WXYZ' @4=100 SET @1=5 @2='ABCD' @3='WXYZ' @4=200
222 UPDATE `test`.`cpk` WHERE @1=6 @2='ABCD' @3='WXYZ' @4=100 SET @1=6 @2='abcd' @3='wxyz' @4=200
223 select * from ab order by a2,a4;
224 a1 a2 a3 a4 a5
225 1 1 111 1 1
226 222 2 2 222 2
227 3 3 3 3 3
228 4 4 4 4 4
229 delete from ab;
230 select * from ba order by ks;
231 ks st lp
232 1 1 1
233 3 3 3
234 4 4 40
235 delete from ba;
236 select * from cpk order by nonchar;
237 nonchar charone chartwo other
238 1 abcd WXYZ 100
239 2 ABCD wxyz 100
240 3 abcd wxyz 100
241 4 ABCD WXYZ 100
242 5 ABCD WXYZ 200
243 6 abcd wxyz 200
244 delete from cpk;
245 show variables like 'ndb_log_update%';
246 Variable_name Value
247 ndb_log_update_as_write OFF
248 ndb_log_update_minimal ON
249 ndb_log_updated_only ON
250 select txt from binlog_stmts where txt not like '%ndb_apply_status%' order by txt;
251 txt
252 DELETE FROM `test`.`ba` WHERE @1=2
253 INSERT INTO `test`.`ab` SET @1=1 @2=1 @3=1 @4=1 @5=1
254 INSERT INTO `test`.`ab` SET @1=2 @2=2 @3=2 @4=2 @5=2
255 INSERT INTO `test`.`ab` SET @1=3 @2=3 @3=3 @4=3 @5=3
256 INSERT INTO `test`.`ab` SET @1=4 @2=4 @3=4 @4=4 @5=4
257 INSERT INTO `test`.`ba` SET @1=1 @2=1 @3=1
258 INSERT INTO `test`.`ba` SET @1=2 @2=2 @3=2
259 INSERT INTO `test`.`ba` SET @1=3 @2=3 @3=3
260 INSERT INTO `test`.`ba` SET @1=4 @2=4 @3=4
261 INSERT INTO `test`.`cpk` SET @1=1 @2='ABCD' @3='WXYZ' @4=100
262 INSERT INTO `test`.`cpk` SET @1=2 @2='ABCD' @3='WXYZ' @4=100
263 INSERT INTO `test`.`cpk` SET @1=3 @2='ABCD' @3='WXYZ' @4=100
264 INSERT INTO `test`.`cpk` SET @1=4 @2='ABCD' @3='WXYZ' @4=100
265 INSERT INTO `test`.`cpk` SET @1=5 @2='ABCD' @3='WXYZ' @4=100
266 INSERT INTO `test`.`cpk` SET @1=6 @2='ABCD' @3='WXYZ' @4=100
267 UPDATE `test`.`ab` WHERE @2=1 @5=1 SET @3=111
268 UPDATE `test`.`ab` WHERE @2=2 @5=2 SET @1=222 @4=222
269 UPDATE `test`.`ba` WHERE @1=4 SET @3=40
270 UPDATE `test`.`cpk` WHERE @1=1 @2='ABCD' @3='WXYZ' SET @2='abcd' @3='WXYZ' @4=100
271 UPDATE `test`.`cpk` WHERE @1=2 @2='ABCD' @3='WXYZ' SET @2='ABCD' @3='wxyz' @4=100
272 UPDATE `test`.`cpk` WHERE @1=3 @2='ABCD' @3='WXYZ' SET @2='abcd' @3='wxyz' @4=100
273 UPDATE `test`.`cpk` WHERE @1=5 @2='ABCD' @3='WXYZ' SET @2='ABCD' @3='WXYZ' @4=200
274 UPDATE `test`.`cpk` WHERE @1=6 @2='ABCD' @3='WXYZ' SET @2='abcd' @3='wxyz' @4=200
275 select * from ab order by a2,a4;
276 a1 a2 a3 a4 a5
277 1 1 111 1 1
278 222 2 2 222 2
279 3 3 3 3 3
280 4 4 4 4 4
281 delete from ab;
282 select * from ba order by ks;
283 ks st lp
284 1 1 1
285 3 3 3
286 4 4 40
287 delete from ba;
288 select * from cpk order by nonchar;
289 nonchar charone chartwo other
290 1 abcd WXYZ 100
291 2 ABCD wxyz 100
292 3 abcd wxyz 100
293 4 ABCD WXYZ 100
294 5 ABCD WXYZ 200
295 6 abcd wxyz 200
296 delete from cpk;
297 show variables like 'ndb_log_update%';
298 Variable_name Value
299 ndb_log_update_as_write OFF
300 ndb_log_update_minimal ON
301 ndb_log_updated_only OFF
302 select txt from binlog_stmts where txt not like '%ndb_apply_status%' order by txt;
303 txt
304 DELETE FROM `test`.`ba` WHERE @1=2 @2=2 @3=2
305 INSERT INTO `test`.`ab` SET @1=1 @2=1 @3=1 @4=1 @5=1
306 INSERT INTO `test`.`ab` SET @1=2 @2=2 @3=2 @4=2 @5=2
307 INSERT INTO `test`.`ab` SET @1=3 @2=3 @3=3 @4=3 @5=3
308 INSERT INTO `test`.`ab` SET @1=4 @2=4 @3=4 @4=4 @5=4
309 INSERT INTO `test`.`ba` SET @1=1 @2=1 @3=1
310 INSERT INTO `test`.`ba` SET @1=2 @2=2 @3=2
311 INSERT INTO `test`.`ba` SET @1=3 @2=3 @3=3
312 INSERT INTO `test`.`ba` SET @1=4 @2=4 @3=4
313 INSERT INTO `test`.`cpk` SET @1=1 @2='ABCD' @3='WXYZ' @4=100
314 INSERT INTO `test`.`cpk` SET @1=2 @2='ABCD' @3='WXYZ' @4=100
315 INSERT INTO `test`.`cpk` SET @1=3 @2='ABCD' @3='WXYZ' @4=100
316 INSERT INTO `test`.`cpk` SET @1=4 @2='ABCD' @3='WXYZ' @4=100
317 INSERT INTO `test`.`cpk` SET @1=5 @2='ABCD' @3='WXYZ' @4=100
318 INSERT INTO `test`.`cpk` SET @1=6 @2='ABCD' @3='WXYZ' @4=100
319 UPDATE `test`.`ab` WHERE @2=1 @5=1 SET @1=1 @3=111 @4=1
320 UPDATE `test`.`ab` WHERE @2=2 @5=2 SET @1=222 @3=2 @4=222
321 UPDATE `test`.`ba` WHERE @1=4 SET @2=4 @3=40
322 UPDATE `test`.`cpk` WHERE @1=1 @2='ABCD' @3='WXYZ' SET @2='abcd' @3='WXYZ' @4=100
323 UPDATE `test`.`cpk` WHERE @1=2 @2='ABCD' @3='WXYZ' SET @2='ABCD' @3='wxyz' @4=100
324 UPDATE `test`.`cpk` WHERE @1=3 @2='ABCD' @3='WXYZ' SET @2='abcd' @3='wxyz' @4=100
325 UPDATE `test`.`cpk` WHERE @1=5 @2='ABCD' @3='WXYZ' SET @2='ABCD' @3='WXYZ' @4=200
326 UPDATE `test`.`cpk` WHERE @1=6 @2='ABCD' @3='WXYZ' SET @2='abcd' @3='wxyz' @4=200
327 select * from ab order by a2,a4;
328 a1 a2 a3 a4 a5
329 1 1 111 1 1
330 222 2 2 222 2
331 3 3 3 3 3
332 4 4 4 4 4
333 delete from ab;
334 select * from ba order by ks;
335 ks st lp
336 1 1 1
337 3 3 3
338 4 4 40
339 delete from ba;
340 select * from cpk order by nonchar;
341 nonchar charone chartwo other
342 1 abcd WXYZ 100
343 2 ABCD wxyz 100
344 3 abcd wxyz 100
345 4 ABCD WXYZ 100
346 5 ABCD WXYZ 200
347 6 abcd wxyz 200
348 delete from cpk;
349 drop table ab;
350 drop table ba;
351 drop table cpk;
352 CREATE TABLE mysql.ndb_replication
353 (db VARBINARY(63),
354 table_name VARBINARY(63),
355 server_id INT UNSIGNED,
356 binlog_type INT UNSIGNED,
357 conflict_fn VARBINARY(128),
358 PRIMARY KEY USING HASH (db,table_name,server_id))
359 ENGINE=NDB PARTITION BY KEY(db,table_name);
360 insert into mysql.ndb_replication values("test", "t1", 0, 6, NULL);
361 insert into mysql.ndb_replication values("test", "t2", 0, 7, NULL);
362 insert into mysql.ndb_replication values("test", "t3", 0, 8, NULL);
363 insert into mysql.ndb_replication values("test", "t4", 0, 9, NULL);
364 create table t1(a1 int, a2 int, a3 int, a4 int, a5 int, primary key(a2,a5)) engine=ndb;
365 create table t2(a1 int, a2 int, a3 int, a4 int, a5 int, primary key(a2,a5)) engine=ndb;
366 create table t3(a1 int, a2 int, a3 int, a4 int, a5 int, primary key(a2,a5)) engine=ndb;
367 create table t4(a1 int, a2 int, a3 int, a4 int, a5 int, primary key(a2,a5)) engine=ndb;
368 insert into t1 values (1,1,1,1,1), (2,2,2,2,2), (3,3,3,3,3), (4,4,4,4,4);
369 insert into t2 values (1,1,1,1,1), (2,2,2,2,2), (3,3,3,3,3), (4,4,4,4,4);
370 insert into t3 values (1,1,1,1,1), (2,2,2,2,2), (3,3,3,3,3), (4,4,4,4,4);
371 insert into t4 values (1,1,1,1,1), (2,2,2,2,2), (3,3,3,3,3), (4,4,4,4,4);
372 update t1 set a3=111 where a2=1;
373 update t1 set a1=222, a4=222 where a2=2;
374 update t2 set a3=111 where a2=1;
375 update t2 set a1=222, a4=222 where a2=2;
376 update t3 set a3=111 where a2=1;
377 update t3 set a1=222, a4=222 where a2=2;
378 update t4 set a3=111 where a2=1;
379 update t4 set a1=222, a4=222 where a2=2;
380 flush logs;
381 select txt from binlog_stmts where txt not like '%ndb_apply_status%' order by txt;
382 txt
383 INSERT INTO `test`.`t1` SET @1=1 @2=1 @3=1 @4=1 @5=1
384 INSERT INTO `test`.`t1` SET @1=2 @2=2 @3=2 @4=2 @5=2
385 INSERT INTO `test`.`t1` SET @1=3 @2=3 @3=3 @4=3 @5=3
386 INSERT INTO `test`.`t1` SET @1=4 @2=4 @3=4 @4=4 @5=4
387 INSERT INTO `test`.`t2` SET @1=1 @2=1 @3=1 @4=1 @5=1
388 INSERT INTO `test`.`t2` SET @1=2 @2=2 @3=2 @4=2 @5=2
389 INSERT INTO `test`.`t2` SET @1=3 @2=3 @3=3 @4=3 @5=3
390 INSERT INTO `test`.`t2` SET @1=4 @2=4 @3=4 @4=4 @5=4
391 INSERT INTO `test`.`t3` SET @1=1 @2=1 @3=1 @4=1 @5=1
392 INSERT INTO `test`.`t3` SET @1=2 @2=2 @3=2 @4=2 @5=2
393 INSERT INTO `test`.`t3` SET @1=3 @2=3 @3=3 @4=3 @5=3
394 INSERT INTO `test`.`t3` SET @1=4 @2=4 @3=4 @4=4 @5=4
395 INSERT INTO `test`.`t4` SET @1=1 @2=1 @3=1 @4=1 @5=1
396 INSERT INTO `test`.`t4` SET @1=2 @2=2 @3=2 @4=2 @5=2
397 INSERT INTO `test`.`t4` SET @1=3 @2=3 @3=3 @4=3 @5=3
398 INSERT INTO `test`.`t4` SET @1=4 @2=4 @3=4 @4=4 @5=4
399 UPDATE `test`.`t1` WHERE @1=2 @2=2 @4=2 @5=2 SET @1=222 @2=2 @4=222 @5=2
400 UPDATE `test`.`t1` WHERE @2=1 @3=1 @5=1 SET @2=1 @3=111 @5=1
401 UPDATE `test`.`t2` WHERE @1=1 @2=1 @3=1 @4=1 @5=1 SET @1=1 @2=1 @3=111 @4=1 @5=1
402 UPDATE `test`.`t2` WHERE @1=2 @2=2 @3=2 @4=2 @5=2 SET @1=222 @2=2 @3=2 @4=222 @5=2
403 UPDATE `test`.`t3` WHERE @2=1 @5=1 SET @3=111
404 UPDATE `test`.`t3` WHERE @2=2 @5=2 SET @1=222 @4=222
405 UPDATE `test`.`t4` WHERE @2=1 @5=1 SET @1=1 @3=111 @4=1
406 UPDATE `test`.`t4` WHERE @2=2 @5=2 SET @1=222 @3=2 @4=222
407 delete from t1;
408 delete from t2;
409 delete from t3;
410 delete from t4;
411 select * from t1 order by a2,a5;
412 a1 a2 a3 a4 a5
413 1 1 111 1 1
414 222 2 2 222 2
415 3 3 3 3 3
416 4 4 4 4 4
417 select * from t2 order by a2,a5;
418 a1 a2 a3 a4 a5
419 1 1 111 1 1
420 222 2 2 222 2
421 3 3 3 3 3
422 4 4 4 4 4
423 select * from t3 order by a2,a5;
424 a1 a2 a3 a4 a5
425 1 1 111 1 1
426 222 2 2 222 2
427 3 3 3 3 3
428 4 4 4 4 4
429 select * from t4 order by a2,a5;
430 a1 a2 a3 a4 a5
431 1 1 111 1 1
432 222 2 2 222 2
433 3 3 3 3 3
434 4 4 4 4 4
435 drop table t1, t2, t3, t4;
436 drop table mysql.ndb_replication;
437 reset master;
438 show variables like 'ndb_log_update%';
439 Variable_name Value
440 ndb_log_update_as_write ON
441 ndb_log_update_minimal OFF
442 ndb_log_updated_only ON
443 create table bah (tst int primary key, cvy int, sqs int, unique(sqs)) engine=ndb;
444 insert into bah values (1,1,1);
445 update bah set cvy= 2 where tst=1;
446 select * from bah order by tst;
447 tst cvy sqs
448 1 2 1
449 drop table bah;
450 Manually applying captured binlog
451 select * from bah order by tst;
452 tst cvy sqs
453 1 2 1
454 drop table bah;
455 reset master;
456 show variables like '%log_update%';
457 Variable_name Value
458 ndb_log_update_as_write ON
459 ndb_log_update_minimal OFF
460 ndb_log_updated_only ON
461 CREATE TABLE `t1` (
462 `charId` varchar(60) NOT NULL,
463 `enumId` enum('A','B','C') NOT NULL,
464 `val` bigint(20) NOT NULL,
465 `version` int(11) NOT NULL,
466 PRIMARY KEY (`charId`,`enumId`)
467 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1;
468 Warnings:
469 Warning 1681 Integer display width is deprecated and will be removed in a future release.
470 Warning 1681 Integer display width is deprecated and will be removed in a future release.
471 INSERT INTO t1 VALUES ('', 'A', 0, 1);
472 FLUSH LOGS;
473 UPDATE t1 SET val = val + 1 WHERE charId = '';
474 FLUSH LOGS;
475 DELETE FROM t1 WHERE charId = '';
476 FLUSH LOGS;
477 Manually applying captured binlog
478 select * from t1;
479 charId enumId val version
480 drop table t1;
481 reset master;
482 show variables like '%log_update%';
483 Variable_name Value
484 ndb_log_update_as_write ON
485 ndb_log_update_minimal OFF
486 ndb_log_updated_only ON
487 create table t1 (pk int not null primary key, name varchar(256)) engine = ndb;
488 FLUSH LOGS;
489 insert into t1 values (0, "zero"),(1,"one"),(2,"two"),(3,"three"),(4,"four"),(5,"five"),(6,"six"),(7,"seven"),(8,"eight"),(9,"nine");
490 select * from t1 order by pk;
491 pk name
492 0 zero
493 1 one
494 2 two
495 3 three
496 4 four
497 5 five
498 6 six
499 7 seven
500 8 eight
501 9 nine
502 update t1 set name = "even" where pk in (0,2,4,6,8);
503 update t1 set name = "odd" where pk in (1,3,5,7,9);
504 delete from t1 where name = "odd";
505 select * from t1 order by pk;
506 pk name
507 0 even
508 2 even
509 4 even
510 6 even
511 8 even
512 FLUSH LOGS;
513 truncate t1;
514 insert into t1 values (0, "zero"),(1,"one"),(2,"two"),(3,"three"),(4,"four"),(5,"five"),(6,"six"),(7,"seven"),(8,"eight"),(9,"nine");
515 select * from t1 order by pk;
516 pk name
517 0 zero
518 1 one
519 2 two
520 3 three
521 4 four
522 5 five
523 6 six
524 7 seven
525 8 eight
526 9 nine
527 FLUSH LOGS;
528 Manually applying captured binlog
529 select * from t1 order by pk;
530 pk name
531 0 even
532 2 even
533 4 even
534 6 even
535 8 even
536 drop table t1;