Debian Codegraph @

mysql-test/suite/binlog/r/binlog_row_img.result

raw
1 ALTER DATABASE test CHARACTER SET latin1 COLLATE latin1_swedish_ci;
2 #
3 # FULL_NODUP mode works as expected
4 #
5 SET binlog_row_image = "FULL_NODUP";
6 CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 varchar(100),
7 c3 INT DEFAULT 1000, c4 TEXT);
8 CREATE TABLE t2 (c1 INT, c2 char(100), c3 INT DEFAULT 1000, c4 TEXT);
9 FLUSH BINARY LOGS;
10
11 #########################################################################
12 # binlog_row_image = FULL_NODUP
13 #########################################################################
14
15 INSERT INTO t1 VALUES(1, "insert_to_t1", 1, repeat('a', 20)),
16 (2, "insert_to_t1", 2, repeat('a', 20)),
17 (3, "insert_to_t1", 3, repeat('a', 20));
18 INSERT INTO t1(c1) VALUES(4);
19 UPDATE t1 SET c2 = "only_c2_changed";
20 UPDATE t1 SET c3 = 1, c4 = "c3_c4_changed";
21 DELETE FROM t1 WHERE c1 = 1;
22
23 # Verify that rows events are binlogged as expeced.
24
25 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
26 DELIMITER /*!*/;
27 # Warning: this binlog is either in use or was not closed properly.
28 START TRANSACTION
29 /*!*/;
30 #Q> INSERT INTO t1 VALUES(1, "insert_to_t1", 1, repeat('a', 20)),
31 #Q> (2, "insert_to_t1", 2, repeat('a', 20)),
32 #Q> (3, "insert_to_t1", 3, repeat('a', 20))
33 ### INSERT INTO `test`.`t1`
34 ### SET
35 ### @1=1 /* INT meta=0 nullable=0 is_null=0 */
36 ### @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
37 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
38 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
39 ### INSERT INTO `test`.`t1`
40 ### SET
41 ### @1=2 /* INT meta=0 nullable=0 is_null=0 */
42 ### @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
43 ### @3=2 /* INT meta=0 nullable=1 is_null=0 */
44 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
45 ### INSERT INTO `test`.`t1`
46 ### SET
47 ### @1=3 /* INT meta=0 nullable=0 is_null=0 */
48 ### @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
49 ### @3=3 /* INT meta=0 nullable=1 is_null=0 */
50 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
51 # Number of rows: 3
52 /*!\C latin1 *//*!*/;
53 COMMIT
54 /*!*/;
55 START TRANSACTION
56 /*!*/;
57 #Q> INSERT INTO t1(c1) VALUES(4)
58 ### INSERT INTO `test`.`t1`
59 ### SET
60 ### @1=4 /* INT meta=0 nullable=0 is_null=0 */
61 ### @2=NULL /* VARSTRING(100) meta=100 nullable=1 is_null=1 */
62 ### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
63 ### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
64 # Number of rows: 1
65 COMMIT
66 /*!*/;
67 START TRANSACTION
68 /*!*/;
69 #Q> UPDATE t1 SET c2 = "only_c2_changed"
70 ### UPDATE `test`.`t1`
71 ### WHERE
72 ### @1=1 /* INT meta=0 nullable=0 is_null=0 */
73 ### @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
74 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
75 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
76 ### SET
77 ### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
78 ### UPDATE `test`.`t1`
79 ### WHERE
80 ### @1=2 /* INT meta=0 nullable=0 is_null=0 */
81 ### @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
82 ### @3=2 /* INT meta=0 nullable=1 is_null=0 */
83 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
84 ### SET
85 ### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
86 ### UPDATE `test`.`t1`
87 ### WHERE
88 ### @1=3 /* INT meta=0 nullable=0 is_null=0 */
89 ### @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
90 ### @3=3 /* INT meta=0 nullable=1 is_null=0 */
91 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
92 ### SET
93 ### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
94 ### UPDATE `test`.`t1`
95 ### WHERE
96 ### @1=4 /* INT meta=0 nullable=0 is_null=0 */
97 ### @2=NULL /* VARSTRING(100) meta=100 nullable=1 is_null=1 */
98 ### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
99 ### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
100 ### SET
101 ### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
102 # Number of rows: 4
103 COMMIT
104 /*!*/;
105 START TRANSACTION
106 /*!*/;
107 #Q> UPDATE t1 SET c3 = 1, c4 = "c3_c4_changed"
108 ### UPDATE `test`.`t1`
109 ### WHERE
110 ### @1=1 /* INT meta=0 nullable=0 is_null=0 */
111 ### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
112 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
113 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
114 ### SET
115 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
116 ### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
117 ### UPDATE `test`.`t1`
118 ### WHERE
119 ### @1=2 /* INT meta=0 nullable=0 is_null=0 */
120 ### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
121 ### @3=2 /* INT meta=0 nullable=1 is_null=0 */
122 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
123 ### SET
124 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
125 ### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
126 ### UPDATE `test`.`t1`
127 ### WHERE
128 ### @1=3 /* INT meta=0 nullable=0 is_null=0 */
129 ### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
130 ### @3=3 /* INT meta=0 nullable=1 is_null=0 */
131 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
132 ### SET
133 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
134 ### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
135 ### UPDATE `test`.`t1`
136 ### WHERE
137 ### @1=4 /* INT meta=0 nullable=0 is_null=0 */
138 ### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
139 ### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
140 ### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
141 ### SET
142 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
143 ### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
144 # Number of rows: 4
145 COMMIT
146 /*!*/;
147 START TRANSACTION
148 /*!*/;
149 #Q> DELETE FROM t1 WHERE c1 = 1
150 ### DELETE FROM `test`.`t1`
151 ### WHERE
152 ### @1=1 /* INT meta=0 nullable=0 is_null=0 */
153 ### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
154 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
155 ### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
156 # Number of rows: 1
157 COMMIT
158 /*!*/;
159 DELIMITER ;
160 # End of log file
161 ROLLBACK /* added by mysqlbinlog */;
162 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
163 FLUSH BINARY LOGS;
164
165 # t2 has no primary key.
166 # It will binlog full before and after image for all modes if the
167 # table has no primary key. FULL_NODUP follows the behavior.
168
169 INSERT INTO t2 VALUES(1, "insert_to_t2", 1, repeat('a', 20)),
170 (2, "insert_to_t2", 2, repeat('a', 20)),
171 (3, "insert_to_t2", 3, repeat('a', 20));
172 INSERT INTO t2(c1) VALUES(4);
173 UPDATE t2 SET c2 = "only_c2_changed";
174 UPDATE t2 SET c3 = 1, c4 = "c3_c4_changed";
175 DELETE FROM t2 WHERE c1 > 2;
176
177 # Verify that rows events are binlogged as expeced.
178
179 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
180 DELIMITER /*!*/;
181 # Warning: this binlog is either in use or was not closed properly.
182 START TRANSACTION
183 /*!*/;
184 #Q> INSERT INTO t2 VALUES(1, "insert_to_t2", 1, repeat('a', 20)),
185 #Q> (2, "insert_to_t2", 2, repeat('a', 20)),
186 #Q> (3, "insert_to_t2", 3, repeat('a', 20))
187 ### INSERT INTO `test`.`t2`
188 ### SET
189 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
190 ### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
191 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
192 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
193 ### INSERT INTO `test`.`t2`
194 ### SET
195 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
196 ### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
197 ### @3=2 /* INT meta=0 nullable=1 is_null=0 */
198 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
199 ### INSERT INTO `test`.`t2`
200 ### SET
201 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
202 ### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
203 ### @3=3 /* INT meta=0 nullable=1 is_null=0 */
204 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
205 # Number of rows: 3
206 /*!\C latin1 *//*!*/;
207 COMMIT
208 /*!*/;
209 START TRANSACTION
210 /*!*/;
211 #Q> INSERT INTO t2(c1) VALUES(4)
212 ### INSERT INTO `test`.`t2`
213 ### SET
214 ### @1=4 /* INT meta=0 nullable=1 is_null=0 */
215 ### @2=NULL /* STRING(100) meta=65124 nullable=1 is_null=1 */
216 ### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
217 ### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
218 # Number of rows: 1
219 COMMIT
220 /*!*/;
221 START TRANSACTION
222 /*!*/;
223 #Q> UPDATE t2 SET c2 = "only_c2_changed"
224 ### UPDATE `test`.`t2`
225 ### WHERE
226 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
227 ### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
228 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
229 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
230 ### SET
231 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
232 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
233 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
234 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
235 ### UPDATE `test`.`t2`
236 ### WHERE
237 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
238 ### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
239 ### @3=2 /* INT meta=0 nullable=1 is_null=0 */
240 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
241 ### SET
242 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
243 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
244 ### @3=2 /* INT meta=0 nullable=1 is_null=0 */
245 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
246 ### UPDATE `test`.`t2`
247 ### WHERE
248 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
249 ### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
250 ### @3=3 /* INT meta=0 nullable=1 is_null=0 */
251 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
252 ### SET
253 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
254 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
255 ### @3=3 /* INT meta=0 nullable=1 is_null=0 */
256 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
257 ### UPDATE `test`.`t2`
258 ### WHERE
259 ### @1=4 /* INT meta=0 nullable=1 is_null=0 */
260 ### @2=NULL /* STRING(100) meta=65124 nullable=1 is_null=1 */
261 ### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
262 ### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
263 ### SET
264 ### @1=4 /* INT meta=0 nullable=1 is_null=0 */
265 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
266 ### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
267 ### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
268 # Number of rows: 4
269 COMMIT
270 /*!*/;
271 START TRANSACTION
272 /*!*/;
273 #Q> UPDATE t2 SET c3 = 1, c4 = "c3_c4_changed"
274 ### UPDATE `test`.`t2`
275 ### WHERE
276 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
277 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
278 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
279 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
280 ### SET
281 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
282 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
283 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
284 ### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
285 ### UPDATE `test`.`t2`
286 ### WHERE
287 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
288 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
289 ### @3=2 /* INT meta=0 nullable=1 is_null=0 */
290 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
291 ### SET
292 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
293 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
294 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
295 ### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
296 ### UPDATE `test`.`t2`
297 ### WHERE
298 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
299 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
300 ### @3=3 /* INT meta=0 nullable=1 is_null=0 */
301 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
302 ### SET
303 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
304 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
305 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
306 ### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
307 ### UPDATE `test`.`t2`
308 ### WHERE
309 ### @1=4 /* INT meta=0 nullable=1 is_null=0 */
310 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
311 ### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
312 ### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
313 ### SET
314 ### @1=4 /* INT meta=0 nullable=1 is_null=0 */
315 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
316 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
317 ### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
318 # Number of rows: 4
319 COMMIT
320 /*!*/;
321 START TRANSACTION
322 /*!*/;
323 #Q> DELETE FROM t2 WHERE c1 > 2
324 ### DELETE FROM `test`.`t2`
325 ### WHERE
326 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
327 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
328 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
329 ### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
330 ### DELETE FROM `test`.`t2`
331 ### WHERE
332 ### @1=4 /* INT meta=0 nullable=1 is_null=0 */
333 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
334 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
335 ### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
336 # Number of rows: 2
337 COMMIT
338 /*!*/;
339 DELIMITER ;
340 # End of log file
341 ROLLBACK /* added by mysqlbinlog */;
342 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
343 DROP TABLE t1, t2;
344 #
345 # MINIMAL mode works as expected
346 #
347 SET binlog_row_image = "MINIMAL";
348 CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 varchar(100),
349 c3 INT DEFAULT 1000, c4 TEXT);
350 CREATE TABLE t2 (c1 INT, c2 char(100), c3 INT DEFAULT 1000, c4 TEXT);
351 FLUSH BINARY LOGS;
352
353 #########################################################################
354 # binlog_row_image = MINIMAL
355 #########################################################################
356
357 INSERT INTO t1 VALUES(1, "insert_to_t1", 1, repeat('a', 20)),
358 (2, "insert_to_t1", 2, repeat('a', 20)),
359 (3, "insert_to_t1", 3, repeat('a', 20));
360 INSERT INTO t1(c1) VALUES(4);
361 UPDATE t1 SET c2 = "only_c2_changed";
362 UPDATE t1 SET c3 = 1, c4 = "c3_c4_changed";
363 DELETE FROM t1 WHERE c1 = 1;
364
365 # Verify that rows events are binlogged as expeced.
366
367 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
368 DELIMITER /*!*/;
369 # Warning: this binlog is either in use or was not closed properly.
370 START TRANSACTION
371 /*!*/;
372 #Q> INSERT INTO t1 VALUES(1, "insert_to_t1", 1, repeat('a', 20)),
373 #Q> (2, "insert_to_t1", 2, repeat('a', 20)),
374 #Q> (3, "insert_to_t1", 3, repeat('a', 20))
375 ### INSERT INTO `test`.`t1`
376 ### SET
377 ### @1=1 /* INT meta=0 nullable=0 is_null=0 */
378 ### @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
379 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
380 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
381 ### INSERT INTO `test`.`t1`
382 ### SET
383 ### @1=2 /* INT meta=0 nullable=0 is_null=0 */
384 ### @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
385 ### @3=2 /* INT meta=0 nullable=1 is_null=0 */
386 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
387 ### INSERT INTO `test`.`t1`
388 ### SET
389 ### @1=3 /* INT meta=0 nullable=0 is_null=0 */
390 ### @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
391 ### @3=3 /* INT meta=0 nullable=1 is_null=0 */
392 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
393 # Number of rows: 3
394 /*!\C latin1 *//*!*/;
395 COMMIT
396 /*!*/;
397 START TRANSACTION
398 /*!*/;
399 #Q> INSERT INTO t1(c1) VALUES(4)
400 ### INSERT INTO `test`.`t1`
401 ### SET
402 ### @1=4 /* INT meta=0 nullable=0 is_null=0 */
403 # Number of rows: 1
404 COMMIT
405 /*!*/;
406 START TRANSACTION
407 /*!*/;
408 #Q> UPDATE t1 SET c2 = "only_c2_changed"
409 ### UPDATE `test`.`t1`
410 ### WHERE
411 ### @1=1 /* INT meta=0 nullable=0 is_null=0 */
412 ### SET
413 ### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
414 ### UPDATE `test`.`t1`
415 ### WHERE
416 ### @1=2 /* INT meta=0 nullable=0 is_null=0 */
417 ### SET
418 ### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
419 ### UPDATE `test`.`t1`
420 ### WHERE
421 ### @1=3 /* INT meta=0 nullable=0 is_null=0 */
422 ### SET
423 ### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
424 ### UPDATE `test`.`t1`
425 ### WHERE
426 ### @1=4 /* INT meta=0 nullable=0 is_null=0 */
427 ### SET
428 ### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
429 # Number of rows: 4
430 COMMIT
431 /*!*/;
432 START TRANSACTION
433 /*!*/;
434 #Q> UPDATE t1 SET c3 = 1, c4 = "c3_c4_changed"
435 ### UPDATE `test`.`t1`
436 ### WHERE
437 ### @1=1 /* INT meta=0 nullable=0 is_null=0 */
438 ### SET
439 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
440 ### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
441 ### UPDATE `test`.`t1`
442 ### WHERE
443 ### @1=2 /* INT meta=0 nullable=0 is_null=0 */
444 ### SET
445 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
446 ### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
447 ### UPDATE `test`.`t1`
448 ### WHERE
449 ### @1=3 /* INT meta=0 nullable=0 is_null=0 */
450 ### SET
451 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
452 ### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
453 ### UPDATE `test`.`t1`
454 ### WHERE
455 ### @1=4 /* INT meta=0 nullable=0 is_null=0 */
456 ### SET
457 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
458 ### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
459 # Number of rows: 4
460 COMMIT
461 /*!*/;
462 START TRANSACTION
463 /*!*/;
464 #Q> DELETE FROM t1 WHERE c1 = 1
465 ### DELETE FROM `test`.`t1`
466 ### WHERE
467 ### @1=1 /* INT meta=0 nullable=0 is_null=0 */
468 # Number of rows: 1
469 COMMIT
470 /*!*/;
471 DELIMITER ;
472 # End of log file
473 ROLLBACK /* added by mysqlbinlog */;
474 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
475 FLUSH BINARY LOGS;
476
477 # t2 has no primary key.
478 # It will binlog full before and after image for all modes if the
479 # table has no primary key. FULL_NODUP follows the behavior.
480
481 INSERT INTO t2 VALUES(1, "insert_to_t2", 1, repeat('a', 20)),
482 (2, "insert_to_t2", 2, repeat('a', 20)),
483 (3, "insert_to_t2", 3, repeat('a', 20));
484 INSERT INTO t2(c1) VALUES(4);
485 UPDATE t2 SET c2 = "only_c2_changed";
486 UPDATE t2 SET c3 = 1, c4 = "c3_c4_changed";
487 DELETE FROM t2 WHERE c1 > 2;
488
489 # Verify that rows events are binlogged as expeced.
490
491 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
492 DELIMITER /*!*/;
493 # Warning: this binlog is either in use or was not closed properly.
494 START TRANSACTION
495 /*!*/;
496 #Q> INSERT INTO t2 VALUES(1, "insert_to_t2", 1, repeat('a', 20)),
497 #Q> (2, "insert_to_t2", 2, repeat('a', 20)),
498 #Q> (3, "insert_to_t2", 3, repeat('a', 20))
499 ### INSERT INTO `test`.`t2`
500 ### SET
501 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
502 ### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
503 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
504 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
505 ### INSERT INTO `test`.`t2`
506 ### SET
507 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
508 ### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
509 ### @3=2 /* INT meta=0 nullable=1 is_null=0 */
510 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
511 ### INSERT INTO `test`.`t2`
512 ### SET
513 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
514 ### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
515 ### @3=3 /* INT meta=0 nullable=1 is_null=0 */
516 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
517 # Number of rows: 3
518 /*!\C latin1 *//*!*/;
519 COMMIT
520 /*!*/;
521 START TRANSACTION
522 /*!*/;
523 #Q> INSERT INTO t2(c1) VALUES(4)
524 ### INSERT INTO `test`.`t2`
525 ### SET
526 ### @1=4 /* INT meta=0 nullable=1 is_null=0 */
527 ### @2=NULL /* STRING(100) meta=65124 nullable=1 is_null=1 */
528 ### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
529 ### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
530 # Number of rows: 1
531 COMMIT
532 /*!*/;
533 START TRANSACTION
534 /*!*/;
535 #Q> UPDATE t2 SET c2 = "only_c2_changed"
536 ### UPDATE `test`.`t2`
537 ### WHERE
538 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
539 ### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
540 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
541 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
542 ### SET
543 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
544 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
545 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
546 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
547 ### UPDATE `test`.`t2`
548 ### WHERE
549 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
550 ### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
551 ### @3=2 /* INT meta=0 nullable=1 is_null=0 */
552 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
553 ### SET
554 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
555 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
556 ### @3=2 /* INT meta=0 nullable=1 is_null=0 */
557 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
558 ### UPDATE `test`.`t2`
559 ### WHERE
560 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
561 ### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
562 ### @3=3 /* INT meta=0 nullable=1 is_null=0 */
563 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
564 ### SET
565 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
566 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
567 ### @3=3 /* INT meta=0 nullable=1 is_null=0 */
568 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
569 ### UPDATE `test`.`t2`
570 ### WHERE
571 ### @1=4 /* INT meta=0 nullable=1 is_null=0 */
572 ### @2=NULL /* STRING(100) meta=65124 nullable=1 is_null=1 */
573 ### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
574 ### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
575 ### SET
576 ### @1=4 /* INT meta=0 nullable=1 is_null=0 */
577 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
578 ### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
579 ### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
580 # Number of rows: 4
581 COMMIT
582 /*!*/;
583 START TRANSACTION
584 /*!*/;
585 #Q> UPDATE t2 SET c3 = 1, c4 = "c3_c4_changed"
586 ### UPDATE `test`.`t2`
587 ### WHERE
588 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
589 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
590 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
591 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
592 ### SET
593 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
594 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
595 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
596 ### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
597 ### UPDATE `test`.`t2`
598 ### WHERE
599 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
600 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
601 ### @3=2 /* INT meta=0 nullable=1 is_null=0 */
602 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
603 ### SET
604 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
605 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
606 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
607 ### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
608 ### UPDATE `test`.`t2`
609 ### WHERE
610 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
611 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
612 ### @3=3 /* INT meta=0 nullable=1 is_null=0 */
613 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
614 ### SET
615 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
616 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
617 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
618 ### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
619 ### UPDATE `test`.`t2`
620 ### WHERE
621 ### @1=4 /* INT meta=0 nullable=1 is_null=0 */
622 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
623 ### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
624 ### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
625 ### SET
626 ### @1=4 /* INT meta=0 nullable=1 is_null=0 */
627 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
628 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
629 ### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
630 # Number of rows: 4
631 COMMIT
632 /*!*/;
633 START TRANSACTION
634 /*!*/;
635 #Q> DELETE FROM t2 WHERE c1 > 2
636 ### DELETE FROM `test`.`t2`
637 ### WHERE
638 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
639 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
640 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
641 ### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
642 ### DELETE FROM `test`.`t2`
643 ### WHERE
644 ### @1=4 /* INT meta=0 nullable=1 is_null=0 */
645 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
646 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
647 ### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
648 # Number of rows: 2
649 COMMIT
650 /*!*/;
651 DELIMITER ;
652 # End of log file
653 ROLLBACK /* added by mysqlbinlog */;
654 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
655 DROP TABLE t1, t2;
656 #
657 # NOBLOB mode works as expected
658 #
659 SET binlog_row_image = "NOBLOB";
660 CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 varchar(100),
661 c3 INT DEFAULT 1000, c4 TEXT);
662 CREATE TABLE t2 (c1 INT, c2 char(100), c3 INT DEFAULT 1000, c4 TEXT);
663 FLUSH BINARY LOGS;
664
665 #########################################################################
666 # binlog_row_image = NOBLOB
667 #########################################################################
668
669 INSERT INTO t1 VALUES(1, "insert_to_t1", 1, repeat('a', 20)),
670 (2, "insert_to_t1", 2, repeat('a', 20)),
671 (3, "insert_to_t1", 3, repeat('a', 20));
672 INSERT INTO t1(c1) VALUES(4);
673 UPDATE t1 SET c2 = "only_c2_changed";
674 UPDATE t1 SET c3 = 1, c4 = "c3_c4_changed";
675 DELETE FROM t1 WHERE c1 = 1;
676
677 # Verify that rows events are binlogged as expeced.
678
679 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
680 DELIMITER /*!*/;
681 # Warning: this binlog is either in use or was not closed properly.
682 START TRANSACTION
683 /*!*/;
684 #Q> INSERT INTO t1 VALUES(1, "insert_to_t1", 1, repeat('a', 20)),
685 #Q> (2, "insert_to_t1", 2, repeat('a', 20)),
686 #Q> (3, "insert_to_t1", 3, repeat('a', 20))
687 ### INSERT INTO `test`.`t1`
688 ### SET
689 ### @1=1 /* INT meta=0 nullable=0 is_null=0 */
690 ### @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
691 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
692 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
693 ### INSERT INTO `test`.`t1`
694 ### SET
695 ### @1=2 /* INT meta=0 nullable=0 is_null=0 */
696 ### @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
697 ### @3=2 /* INT meta=0 nullable=1 is_null=0 */
698 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
699 ### INSERT INTO `test`.`t1`
700 ### SET
701 ### @1=3 /* INT meta=0 nullable=0 is_null=0 */
702 ### @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
703 ### @3=3 /* INT meta=0 nullable=1 is_null=0 */
704 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
705 # Number of rows: 3
706 /*!\C latin1 *//*!*/;
707 COMMIT
708 /*!*/;
709 START TRANSACTION
710 /*!*/;
711 #Q> INSERT INTO t1(c1) VALUES(4)
712 ### INSERT INTO `test`.`t1`
713 ### SET
714 ### @1=4 /* INT meta=0 nullable=0 is_null=0 */
715 ### @2=NULL /* VARSTRING(100) meta=100 nullable=1 is_null=1 */
716 ### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
717 # Number of rows: 1
718 COMMIT
719 /*!*/;
720 START TRANSACTION
721 /*!*/;
722 #Q> UPDATE t1 SET c2 = "only_c2_changed"
723 ### UPDATE `test`.`t1`
724 ### WHERE
725 ### @1=1 /* INT meta=0 nullable=0 is_null=0 */
726 ### @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
727 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
728 ### SET
729 ### @1=1 /* INT meta=0 nullable=0 is_null=0 */
730 ### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
731 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
732 ### UPDATE `test`.`t1`
733 ### WHERE
734 ### @1=2 /* INT meta=0 nullable=0 is_null=0 */
735 ### @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
736 ### @3=2 /* INT meta=0 nullable=1 is_null=0 */
737 ### SET
738 ### @1=2 /* INT meta=0 nullable=0 is_null=0 */
739 ### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
740 ### @3=2 /* INT meta=0 nullable=1 is_null=0 */
741 ### UPDATE `test`.`t1`
742 ### WHERE
743 ### @1=3 /* INT meta=0 nullable=0 is_null=0 */
744 ### @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
745 ### @3=3 /* INT meta=0 nullable=1 is_null=0 */
746 ### SET
747 ### @1=3 /* INT meta=0 nullable=0 is_null=0 */
748 ### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
749 ### @3=3 /* INT meta=0 nullable=1 is_null=0 */
750 ### UPDATE `test`.`t1`
751 ### WHERE
752 ### @1=4 /* INT meta=0 nullable=0 is_null=0 */
753 ### @2=NULL /* VARSTRING(100) meta=100 nullable=1 is_null=1 */
754 ### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
755 ### SET
756 ### @1=4 /* INT meta=0 nullable=0 is_null=0 */
757 ### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
758 ### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
759 # Number of rows: 4
760 COMMIT
761 /*!*/;
762 START TRANSACTION
763 /*!*/;
764 #Q> UPDATE t1 SET c3 = 1, c4 = "c3_c4_changed"
765 ### UPDATE `test`.`t1`
766 ### WHERE
767 ### @1=1 /* INT meta=0 nullable=0 is_null=0 */
768 ### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
769 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
770 ### SET
771 ### @1=1 /* INT meta=0 nullable=0 is_null=0 */
772 ### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
773 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
774 ### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
775 ### UPDATE `test`.`t1`
776 ### WHERE
777 ### @1=2 /* INT meta=0 nullable=0 is_null=0 */
778 ### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
779 ### @3=2 /* INT meta=0 nullable=1 is_null=0 */
780 ### SET
781 ### @1=2 /* INT meta=0 nullable=0 is_null=0 */
782 ### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
783 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
784 ### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
785 ### UPDATE `test`.`t1`
786 ### WHERE
787 ### @1=3 /* INT meta=0 nullable=0 is_null=0 */
788 ### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
789 ### @3=3 /* INT meta=0 nullable=1 is_null=0 */
790 ### SET
791 ### @1=3 /* INT meta=0 nullable=0 is_null=0 */
792 ### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
793 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
794 ### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
795 ### UPDATE `test`.`t1`
796 ### WHERE
797 ### @1=4 /* INT meta=0 nullable=0 is_null=0 */
798 ### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
799 ### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
800 ### SET
801 ### @1=4 /* INT meta=0 nullable=0 is_null=0 */
802 ### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
803 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
804 ### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
805 # Number of rows: 4
806 COMMIT
807 /*!*/;
808 START TRANSACTION
809 /*!*/;
810 #Q> DELETE FROM t1 WHERE c1 = 1
811 ### DELETE FROM `test`.`t1`
812 ### WHERE
813 ### @1=1 /* INT meta=0 nullable=0 is_null=0 */
814 ### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
815 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
816 # Number of rows: 1
817 COMMIT
818 /*!*/;
819 DELIMITER ;
820 # End of log file
821 ROLLBACK /* added by mysqlbinlog */;
822 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
823 FLUSH BINARY LOGS;
824
825 # t2 has no primary key.
826 # It will binlog full before and after image for all modes if the
827 # table has no primary key. FULL_NODUP follows the behavior.
828
829 INSERT INTO t2 VALUES(1, "insert_to_t2", 1, repeat('a', 20)),
830 (2, "insert_to_t2", 2, repeat('a', 20)),
831 (3, "insert_to_t2", 3, repeat('a', 20));
832 INSERT INTO t2(c1) VALUES(4);
833 UPDATE t2 SET c2 = "only_c2_changed";
834 UPDATE t2 SET c3 = 1, c4 = "c3_c4_changed";
835 DELETE FROM t2 WHERE c1 > 2;
836
837 # Verify that rows events are binlogged as expeced.
838
839 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
840 DELIMITER /*!*/;
841 # Warning: this binlog is either in use or was not closed properly.
842 START TRANSACTION
843 /*!*/;
844 #Q> INSERT INTO t2 VALUES(1, "insert_to_t2", 1, repeat('a', 20)),
845 #Q> (2, "insert_to_t2", 2, repeat('a', 20)),
846 #Q> (3, "insert_to_t2", 3, repeat('a', 20))
847 ### INSERT INTO `test`.`t2`
848 ### SET
849 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
850 ### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
851 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
852 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
853 ### INSERT INTO `test`.`t2`
854 ### SET
855 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
856 ### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
857 ### @3=2 /* INT meta=0 nullable=1 is_null=0 */
858 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
859 ### INSERT INTO `test`.`t2`
860 ### SET
861 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
862 ### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
863 ### @3=3 /* INT meta=0 nullable=1 is_null=0 */
864 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
865 # Number of rows: 3
866 /*!\C latin1 *//*!*/;
867 COMMIT
868 /*!*/;
869 START TRANSACTION
870 /*!*/;
871 #Q> INSERT INTO t2(c1) VALUES(4)
872 ### INSERT INTO `test`.`t2`
873 ### SET
874 ### @1=4 /* INT meta=0 nullable=1 is_null=0 */
875 ### @2=NULL /* STRING(100) meta=65124 nullable=1 is_null=1 */
876 ### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
877 ### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
878 # Number of rows: 1
879 COMMIT
880 /*!*/;
881 START TRANSACTION
882 /*!*/;
883 #Q> UPDATE t2 SET c2 = "only_c2_changed"
884 ### UPDATE `test`.`t2`
885 ### WHERE
886 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
887 ### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
888 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
889 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
890 ### SET
891 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
892 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
893 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
894 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
895 ### UPDATE `test`.`t2`
896 ### WHERE
897 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
898 ### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
899 ### @3=2 /* INT meta=0 nullable=1 is_null=0 */
900 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
901 ### SET
902 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
903 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
904 ### @3=2 /* INT meta=0 nullable=1 is_null=0 */
905 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
906 ### UPDATE `test`.`t2`
907 ### WHERE
908 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
909 ### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
910 ### @3=3 /* INT meta=0 nullable=1 is_null=0 */
911 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
912 ### SET
913 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
914 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
915 ### @3=3 /* INT meta=0 nullable=1 is_null=0 */
916 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
917 ### UPDATE `test`.`t2`
918 ### WHERE
919 ### @1=4 /* INT meta=0 nullable=1 is_null=0 */
920 ### @2=NULL /* STRING(100) meta=65124 nullable=1 is_null=1 */
921 ### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
922 ### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
923 ### SET
924 ### @1=4 /* INT meta=0 nullable=1 is_null=0 */
925 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
926 ### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
927 ### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
928 # Number of rows: 4
929 COMMIT
930 /*!*/;
931 START TRANSACTION
932 /*!*/;
933 #Q> UPDATE t2 SET c3 = 1, c4 = "c3_c4_changed"
934 ### UPDATE `test`.`t2`
935 ### WHERE
936 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
937 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
938 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
939 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
940 ### SET
941 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
942 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
943 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
944 ### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
945 ### UPDATE `test`.`t2`
946 ### WHERE
947 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
948 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
949 ### @3=2 /* INT meta=0 nullable=1 is_null=0 */
950 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
951 ### SET
952 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
953 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
954 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
955 ### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
956 ### UPDATE `test`.`t2`
957 ### WHERE
958 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
959 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
960 ### @3=3 /* INT meta=0 nullable=1 is_null=0 */
961 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
962 ### SET
963 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
964 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
965 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
966 ### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
967 ### UPDATE `test`.`t2`
968 ### WHERE
969 ### @1=4 /* INT meta=0 nullable=1 is_null=0 */
970 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
971 ### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
972 ### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
973 ### SET
974 ### @1=4 /* INT meta=0 nullable=1 is_null=0 */
975 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
976 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
977 ### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
978 # Number of rows: 4
979 COMMIT
980 /*!*/;
981 START TRANSACTION
982 /*!*/;
983 #Q> DELETE FROM t2 WHERE c1 > 2
984 ### DELETE FROM `test`.`t2`
985 ### WHERE
986 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
987 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
988 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
989 ### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
990 ### DELETE FROM `test`.`t2`
991 ### WHERE
992 ### @1=4 /* INT meta=0 nullable=1 is_null=0 */
993 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
994 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
995 ### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
996 # Number of rows: 2
997 COMMIT
998 /*!*/;
999 DELIMITER ;
1000 # End of log file
1001 ROLLBACK /* added by mysqlbinlog */;
1002 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
1003 DROP TABLE t1, t2;
1004 #
1005 # FULL mode works as expected
1006 #
1007 SET binlog_row_image = "FULL";
1008 CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 varchar(100),
1009 c3 INT DEFAULT 1000, c4 TEXT);
1010 CREATE TABLE t2 (c1 INT, c2 char(100), c3 INT DEFAULT 1000, c4 TEXT);
1011 FLUSH BINARY LOGS;
1012
1013 #########################################################################
1014 # binlog_row_image = FULL
1015 #########################################################################
1016
1017 INSERT INTO t1 VALUES(1, "insert_to_t1", 1, repeat('a', 20)),
1018 (2, "insert_to_t1", 2, repeat('a', 20)),
1019 (3, "insert_to_t1", 3, repeat('a', 20));
1020 INSERT INTO t1(c1) VALUES(4);
1021 UPDATE t1 SET c2 = "only_c2_changed";
1022 UPDATE t1 SET c3 = 1, c4 = "c3_c4_changed";
1023 DELETE FROM t1 WHERE c1 = 1;
1024
1025 # Verify that rows events are binlogged as expeced.
1026
1027 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
1028 DELIMITER /*!*/;
1029 # Warning: this binlog is either in use or was not closed properly.
1030 START TRANSACTION
1031 /*!*/;
1032 #Q> INSERT INTO t1 VALUES(1, "insert_to_t1", 1, repeat('a', 20)),
1033 #Q> (2, "insert_to_t1", 2, repeat('a', 20)),
1034 #Q> (3, "insert_to_t1", 3, repeat('a', 20))
1035 ### INSERT INTO `test`.`t1`
1036 ### SET
1037 ### @1=1 /* INT meta=0 nullable=0 is_null=0 */
1038 ### @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
1039 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
1040 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
1041 ### INSERT INTO `test`.`t1`
1042 ### SET
1043 ### @1=2 /* INT meta=0 nullable=0 is_null=0 */
1044 ### @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
1045 ### @3=2 /* INT meta=0 nullable=1 is_null=0 */
1046 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
1047 ### INSERT INTO `test`.`t1`
1048 ### SET
1049 ### @1=3 /* INT meta=0 nullable=0 is_null=0 */
1050 ### @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
1051 ### @3=3 /* INT meta=0 nullable=1 is_null=0 */
1052 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
1053 # Number of rows: 3
1054 /*!\C latin1 *//*!*/;
1055 COMMIT
1056 /*!*/;
1057 START TRANSACTION
1058 /*!*/;
1059 #Q> INSERT INTO t1(c1) VALUES(4)
1060 ### INSERT INTO `test`.`t1`
1061 ### SET
1062 ### @1=4 /* INT meta=0 nullable=0 is_null=0 */
1063 ### @2=NULL /* VARSTRING(100) meta=100 nullable=1 is_null=1 */
1064 ### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
1065 ### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
1066 # Number of rows: 1
1067 COMMIT
1068 /*!*/;
1069 START TRANSACTION
1070 /*!*/;
1071 #Q> UPDATE t1 SET c2 = "only_c2_changed"
1072 ### UPDATE `test`.`t1`
1073 ### WHERE
1074 ### @1=1 /* INT meta=0 nullable=0 is_null=0 */
1075 ### @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
1076 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
1077 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
1078 ### SET
1079 ### @1=1 /* INT meta=0 nullable=0 is_null=0 */
1080 ### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
1081 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
1082 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
1083 ### UPDATE `test`.`t1`
1084 ### WHERE
1085 ### @1=2 /* INT meta=0 nullable=0 is_null=0 */
1086 ### @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
1087 ### @3=2 /* INT meta=0 nullable=1 is_null=0 */
1088 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
1089 ### SET
1090 ### @1=2 /* INT meta=0 nullable=0 is_null=0 */
1091 ### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
1092 ### @3=2 /* INT meta=0 nullable=1 is_null=0 */
1093 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
1094 ### UPDATE `test`.`t1`
1095 ### WHERE
1096 ### @1=3 /* INT meta=0 nullable=0 is_null=0 */
1097 ### @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
1098 ### @3=3 /* INT meta=0 nullable=1 is_null=0 */
1099 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
1100 ### SET
1101 ### @1=3 /* INT meta=0 nullable=0 is_null=0 */
1102 ### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
1103 ### @3=3 /* INT meta=0 nullable=1 is_null=0 */
1104 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
1105 ### UPDATE `test`.`t1`
1106 ### WHERE
1107 ### @1=4 /* INT meta=0 nullable=0 is_null=0 */
1108 ### @2=NULL /* VARSTRING(100) meta=100 nullable=1 is_null=1 */
1109 ### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
1110 ### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
1111 ### SET
1112 ### @1=4 /* INT meta=0 nullable=0 is_null=0 */
1113 ### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
1114 ### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
1115 ### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
1116 # Number of rows: 4
1117 COMMIT
1118 /*!*/;
1119 START TRANSACTION
1120 /*!*/;
1121 #Q> UPDATE t1 SET c3 = 1, c4 = "c3_c4_changed"
1122 ### UPDATE `test`.`t1`
1123 ### WHERE
1124 ### @1=1 /* INT meta=0 nullable=0 is_null=0 */
1125 ### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
1126 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
1127 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
1128 ### SET
1129 ### @1=1 /* INT meta=0 nullable=0 is_null=0 */
1130 ### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
1131 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
1132 ### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
1133 ### UPDATE `test`.`t1`
1134 ### WHERE
1135 ### @1=2 /* INT meta=0 nullable=0 is_null=0 */
1136 ### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
1137 ### @3=2 /* INT meta=0 nullable=1 is_null=0 */
1138 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
1139 ### SET
1140 ### @1=2 /* INT meta=0 nullable=0 is_null=0 */
1141 ### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
1142 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
1143 ### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
1144 ### UPDATE `test`.`t1`
1145 ### WHERE
1146 ### @1=3 /* INT meta=0 nullable=0 is_null=0 */
1147 ### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
1148 ### @3=3 /* INT meta=0 nullable=1 is_null=0 */
1149 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
1150 ### SET
1151 ### @1=3 /* INT meta=0 nullable=0 is_null=0 */
1152 ### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
1153 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
1154 ### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
1155 ### UPDATE `test`.`t1`
1156 ### WHERE
1157 ### @1=4 /* INT meta=0 nullable=0 is_null=0 */
1158 ### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
1159 ### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
1160 ### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
1161 ### SET
1162 ### @1=4 /* INT meta=0 nullable=0 is_null=0 */
1163 ### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
1164 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
1165 ### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
1166 # Number of rows: 4
1167 COMMIT
1168 /*!*/;
1169 START TRANSACTION
1170 /*!*/;
1171 #Q> DELETE FROM t1 WHERE c1 = 1
1172 ### DELETE FROM `test`.`t1`
1173 ### WHERE
1174 ### @1=1 /* INT meta=0 nullable=0 is_null=0 */
1175 ### @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
1176 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
1177 ### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
1178 # Number of rows: 1
1179 COMMIT
1180 /*!*/;
1181 DELIMITER ;
1182 # End of log file
1183 ROLLBACK /* added by mysqlbinlog */;
1184 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
1185 FLUSH BINARY LOGS;
1186
1187 # t2 has no primary key.
1188 # It will binlog full before and after image for all modes if the
1189 # table has no primary key. FULL_NODUP follows the behavior.
1190
1191 INSERT INTO t2 VALUES(1, "insert_to_t2", 1, repeat('a', 20)),
1192 (2, "insert_to_t2", 2, repeat('a', 20)),
1193 (3, "insert_to_t2", 3, repeat('a', 20));
1194 INSERT INTO t2(c1) VALUES(4);
1195 UPDATE t2 SET c2 = "only_c2_changed";
1196 UPDATE t2 SET c3 = 1, c4 = "c3_c4_changed";
1197 DELETE FROM t2 WHERE c1 > 2;
1198
1199 # Verify that rows events are binlogged as expeced.
1200
1201 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
1202 DELIMITER /*!*/;
1203 # Warning: this binlog is either in use or was not closed properly.
1204 START TRANSACTION
1205 /*!*/;
1206 #Q> INSERT INTO t2 VALUES(1, "insert_to_t2", 1, repeat('a', 20)),
1207 #Q> (2, "insert_to_t2", 2, repeat('a', 20)),
1208 #Q> (3, "insert_to_t2", 3, repeat('a', 20))
1209 ### INSERT INTO `test`.`t2`
1210 ### SET
1211 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
1212 ### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
1213 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
1214 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
1215 ### INSERT INTO `test`.`t2`
1216 ### SET
1217 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
1218 ### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
1219 ### @3=2 /* INT meta=0 nullable=1 is_null=0 */
1220 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
1221 ### INSERT INTO `test`.`t2`
1222 ### SET
1223 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
1224 ### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
1225 ### @3=3 /* INT meta=0 nullable=1 is_null=0 */
1226 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
1227 # Number of rows: 3
1228 /*!\C latin1 *//*!*/;
1229 COMMIT
1230 /*!*/;
1231 START TRANSACTION
1232 /*!*/;
1233 #Q> INSERT INTO t2(c1) VALUES(4)
1234 ### INSERT INTO `test`.`t2`
1235 ### SET
1236 ### @1=4 /* INT meta=0 nullable=1 is_null=0 */
1237 ### @2=NULL /* STRING(100) meta=65124 nullable=1 is_null=1 */
1238 ### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
1239 ### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
1240 # Number of rows: 1
1241 COMMIT
1242 /*!*/;
1243 START TRANSACTION
1244 /*!*/;
1245 #Q> UPDATE t2 SET c2 = "only_c2_changed"
1246 ### UPDATE `test`.`t2`
1247 ### WHERE
1248 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
1249 ### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
1250 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
1251 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
1252 ### SET
1253 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
1254 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
1255 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
1256 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
1257 ### UPDATE `test`.`t2`
1258 ### WHERE
1259 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
1260 ### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
1261 ### @3=2 /* INT meta=0 nullable=1 is_null=0 */
1262 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
1263 ### SET
1264 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
1265 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
1266 ### @3=2 /* INT meta=0 nullable=1 is_null=0 */
1267 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
1268 ### UPDATE `test`.`t2`
1269 ### WHERE
1270 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
1271 ### @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
1272 ### @3=3 /* INT meta=0 nullable=1 is_null=0 */
1273 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
1274 ### SET
1275 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
1276 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
1277 ### @3=3 /* INT meta=0 nullable=1 is_null=0 */
1278 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
1279 ### UPDATE `test`.`t2`
1280 ### WHERE
1281 ### @1=4 /* INT meta=0 nullable=1 is_null=0 */
1282 ### @2=NULL /* STRING(100) meta=65124 nullable=1 is_null=1 */
1283 ### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
1284 ### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
1285 ### SET
1286 ### @1=4 /* INT meta=0 nullable=1 is_null=0 */
1287 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
1288 ### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
1289 ### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
1290 # Number of rows: 4
1291 COMMIT
1292 /*!*/;
1293 START TRANSACTION
1294 /*!*/;
1295 #Q> UPDATE t2 SET c3 = 1, c4 = "c3_c4_changed"
1296 ### UPDATE `test`.`t2`
1297 ### WHERE
1298 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
1299 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
1300 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
1301 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
1302 ### SET
1303 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
1304 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
1305 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
1306 ### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
1307 ### UPDATE `test`.`t2`
1308 ### WHERE
1309 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
1310 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
1311 ### @3=2 /* INT meta=0 nullable=1 is_null=0 */
1312 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
1313 ### SET
1314 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
1315 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
1316 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
1317 ### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
1318 ### UPDATE `test`.`t2`
1319 ### WHERE
1320 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
1321 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
1322 ### @3=3 /* INT meta=0 nullable=1 is_null=0 */
1323 ### @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
1324 ### SET
1325 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
1326 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
1327 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
1328 ### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
1329 ### UPDATE `test`.`t2`
1330 ### WHERE
1331 ### @1=4 /* INT meta=0 nullable=1 is_null=0 */
1332 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
1333 ### @3=1000 /* INT meta=0 nullable=1 is_null=0 */
1334 ### @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
1335 ### SET
1336 ### @1=4 /* INT meta=0 nullable=1 is_null=0 */
1337 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
1338 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
1339 ### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
1340 # Number of rows: 4
1341 COMMIT
1342 /*!*/;
1343 START TRANSACTION
1344 /*!*/;
1345 #Q> DELETE FROM t2 WHERE c1 > 2
1346 ### DELETE FROM `test`.`t2`
1347 ### WHERE
1348 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
1349 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
1350 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
1351 ### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
1352 ### DELETE FROM `test`.`t2`
1353 ### WHERE
1354 ### @1=4 /* INT meta=0 nullable=1 is_null=0 */
1355 ### @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
1356 ### @3=1 /* INT meta=0 nullable=1 is_null=0 */
1357 ### @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
1358 # Number of rows: 2
1359 COMMIT
1360 /*!*/;
1361 DELIMITER ;
1362 # End of log file
1363 ROLLBACK /* added by mysqlbinlog */;
1364 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
1365 DROP TABLE t1, t2;
1366 RESET MASTER;
1367 ALTER DATABASE test CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci;