1include/master-slave.inc
2Warnings:
3Note	####	Sending passwords in plain text without SSL/TLS is extremely insecure.
4Note	####	Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
5[connection master]
6# Creating table t1
7CREATE TABLE t1(c1 INT NOT NULL, c2 INT);
8###################################################################
9# Run plugin
10###################################################################
11INSTALL PLUGIN test_sql_replication SONAME 'TEST_SQL_REPLICATION';
12###################################################################
13# Stop plugin
14###################################################################
15UNINSTALL PLUGIN test_sql_replication;
16###################################################################
17# Plugin log
18###################################################################
19========================================================================
20Test in a server thread
21[srv_session_open]
22========================================================================
23EXECUTING:[35][SELECT 'first complex command' as a]
24[CS_TEXT_REPRESENTATION]
25		[meta] rows: 1
26		[meta] cols: 1
27		[meta] server status: 2
28		[meta] server status: AUTOCOMMIT
29		[meta] warning count: 0
30
31			[meta][field] db name:
32			[meta][field] table name:
33			[meta][field] org table name:
34			[meta][field] col name: a
35			[meta][field] org col name:
36			[meta][field] length: 63
37			[meta][field] charsetnr: 33
38			[meta][field] flags: 1 (NOT_NULL )
39			[meta][field] decimals: 31
40			[meta][field] type: VARCHAR (15)
41
42
43		[meta][charset result] number: 33
44		[meta][charset result] name: utf8
45		[meta][charset result] collation: utf8_general_ci
46		[meta][charset result] sort order:
47
48		[data][.a][ 21][first complex command]
49
50		[end] server status: 2
51		[end] server status: AUTOCOMMIT
52		[end] warning count:  0
53		[end] affected rows:  0
54		[end] last insert id: 0
55		[end] message:
56[CS_BINARY_REPRESENTATION]
57		[meta] rows: 1
58		[meta] cols: 1
59		[meta] server status: 2
60		[meta] server status: AUTOCOMMIT
61		[meta] warning count: 0
62
63			[meta][field] db name:
64			[meta][field] table name:
65			[meta][field] org table name:
66			[meta][field] col name: a
67			[meta][field] org col name:
68			[meta][field] length: 63
69			[meta][field] charsetnr: 33
70			[meta][field] flags: 1 (NOT_NULL )
71			[meta][field] decimals: 31
72			[meta][field] type: VARCHAR (15)
73
74
75		[meta][charset result] number: 33
76		[meta][charset result] name: utf8
77		[meta][charset result] collation: utf8_general_ci
78		[meta][charset result] sort order:
79
80		[data][.a][ 21][first complex command]
81
82		[end] server status: 2
83		[end] server status: AUTOCOMMIT
84		[end] warning count:  0
85		[end] affected rows:  0
86		[end] last insert id: 0
87		[end] message:
88========================================================================
89EXECUTING:[COM_INIT_DB][test]
90========================================================================
91EXECUTING:[62][INSERT INTO t1 VALUES (1,1), (2,2), (3,3), (4,1), (5,2), (6,3)]
92[CS_TEXT_REPRESENTATION]
93		[meta] rows: 0
94		[meta] cols: 0
95		[meta] server status: 0
96		[meta] server status:
97		[meta] warning count: 0
98
99		[meta] no columns
100
101		[meta] no charset
102
103		[data] no rows
104
105		[end] server status: 2
106		[end] server status: AUTOCOMMIT
107		[end] warning count:  0
108		[end] affected rows:  6
109		[end] last insert id: 0
110		[end] message: Records: 6  Duplicates: 0  Warnings: 0
111========================================================================
112EXECUTING:[COM_INIT_DB][test]
113========================================================================
114EXECUTING:[16][SELECT * FROM t1]
115[CS_TEXT_REPRESENTATION]
116		[meta] rows: 6
117		[meta] cols: 2
118		[meta] server status: 34
119		[meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
120		[meta] warning count: 0
121
122			[meta][field] db name: test
123			[meta][field] table name: t1
124			[meta][field] org table name: t1
125			[meta][field] col name: c1
126			[meta][field] org col name: c1
127			[meta][field] length: 11
128			[meta][field] charsetnr: 8
129			[meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE )
130			[meta][field] decimals: 0
131			[meta][field] type: LONG (3)
132
133			[meta][field] db name: test
134			[meta][field] table name: t1
135			[meta][field] org table name: t1
136			[meta][field] col name: c2
137			[meta][field] org col name: c2
138			[meta][field] length: 11
139			[meta][field] charsetnr: 8
140			[meta][field] flags: 0
141			[meta][field] decimals: 0
142			[meta][field] type: LONG (3)
143
144
145		[meta][charset result] number: 33
146		[meta][charset result] name: utf8
147		[meta][charset result] collation: utf8_general_ci
148		[meta][charset result] sort order:
149
150		[data][t1.c1][  1][1]
151		[data][t1.c2][  1][1]
152
153		[data][t1.c1][  1][2]
154		[data][t1.c2][  1][2]
155
156		[data][t1.c1][  1][3]
157		[data][t1.c2][  1][3]
158
159		[data][t1.c1][  1][4]
160		[data][t1.c2][  1][1]
161
162		[data][t1.c1][  1][5]
163		[data][t1.c2][  1][2]
164
165		[data][t1.c1][  1][6]
166		[data][t1.c2][  1][3]
167
168		[end] server status: 34
169		[end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
170		[end] warning count:  0
171		[end] affected rows:  0
172		[end] last insert id: 0
173		[end] message:
174[CS_BINARY_REPRESENTATION]
175		[meta] rows: 6
176		[meta] cols: 2
177		[meta] server status: 34
178		[meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
179		[meta] warning count: 0
180
181			[meta][field] db name: test
182			[meta][field] table name: t1
183			[meta][field] org table name: t1
184			[meta][field] col name: c1
185			[meta][field] org col name: c1
186			[meta][field] length: 11
187			[meta][field] charsetnr: 8
188			[meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE )
189			[meta][field] decimals: 0
190			[meta][field] type: LONG (3)
191
192			[meta][field] db name: test
193			[meta][field] table name: t1
194			[meta][field] org table name: t1
195			[meta][field] col name: c2
196			[meta][field] org col name: c2
197			[meta][field] length: 11
198			[meta][field] charsetnr: 8
199			[meta][field] flags: 0
200			[meta][field] decimals: 0
201			[meta][field] type: LONG (3)
202
203
204		[meta][charset result] number: 33
205		[meta][charset result] name: utf8
206		[meta][charset result] collation: utf8_general_ci
207		[meta][charset result] sort order:
208
209		[data][t1.c1][  1][1]
210		[data][t1.c2][  1][1]
211
212		[data][t1.c1][  1][2]
213		[data][t1.c2][  1][2]
214
215		[data][t1.c1][  1][3]
216		[data][t1.c2][  1][3]
217
218		[data][t1.c1][  1][4]
219		[data][t1.c2][  1][1]
220
221		[data][t1.c1][  1][5]
222		[data][t1.c2][  1][2]
223
224		[data][t1.c1][  1][6]
225		[data][t1.c2][  1][3]
226
227		[end] server status: 34
228		[end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
229		[end] warning count:  0
230		[end] affected rows:  0
231		[end] last insert id: 0
232		[end] message:
233========================================================================
234EXECUTING:[COM_INIT_DB][test]
235========================================================================
236EXECUTING:[35][UPDATE t1 SET c1 = 100 WHERE c2 = 2]
237[CS_TEXT_REPRESENTATION]
238		[meta] rows: 0
239		[meta] cols: 0
240		[meta] server status: 0
241		[meta] server status:
242		[meta] warning count: 0
243
244		[meta] no columns
245
246		[meta] no charset
247
248		[data] no rows
249
250		[end] server status: 34
251		[end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
252		[end] warning count:  0
253		[end] affected rows:  2
254		[end] last insert id: 0
255		[end] message: Rows matched: 2  Changed: 2  Warnings: 0
256========================================================================
257EXECUTING:[COM_INIT_DB][test]
258========================================================================
259EXECUTING:[16][SELECT * FROM t1]
260[CS_TEXT_REPRESENTATION]
261		[meta] rows: 6
262		[meta] cols: 2
263		[meta] server status: 34
264		[meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
265		[meta] warning count: 0
266
267			[meta][field] db name: test
268			[meta][field] table name: t1
269			[meta][field] org table name: t1
270			[meta][field] col name: c1
271			[meta][field] org col name: c1
272			[meta][field] length: 11
273			[meta][field] charsetnr: 8
274			[meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE )
275			[meta][field] decimals: 0
276			[meta][field] type: LONG (3)
277
278			[meta][field] db name: test
279			[meta][field] table name: t1
280			[meta][field] org table name: t1
281			[meta][field] col name: c2
282			[meta][field] org col name: c2
283			[meta][field] length: 11
284			[meta][field] charsetnr: 8
285			[meta][field] flags: 0
286			[meta][field] decimals: 0
287			[meta][field] type: LONG (3)
288
289
290		[meta][charset result] number: 33
291		[meta][charset result] name: utf8
292		[meta][charset result] collation: utf8_general_ci
293		[meta][charset result] sort order:
294
295		[data][t1.c1][  1][1]
296		[data][t1.c2][  1][1]
297
298		[data][t1.c1][  3][100]
299		[data][t1.c2][  1][2]
300
301		[data][t1.c1][  1][3]
302		[data][t1.c2][  1][3]
303
304		[data][t1.c1][  1][4]
305		[data][t1.c2][  1][1]
306
307		[data][t1.c1][  3][100]
308		[data][t1.c2][  1][2]
309
310		[data][t1.c1][  1][6]
311		[data][t1.c2][  1][3]
312
313		[end] server status: 34
314		[end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
315		[end] warning count:  0
316		[end] affected rows:  0
317		[end] last insert id: 0
318		[end] message:
319[CS_BINARY_REPRESENTATION]
320		[meta] rows: 6
321		[meta] cols: 2
322		[meta] server status: 34
323		[meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
324		[meta] warning count: 0
325
326			[meta][field] db name: test
327			[meta][field] table name: t1
328			[meta][field] org table name: t1
329			[meta][field] col name: c1
330			[meta][field] org col name: c1
331			[meta][field] length: 11
332			[meta][field] charsetnr: 8
333			[meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE )
334			[meta][field] decimals: 0
335			[meta][field] type: LONG (3)
336
337			[meta][field] db name: test
338			[meta][field] table name: t1
339			[meta][field] org table name: t1
340			[meta][field] col name: c2
341			[meta][field] org col name: c2
342			[meta][field] length: 11
343			[meta][field] charsetnr: 8
344			[meta][field] flags: 0
345			[meta][field] decimals: 0
346			[meta][field] type: LONG (3)
347
348
349		[meta][charset result] number: 33
350		[meta][charset result] name: utf8
351		[meta][charset result] collation: utf8_general_ci
352		[meta][charset result] sort order:
353
354		[data][t1.c1][  1][1]
355		[data][t1.c2][  1][1]
356
357		[data][t1.c1][  3][100]
358		[data][t1.c2][  1][2]
359
360		[data][t1.c1][  1][3]
361		[data][t1.c2][  1][3]
362
363		[data][t1.c1][  1][4]
364		[data][t1.c2][  1][1]
365
366		[data][t1.c1][  3][100]
367		[data][t1.c2][  1][2]
368
369		[data][t1.c1][  1][6]
370		[data][t1.c2][  1][3]
371
372		[end] server status: 34
373		[end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
374		[end] warning count:  0
375		[end] affected rows:  0
376		[end] last insert id: 0
377		[end] message:
378========================================================================
379[srv_session_close]
380Follows threaded run
381========================================================================
382init thread
383[srv_session_open]
384========================================================================
385EXECUTING:[35][SELECT 'first complex command' as a]
386[CS_TEXT_REPRESENTATION]
387		[meta] rows: 1
388		[meta] cols: 1
389		[meta] server status: 2
390		[meta] server status: AUTOCOMMIT
391		[meta] warning count: 0
392
393			[meta][field] db name:
394			[meta][field] table name:
395			[meta][field] org table name:
396			[meta][field] col name: a
397			[meta][field] org col name:
398			[meta][field] length: 63
399			[meta][field] charsetnr: 33
400			[meta][field] flags: 1 (NOT_NULL )
401			[meta][field] decimals: 31
402			[meta][field] type: VARCHAR (15)
403
404
405		[meta][charset result] number: 33
406		[meta][charset result] name: utf8
407		[meta][charset result] collation: utf8_general_ci
408		[meta][charset result] sort order:
409
410		[data][.a][ 21][first complex command]
411
412		[end] server status: 2
413		[end] server status: AUTOCOMMIT
414		[end] warning count:  0
415		[end] affected rows:  0
416		[end] last insert id: 0
417		[end] message:
418[CS_BINARY_REPRESENTATION]
419		[meta] rows: 1
420		[meta] cols: 1
421		[meta] server status: 2
422		[meta] server status: AUTOCOMMIT
423		[meta] warning count: 0
424
425			[meta][field] db name:
426			[meta][field] table name:
427			[meta][field] org table name:
428			[meta][field] col name: a
429			[meta][field] org col name:
430			[meta][field] length: 63
431			[meta][field] charsetnr: 33
432			[meta][field] flags: 1 (NOT_NULL )
433			[meta][field] decimals: 31
434			[meta][field] type: VARCHAR (15)
435
436
437		[meta][charset result] number: 33
438		[meta][charset result] name: utf8
439		[meta][charset result] collation: utf8_general_ci
440		[meta][charset result] sort order:
441
442		[data][.a][ 21][first complex command]
443
444		[end] server status: 2
445		[end] server status: AUTOCOMMIT
446		[end] warning count:  0
447		[end] affected rows:  0
448		[end] last insert id: 0
449		[end] message:
450========================================================================
451EXECUTING:[COM_INIT_DB][test]
452========================================================================
453EXECUTING:[62][INSERT INTO t1 VALUES (1,1), (2,2), (3,3), (4,1), (5,2), (6,3)]
454[CS_TEXT_REPRESENTATION]
455		[meta] rows: 0
456		[meta] cols: 0
457		[meta] server status: 0
458		[meta] server status:
459		[meta] warning count: 0
460
461		[meta] no columns
462
463		[meta] no charset
464
465		[data] no rows
466
467		[end] server status: 2
468		[end] server status: AUTOCOMMIT
469		[end] warning count:  0
470		[end] affected rows:  6
471		[end] last insert id: 0
472		[end] message: Records: 6  Duplicates: 0  Warnings: 0
473========================================================================
474EXECUTING:[COM_INIT_DB][test]
475========================================================================
476EXECUTING:[16][SELECT * FROM t1]
477[CS_TEXT_REPRESENTATION]
478		[meta] rows: 12
479		[meta] cols: 2
480		[meta] server status: 34
481		[meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
482		[meta] warning count: 0
483
484			[meta][field] db name: test
485			[meta][field] table name: t1
486			[meta][field] org table name: t1
487			[meta][field] col name: c1
488			[meta][field] org col name: c1
489			[meta][field] length: 11
490			[meta][field] charsetnr: 8
491			[meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE )
492			[meta][field] decimals: 0
493			[meta][field] type: LONG (3)
494
495			[meta][field] db name: test
496			[meta][field] table name: t1
497			[meta][field] org table name: t1
498			[meta][field] col name: c2
499			[meta][field] org col name: c2
500			[meta][field] length: 11
501			[meta][field] charsetnr: 8
502			[meta][field] flags: 0
503			[meta][field] decimals: 0
504			[meta][field] type: LONG (3)
505
506
507		[meta][charset result] number: 33
508		[meta][charset result] name: utf8
509		[meta][charset result] collation: utf8_general_ci
510		[meta][charset result] sort order:
511
512		[data][t1.c1][  1][1]
513		[data][t1.c2][  1][1]
514
515		[data][t1.c1][  3][100]
516		[data][t1.c2][  1][2]
517
518		[data][t1.c1][  1][3]
519		[data][t1.c2][  1][3]
520
521		[data][t1.c1][  1][4]
522		[data][t1.c2][  1][1]
523
524		[data][t1.c1][  3][100]
525		[data][t1.c2][  1][2]
526
527		[data][t1.c1][  1][6]
528		[data][t1.c2][  1][3]
529
530		[data][t1.c1][  1][1]
531		[data][t1.c2][  1][1]
532
533		[data][t1.c1][  1][2]
534		[data][t1.c2][  1][2]
535
536		[data][t1.c1][  1][3]
537		[data][t1.c2][  1][3]
538
539		[data][t1.c1][  1][4]
540		[data][t1.c2][  1][1]
541
542		[data][t1.c1][  1][5]
543		[data][t1.c2][  1][2]
544
545		[data][t1.c1][  1][6]
546		[data][t1.c2][  1][3]
547
548		[end] server status: 34
549		[end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
550		[end] warning count:  0
551		[end] affected rows:  0
552		[end] last insert id: 0
553		[end] message:
554[CS_BINARY_REPRESENTATION]
555		[meta] rows: 12
556		[meta] cols: 2
557		[meta] server status: 34
558		[meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
559		[meta] warning count: 0
560
561			[meta][field] db name: test
562			[meta][field] table name: t1
563			[meta][field] org table name: t1
564			[meta][field] col name: c1
565			[meta][field] org col name: c1
566			[meta][field] length: 11
567			[meta][field] charsetnr: 8
568			[meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE )
569			[meta][field] decimals: 0
570			[meta][field] type: LONG (3)
571
572			[meta][field] db name: test
573			[meta][field] table name: t1
574			[meta][field] org table name: t1
575			[meta][field] col name: c2
576			[meta][field] org col name: c2
577			[meta][field] length: 11
578			[meta][field] charsetnr: 8
579			[meta][field] flags: 0
580			[meta][field] decimals: 0
581			[meta][field] type: LONG (3)
582
583
584		[meta][charset result] number: 33
585		[meta][charset result] name: utf8
586		[meta][charset result] collation: utf8_general_ci
587		[meta][charset result] sort order:
588
589		[data][t1.c1][  1][1]
590		[data][t1.c2][  1][1]
591
592		[data][t1.c1][  3][100]
593		[data][t1.c2][  1][2]
594
595		[data][t1.c1][  1][3]
596		[data][t1.c2][  1][3]
597
598		[data][t1.c1][  1][4]
599		[data][t1.c2][  1][1]
600
601		[data][t1.c1][  3][100]
602		[data][t1.c2][  1][2]
603
604		[data][t1.c1][  1][6]
605		[data][t1.c2][  1][3]
606
607		[data][t1.c1][  1][1]
608		[data][t1.c2][  1][1]
609
610		[data][t1.c1][  1][2]
611		[data][t1.c2][  1][2]
612
613		[data][t1.c1][  1][3]
614		[data][t1.c2][  1][3]
615
616		[data][t1.c1][  1][4]
617		[data][t1.c2][  1][1]
618
619		[data][t1.c1][  1][5]
620		[data][t1.c2][  1][2]
621
622		[data][t1.c1][  1][6]
623		[data][t1.c2][  1][3]
624
625		[end] server status: 34
626		[end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
627		[end] warning count:  0
628		[end] affected rows:  0
629		[end] last insert id: 0
630		[end] message:
631========================================================================
632EXECUTING:[COM_INIT_DB][test]
633========================================================================
634EXECUTING:[35][UPDATE t1 SET c1 = 100 WHERE c2 = 2]
635[CS_TEXT_REPRESENTATION]
636		[meta] rows: 0
637		[meta] cols: 0
638		[meta] server status: 0
639		[meta] server status:
640		[meta] warning count: 0
641
642		[meta] no columns
643
644		[meta] no charset
645
646		[data] no rows
647
648		[end] server status: 34
649		[end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
650		[end] warning count:  0
651		[end] affected rows:  2
652		[end] last insert id: 0
653		[end] message: Rows matched: 4  Changed: 2  Warnings: 0
654========================================================================
655EXECUTING:[COM_INIT_DB][test]
656========================================================================
657EXECUTING:[16][SELECT * FROM t1]
658[CS_TEXT_REPRESENTATION]
659		[meta] rows: 12
660		[meta] cols: 2
661		[meta] server status: 34
662		[meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
663		[meta] warning count: 0
664
665			[meta][field] db name: test
666			[meta][field] table name: t1
667			[meta][field] org table name: t1
668			[meta][field] col name: c1
669			[meta][field] org col name: c1
670			[meta][field] length: 11
671			[meta][field] charsetnr: 8
672			[meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE )
673			[meta][field] decimals: 0
674			[meta][field] type: LONG (3)
675
676			[meta][field] db name: test
677			[meta][field] table name: t1
678			[meta][field] org table name: t1
679			[meta][field] col name: c2
680			[meta][field] org col name: c2
681			[meta][field] length: 11
682			[meta][field] charsetnr: 8
683			[meta][field] flags: 0
684			[meta][field] decimals: 0
685			[meta][field] type: LONG (3)
686
687
688		[meta][charset result] number: 33
689		[meta][charset result] name: utf8
690		[meta][charset result] collation: utf8_general_ci
691		[meta][charset result] sort order:
692
693		[data][t1.c1][  1][1]
694		[data][t1.c2][  1][1]
695
696		[data][t1.c1][  3][100]
697		[data][t1.c2][  1][2]
698
699		[data][t1.c1][  1][3]
700		[data][t1.c2][  1][3]
701
702		[data][t1.c1][  1][4]
703		[data][t1.c2][  1][1]
704
705		[data][t1.c1][  3][100]
706		[data][t1.c2][  1][2]
707
708		[data][t1.c1][  1][6]
709		[data][t1.c2][  1][3]
710
711		[data][t1.c1][  1][1]
712		[data][t1.c2][  1][1]
713
714		[data][t1.c1][  3][100]
715		[data][t1.c2][  1][2]
716
717		[data][t1.c1][  1][3]
718		[data][t1.c2][  1][3]
719
720		[data][t1.c1][  1][4]
721		[data][t1.c2][  1][1]
722
723		[data][t1.c1][  3][100]
724		[data][t1.c2][  1][2]
725
726		[data][t1.c1][  1][6]
727		[data][t1.c2][  1][3]
728
729		[end] server status: 34
730		[end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
731		[end] warning count:  0
732		[end] affected rows:  0
733		[end] last insert id: 0
734		[end] message:
735[CS_BINARY_REPRESENTATION]
736		[meta] rows: 12
737		[meta] cols: 2
738		[meta] server status: 34
739		[meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
740		[meta] warning count: 0
741
742			[meta][field] db name: test
743			[meta][field] table name: t1
744			[meta][field] org table name: t1
745			[meta][field] col name: c1
746			[meta][field] org col name: c1
747			[meta][field] length: 11
748			[meta][field] charsetnr: 8
749			[meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE )
750			[meta][field] decimals: 0
751			[meta][field] type: LONG (3)
752
753			[meta][field] db name: test
754			[meta][field] table name: t1
755			[meta][field] org table name: t1
756			[meta][field] col name: c2
757			[meta][field] org col name: c2
758			[meta][field] length: 11
759			[meta][field] charsetnr: 8
760			[meta][field] flags: 0
761			[meta][field] decimals: 0
762			[meta][field] type: LONG (3)
763
764
765		[meta][charset result] number: 33
766		[meta][charset result] name: utf8
767		[meta][charset result] collation: utf8_general_ci
768		[meta][charset result] sort order:
769
770		[data][t1.c1][  1][1]
771		[data][t1.c2][  1][1]
772
773		[data][t1.c1][  3][100]
774		[data][t1.c2][  1][2]
775
776		[data][t1.c1][  1][3]
777		[data][t1.c2][  1][3]
778
779		[data][t1.c1][  1][4]
780		[data][t1.c2][  1][1]
781
782		[data][t1.c1][  3][100]
783		[data][t1.c2][  1][2]
784
785		[data][t1.c1][  1][6]
786		[data][t1.c2][  1][3]
787
788		[data][t1.c1][  1][1]
789		[data][t1.c2][  1][1]
790
791		[data][t1.c1][  3][100]
792		[data][t1.c2][  1][2]
793
794		[data][t1.c1][  1][3]
795		[data][t1.c2][  1][3]
796
797		[data][t1.c1][  1][4]
798		[data][t1.c2][  1][1]
799
800		[data][t1.c1][  3][100]
801		[data][t1.c2][  1][2]
802
803		[data][t1.c1][  1][6]
804		[data][t1.c2][  1][3]
805
806		[end] server status: 34
807		[end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
808		[end] warning count:  0
809		[end] affected rows:  0
810		[end] last insert id: 0
811		[end] message:
812========================================================================
813[srv_session_close]
814deinit thread
815SELECT * FROM t1;
816c1	c2
8171	1
818100	2
8193	3
8204	1
821100	2
8226	3
8231	1
824100	2
8253	3
8264	1
827100	2
8286	3
829include/sync_slave_sql_with_master.inc
830[Connection Slave]
831SELECT * FROM t1;
832c1	c2
8331	1
834100	2
8353	3
8364	1
837100	2
8386	3
8391	1
840100	2
8413	3
8424	1
843100	2
8446	3
845[Connection Master]
846###################################################################
847# Run plugin
848###################################################################
849INSTALL PLUGIN test_sql_replication SONAME 'TEST_SQL_REPLICATION';
850###################################################################
851# Stop plugin
852###################################################################
853UNINSTALL PLUGIN test_sql_replication;
854###################################################################
855# Plugin log
856###################################################################
857========================================================================
858Test in a server thread
859[srv_session_open]
860========================================================================
861EXECUTING:[35][SELECT 'first complex command' as a]
862[CS_TEXT_REPRESENTATION]
863		[meta] rows: 1
864		[meta] cols: 1
865		[meta] server status: 2
866		[meta] server status: AUTOCOMMIT
867		[meta] warning count: 0
868
869			[meta][field] db name:
870			[meta][field] table name:
871			[meta][field] org table name:
872			[meta][field] col name: a
873			[meta][field] org col name:
874			[meta][field] length: 63
875			[meta][field] charsetnr: 33
876			[meta][field] flags: 1 (NOT_NULL )
877			[meta][field] decimals: 31
878			[meta][field] type: VARCHAR (15)
879
880
881		[meta][charset result] number: 33
882		[meta][charset result] name: utf8
883		[meta][charset result] collation: utf8_general_ci
884		[meta][charset result] sort order:
885
886		[data][.a][ 21][first complex command]
887
888		[end] server status: 2
889		[end] server status: AUTOCOMMIT
890		[end] warning count:  0
891		[end] affected rows:  0
892		[end] last insert id: 0
893		[end] message:
894[CS_BINARY_REPRESENTATION]
895		[meta] rows: 1
896		[meta] cols: 1
897		[meta] server status: 2
898		[meta] server status: AUTOCOMMIT
899		[meta] warning count: 0
900
901			[meta][field] db name:
902			[meta][field] table name:
903			[meta][field] org table name:
904			[meta][field] col name: a
905			[meta][field] org col name:
906			[meta][field] length: 63
907			[meta][field] charsetnr: 33
908			[meta][field] flags: 1 (NOT_NULL )
909			[meta][field] decimals: 31
910			[meta][field] type: VARCHAR (15)
911
912
913		[meta][charset result] number: 33
914		[meta][charset result] name: utf8
915		[meta][charset result] collation: utf8_general_ci
916		[meta][charset result] sort order:
917
918		[data][.a][ 21][first complex command]
919
920		[end] server status: 2
921		[end] server status: AUTOCOMMIT
922		[end] warning count:  0
923		[end] affected rows:  0
924		[end] last insert id: 0
925		[end] message:
926========================================================================
927EXECUTING:[COM_INIT_DB][test]
928========================================================================
929EXECUTING:[62][INSERT INTO t1 VALUES (1,1), (2,2), (3,3), (4,1), (5,2), (6,3)]
930[CS_TEXT_REPRESENTATION]
931		[meta] rows: 0
932		[meta] cols: 0
933		[meta] server status: 0
934		[meta] server status:
935		[meta] warning count: 0
936
937		[meta] no columns
938
939		[meta] no charset
940
941		[data] no rows
942
943		[end] server status: 2
944		[end] server status: AUTOCOMMIT
945		[end] warning count:  0
946		[end] affected rows:  6
947		[end] last insert id: 0
948		[end] message: Records: 6  Duplicates: 0  Warnings: 0
949========================================================================
950EXECUTING:[COM_INIT_DB][test]
951========================================================================
952EXECUTING:[16][SELECT * FROM t1]
953[CS_TEXT_REPRESENTATION]
954		[meta] rows: 18
955		[meta] cols: 2
956		[meta] server status: 34
957		[meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
958		[meta] warning count: 0
959
960			[meta][field] db name: test
961			[meta][field] table name: t1
962			[meta][field] org table name: t1
963			[meta][field] col name: c1
964			[meta][field] org col name: c1
965			[meta][field] length: 11
966			[meta][field] charsetnr: 8
967			[meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE )
968			[meta][field] decimals: 0
969			[meta][field] type: LONG (3)
970
971			[meta][field] db name: test
972			[meta][field] table name: t1
973			[meta][field] org table name: t1
974			[meta][field] col name: c2
975			[meta][field] org col name: c2
976			[meta][field] length: 11
977			[meta][field] charsetnr: 8
978			[meta][field] flags: 0
979			[meta][field] decimals: 0
980			[meta][field] type: LONG (3)
981
982
983		[meta][charset result] number: 33
984		[meta][charset result] name: utf8
985		[meta][charset result] collation: utf8_general_ci
986		[meta][charset result] sort order:
987
988		[data][t1.c1][  1][1]
989		[data][t1.c2][  1][1]
990
991		[data][t1.c1][  3][100]
992		[data][t1.c2][  1][2]
993
994		[data][t1.c1][  1][3]
995		[data][t1.c2][  1][3]
996
997		[data][t1.c1][  1][4]
998		[data][t1.c2][  1][1]
999
1000		[data][t1.c1][  3][100]
1001		[data][t1.c2][  1][2]
1002
1003		[data][t1.c1][  1][6]
1004		[data][t1.c2][  1][3]
1005
1006		[data][t1.c1][  1][1]
1007		[data][t1.c2][  1][1]
1008
1009		[data][t1.c1][  3][100]
1010		[data][t1.c2][  1][2]
1011
1012		[data][t1.c1][  1][3]
1013		[data][t1.c2][  1][3]
1014
1015		[data][t1.c1][  1][4]
1016		[data][t1.c2][  1][1]
1017
1018		[data][t1.c1][  3][100]
1019		[data][t1.c2][  1][2]
1020
1021		[data][t1.c1][  1][6]
1022		[data][t1.c2][  1][3]
1023
1024		[data][t1.c1][  1][1]
1025		[data][t1.c2][  1][1]
1026
1027		[data][t1.c1][  1][2]
1028		[data][t1.c2][  1][2]
1029
1030		[data][t1.c1][  1][3]
1031		[data][t1.c2][  1][3]
1032
1033		[data][t1.c1][  1][4]
1034		[data][t1.c2][  1][1]
1035
1036		[data][t1.c1][  1][5]
1037		[data][t1.c2][  1][2]
1038
1039		[data][t1.c1][  1][6]
1040		[data][t1.c2][  1][3]
1041
1042		[end] server status: 34
1043		[end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1044		[end] warning count:  0
1045		[end] affected rows:  0
1046		[end] last insert id: 0
1047		[end] message:
1048[CS_BINARY_REPRESENTATION]
1049		[meta] rows: 18
1050		[meta] cols: 2
1051		[meta] server status: 34
1052		[meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1053		[meta] warning count: 0
1054
1055			[meta][field] db name: test
1056			[meta][field] table name: t1
1057			[meta][field] org table name: t1
1058			[meta][field] col name: c1
1059			[meta][field] org col name: c1
1060			[meta][field] length: 11
1061			[meta][field] charsetnr: 8
1062			[meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE )
1063			[meta][field] decimals: 0
1064			[meta][field] type: LONG (3)
1065
1066			[meta][field] db name: test
1067			[meta][field] table name: t1
1068			[meta][field] org table name: t1
1069			[meta][field] col name: c2
1070			[meta][field] org col name: c2
1071			[meta][field] length: 11
1072			[meta][field] charsetnr: 8
1073			[meta][field] flags: 0
1074			[meta][field] decimals: 0
1075			[meta][field] type: LONG (3)
1076
1077
1078		[meta][charset result] number: 33
1079		[meta][charset result] name: utf8
1080		[meta][charset result] collation: utf8_general_ci
1081		[meta][charset result] sort order:
1082
1083		[data][t1.c1][  1][1]
1084		[data][t1.c2][  1][1]
1085
1086		[data][t1.c1][  3][100]
1087		[data][t1.c2][  1][2]
1088
1089		[data][t1.c1][  1][3]
1090		[data][t1.c2][  1][3]
1091
1092		[data][t1.c1][  1][4]
1093		[data][t1.c2][  1][1]
1094
1095		[data][t1.c1][  3][100]
1096		[data][t1.c2][  1][2]
1097
1098		[data][t1.c1][  1][6]
1099		[data][t1.c2][  1][3]
1100
1101		[data][t1.c1][  1][1]
1102		[data][t1.c2][  1][1]
1103
1104		[data][t1.c1][  3][100]
1105		[data][t1.c2][  1][2]
1106
1107		[data][t1.c1][  1][3]
1108		[data][t1.c2][  1][3]
1109
1110		[data][t1.c1][  1][4]
1111		[data][t1.c2][  1][1]
1112
1113		[data][t1.c1][  3][100]
1114		[data][t1.c2][  1][2]
1115
1116		[data][t1.c1][  1][6]
1117		[data][t1.c2][  1][3]
1118
1119		[data][t1.c1][  1][1]
1120		[data][t1.c2][  1][1]
1121
1122		[data][t1.c1][  1][2]
1123		[data][t1.c2][  1][2]
1124
1125		[data][t1.c1][  1][3]
1126		[data][t1.c2][  1][3]
1127
1128		[data][t1.c1][  1][4]
1129		[data][t1.c2][  1][1]
1130
1131		[data][t1.c1][  1][5]
1132		[data][t1.c2][  1][2]
1133
1134		[data][t1.c1][  1][6]
1135		[data][t1.c2][  1][3]
1136
1137		[end] server status: 34
1138		[end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1139		[end] warning count:  0
1140		[end] affected rows:  0
1141		[end] last insert id: 0
1142		[end] message:
1143========================================================================
1144EXECUTING:[COM_INIT_DB][test]
1145========================================================================
1146EXECUTING:[35][UPDATE t1 SET c1 = 100 WHERE c2 = 2]
1147[CS_TEXT_REPRESENTATION]
1148		[meta] rows: 0
1149		[meta] cols: 0
1150		[meta] server status: 0
1151		[meta] server status:
1152		[meta] warning count: 0
1153
1154		[meta] no columns
1155
1156		[meta] no charset
1157
1158		[data] no rows
1159
1160		[end] server status: 34
1161		[end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1162		[end] warning count:  0
1163		[end] affected rows:  2
1164		[end] last insert id: 0
1165		[end] message: Rows matched: 6  Changed: 2  Warnings: 0
1166========================================================================
1167EXECUTING:[COM_INIT_DB][test]
1168========================================================================
1169EXECUTING:[16][SELECT * FROM t1]
1170[CS_TEXT_REPRESENTATION]
1171		[meta] rows: 18
1172		[meta] cols: 2
1173		[meta] server status: 34
1174		[meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1175		[meta] warning count: 0
1176
1177			[meta][field] db name: test
1178			[meta][field] table name: t1
1179			[meta][field] org table name: t1
1180			[meta][field] col name: c1
1181			[meta][field] org col name: c1
1182			[meta][field] length: 11
1183			[meta][field] charsetnr: 8
1184			[meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE )
1185			[meta][field] decimals: 0
1186			[meta][field] type: LONG (3)
1187
1188			[meta][field] db name: test
1189			[meta][field] table name: t1
1190			[meta][field] org table name: t1
1191			[meta][field] col name: c2
1192			[meta][field] org col name: c2
1193			[meta][field] length: 11
1194			[meta][field] charsetnr: 8
1195			[meta][field] flags: 0
1196			[meta][field] decimals: 0
1197			[meta][field] type: LONG (3)
1198
1199
1200		[meta][charset result] number: 33
1201		[meta][charset result] name: utf8
1202		[meta][charset result] collation: utf8_general_ci
1203		[meta][charset result] sort order:
1204
1205		[data][t1.c1][  1][1]
1206		[data][t1.c2][  1][1]
1207
1208		[data][t1.c1][  3][100]
1209		[data][t1.c2][  1][2]
1210
1211		[data][t1.c1][  1][3]
1212		[data][t1.c2][  1][3]
1213
1214		[data][t1.c1][  1][4]
1215		[data][t1.c2][  1][1]
1216
1217		[data][t1.c1][  3][100]
1218		[data][t1.c2][  1][2]
1219
1220		[data][t1.c1][  1][6]
1221		[data][t1.c2][  1][3]
1222
1223		[data][t1.c1][  1][1]
1224		[data][t1.c2][  1][1]
1225
1226		[data][t1.c1][  3][100]
1227		[data][t1.c2][  1][2]
1228
1229		[data][t1.c1][  1][3]
1230		[data][t1.c2][  1][3]
1231
1232		[data][t1.c1][  1][4]
1233		[data][t1.c2][  1][1]
1234
1235		[data][t1.c1][  3][100]
1236		[data][t1.c2][  1][2]
1237
1238		[data][t1.c1][  1][6]
1239		[data][t1.c2][  1][3]
1240
1241		[data][t1.c1][  1][1]
1242		[data][t1.c2][  1][1]
1243
1244		[data][t1.c1][  3][100]
1245		[data][t1.c2][  1][2]
1246
1247		[data][t1.c1][  1][3]
1248		[data][t1.c2][  1][3]
1249
1250		[data][t1.c1][  1][4]
1251		[data][t1.c2][  1][1]
1252
1253		[data][t1.c1][  3][100]
1254		[data][t1.c2][  1][2]
1255
1256		[data][t1.c1][  1][6]
1257		[data][t1.c2][  1][3]
1258
1259		[end] server status: 34
1260		[end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1261		[end] warning count:  0
1262		[end] affected rows:  0
1263		[end] last insert id: 0
1264		[end] message:
1265[CS_BINARY_REPRESENTATION]
1266		[meta] rows: 18
1267		[meta] cols: 2
1268		[meta] server status: 34
1269		[meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1270		[meta] warning count: 0
1271
1272			[meta][field] db name: test
1273			[meta][field] table name: t1
1274			[meta][field] org table name: t1
1275			[meta][field] col name: c1
1276			[meta][field] org col name: c1
1277			[meta][field] length: 11
1278			[meta][field] charsetnr: 8
1279			[meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE )
1280			[meta][field] decimals: 0
1281			[meta][field] type: LONG (3)
1282
1283			[meta][field] db name: test
1284			[meta][field] table name: t1
1285			[meta][field] org table name: t1
1286			[meta][field] col name: c2
1287			[meta][field] org col name: c2
1288			[meta][field] length: 11
1289			[meta][field] charsetnr: 8
1290			[meta][field] flags: 0
1291			[meta][field] decimals: 0
1292			[meta][field] type: LONG (3)
1293
1294
1295		[meta][charset result] number: 33
1296		[meta][charset result] name: utf8
1297		[meta][charset result] collation: utf8_general_ci
1298		[meta][charset result] sort order:
1299
1300		[data][t1.c1][  1][1]
1301		[data][t1.c2][  1][1]
1302
1303		[data][t1.c1][  3][100]
1304		[data][t1.c2][  1][2]
1305
1306		[data][t1.c1][  1][3]
1307		[data][t1.c2][  1][3]
1308
1309		[data][t1.c1][  1][4]
1310		[data][t1.c2][  1][1]
1311
1312		[data][t1.c1][  3][100]
1313		[data][t1.c2][  1][2]
1314
1315		[data][t1.c1][  1][6]
1316		[data][t1.c2][  1][3]
1317
1318		[data][t1.c1][  1][1]
1319		[data][t1.c2][  1][1]
1320
1321		[data][t1.c1][  3][100]
1322		[data][t1.c2][  1][2]
1323
1324		[data][t1.c1][  1][3]
1325		[data][t1.c2][  1][3]
1326
1327		[data][t1.c1][  1][4]
1328		[data][t1.c2][  1][1]
1329
1330		[data][t1.c1][  3][100]
1331		[data][t1.c2][  1][2]
1332
1333		[data][t1.c1][  1][6]
1334		[data][t1.c2][  1][3]
1335
1336		[data][t1.c1][  1][1]
1337		[data][t1.c2][  1][1]
1338
1339		[data][t1.c1][  3][100]
1340		[data][t1.c2][  1][2]
1341
1342		[data][t1.c1][  1][3]
1343		[data][t1.c2][  1][3]
1344
1345		[data][t1.c1][  1][4]
1346		[data][t1.c2][  1][1]
1347
1348		[data][t1.c1][  3][100]
1349		[data][t1.c2][  1][2]
1350
1351		[data][t1.c1][  1][6]
1352		[data][t1.c2][  1][3]
1353
1354		[end] server status: 34
1355		[end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1356		[end] warning count:  0
1357		[end] affected rows:  0
1358		[end] last insert id: 0
1359		[end] message:
1360========================================================================
1361[srv_session_close]
1362Follows threaded run
1363========================================================================
1364init thread
1365[srv_session_open]
1366========================================================================
1367EXECUTING:[35][SELECT 'first complex command' as a]
1368[CS_TEXT_REPRESENTATION]
1369		[meta] rows: 1
1370		[meta] cols: 1
1371		[meta] server status: 2
1372		[meta] server status: AUTOCOMMIT
1373		[meta] warning count: 0
1374
1375			[meta][field] db name:
1376			[meta][field] table name:
1377			[meta][field] org table name:
1378			[meta][field] col name: a
1379			[meta][field] org col name:
1380			[meta][field] length: 63
1381			[meta][field] charsetnr: 33
1382			[meta][field] flags: 1 (NOT_NULL )
1383			[meta][field] decimals: 31
1384			[meta][field] type: VARCHAR (15)
1385
1386
1387		[meta][charset result] number: 33
1388		[meta][charset result] name: utf8
1389		[meta][charset result] collation: utf8_general_ci
1390		[meta][charset result] sort order:
1391
1392		[data][.a][ 21][first complex command]
1393
1394		[end] server status: 2
1395		[end] server status: AUTOCOMMIT
1396		[end] warning count:  0
1397		[end] affected rows:  0
1398		[end] last insert id: 0
1399		[end] message:
1400[CS_BINARY_REPRESENTATION]
1401		[meta] rows: 1
1402		[meta] cols: 1
1403		[meta] server status: 2
1404		[meta] server status: AUTOCOMMIT
1405		[meta] warning count: 0
1406
1407			[meta][field] db name:
1408			[meta][field] table name:
1409			[meta][field] org table name:
1410			[meta][field] col name: a
1411			[meta][field] org col name:
1412			[meta][field] length: 63
1413			[meta][field] charsetnr: 33
1414			[meta][field] flags: 1 (NOT_NULL )
1415			[meta][field] decimals: 31
1416			[meta][field] type: VARCHAR (15)
1417
1418
1419		[meta][charset result] number: 33
1420		[meta][charset result] name: utf8
1421		[meta][charset result] collation: utf8_general_ci
1422		[meta][charset result] sort order:
1423
1424		[data][.a][ 21][first complex command]
1425
1426		[end] server status: 2
1427		[end] server status: AUTOCOMMIT
1428		[end] warning count:  0
1429		[end] affected rows:  0
1430		[end] last insert id: 0
1431		[end] message:
1432========================================================================
1433EXECUTING:[COM_INIT_DB][test]
1434========================================================================
1435EXECUTING:[62][INSERT INTO t1 VALUES (1,1), (2,2), (3,3), (4,1), (5,2), (6,3)]
1436[CS_TEXT_REPRESENTATION]
1437		[meta] rows: 0
1438		[meta] cols: 0
1439		[meta] server status: 0
1440		[meta] server status:
1441		[meta] warning count: 0
1442
1443		[meta] no columns
1444
1445		[meta] no charset
1446
1447		[data] no rows
1448
1449		[end] server status: 2
1450		[end] server status: AUTOCOMMIT
1451		[end] warning count:  0
1452		[end] affected rows:  6
1453		[end] last insert id: 0
1454		[end] message: Records: 6  Duplicates: 0  Warnings: 0
1455========================================================================
1456EXECUTING:[COM_INIT_DB][test]
1457========================================================================
1458EXECUTING:[16][SELECT * FROM t1]
1459[CS_TEXT_REPRESENTATION]
1460		[meta] rows: 24
1461		[meta] cols: 2
1462		[meta] server status: 34
1463		[meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1464		[meta] warning count: 0
1465
1466			[meta][field] db name: test
1467			[meta][field] table name: t1
1468			[meta][field] org table name: t1
1469			[meta][field] col name: c1
1470			[meta][field] org col name: c1
1471			[meta][field] length: 11
1472			[meta][field] charsetnr: 8
1473			[meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE )
1474			[meta][field] decimals: 0
1475			[meta][field] type: LONG (3)
1476
1477			[meta][field] db name: test
1478			[meta][field] table name: t1
1479			[meta][field] org table name: t1
1480			[meta][field] col name: c2
1481			[meta][field] org col name: c2
1482			[meta][field] length: 11
1483			[meta][field] charsetnr: 8
1484			[meta][field] flags: 0
1485			[meta][field] decimals: 0
1486			[meta][field] type: LONG (3)
1487
1488
1489		[meta][charset result] number: 33
1490		[meta][charset result] name: utf8
1491		[meta][charset result] collation: utf8_general_ci
1492		[meta][charset result] sort order:
1493
1494		[data][t1.c1][  1][1]
1495		[data][t1.c2][  1][1]
1496
1497		[data][t1.c1][  3][100]
1498		[data][t1.c2][  1][2]
1499
1500		[data][t1.c1][  1][3]
1501		[data][t1.c2][  1][3]
1502
1503		[data][t1.c1][  1][4]
1504		[data][t1.c2][  1][1]
1505
1506		[data][t1.c1][  3][100]
1507		[data][t1.c2][  1][2]
1508
1509		[data][t1.c1][  1][6]
1510		[data][t1.c2][  1][3]
1511
1512		[data][t1.c1][  1][1]
1513		[data][t1.c2][  1][1]
1514
1515		[data][t1.c1][  3][100]
1516		[data][t1.c2][  1][2]
1517
1518		[data][t1.c1][  1][3]
1519		[data][t1.c2][  1][3]
1520
1521		[data][t1.c1][  1][4]
1522		[data][t1.c2][  1][1]
1523
1524		[data][t1.c1][  3][100]
1525		[data][t1.c2][  1][2]
1526
1527		[data][t1.c1][  1][6]
1528		[data][t1.c2][  1][3]
1529
1530		[data][t1.c1][  1][1]
1531		[data][t1.c2][  1][1]
1532
1533		[data][t1.c1][  3][100]
1534		[data][t1.c2][  1][2]
1535
1536		[data][t1.c1][  1][3]
1537		[data][t1.c2][  1][3]
1538
1539		[data][t1.c1][  1][4]
1540		[data][t1.c2][  1][1]
1541
1542		[data][t1.c1][  3][100]
1543		[data][t1.c2][  1][2]
1544
1545		[data][t1.c1][  1][6]
1546		[data][t1.c2][  1][3]
1547
1548		[data][t1.c1][  1][1]
1549		[data][t1.c2][  1][1]
1550
1551		[data][t1.c1][  1][2]
1552		[data][t1.c2][  1][2]
1553
1554		[data][t1.c1][  1][3]
1555		[data][t1.c2][  1][3]
1556
1557		[data][t1.c1][  1][4]
1558		[data][t1.c2][  1][1]
1559
1560		[data][t1.c1][  1][5]
1561		[data][t1.c2][  1][2]
1562
1563		[data][t1.c1][  1][6]
1564		[data][t1.c2][  1][3]
1565
1566		[end] server status: 34
1567		[end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1568		[end] warning count:  0
1569		[end] affected rows:  0
1570		[end] last insert id: 0
1571		[end] message:
1572[CS_BINARY_REPRESENTATION]
1573		[meta] rows: 24
1574		[meta] cols: 2
1575		[meta] server status: 34
1576		[meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1577		[meta] warning count: 0
1578
1579			[meta][field] db name: test
1580			[meta][field] table name: t1
1581			[meta][field] org table name: t1
1582			[meta][field] col name: c1
1583			[meta][field] org col name: c1
1584			[meta][field] length: 11
1585			[meta][field] charsetnr: 8
1586			[meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE )
1587			[meta][field] decimals: 0
1588			[meta][field] type: LONG (3)
1589
1590			[meta][field] db name: test
1591			[meta][field] table name: t1
1592			[meta][field] org table name: t1
1593			[meta][field] col name: c2
1594			[meta][field] org col name: c2
1595			[meta][field] length: 11
1596			[meta][field] charsetnr: 8
1597			[meta][field] flags: 0
1598			[meta][field] decimals: 0
1599			[meta][field] type: LONG (3)
1600
1601
1602		[meta][charset result] number: 33
1603		[meta][charset result] name: utf8
1604		[meta][charset result] collation: utf8_general_ci
1605		[meta][charset result] sort order:
1606
1607		[data][t1.c1][  1][1]
1608		[data][t1.c2][  1][1]
1609
1610		[data][t1.c1][  3][100]
1611		[data][t1.c2][  1][2]
1612
1613		[data][t1.c1][  1][3]
1614		[data][t1.c2][  1][3]
1615
1616		[data][t1.c1][  1][4]
1617		[data][t1.c2][  1][1]
1618
1619		[data][t1.c1][  3][100]
1620		[data][t1.c2][  1][2]
1621
1622		[data][t1.c1][  1][6]
1623		[data][t1.c2][  1][3]
1624
1625		[data][t1.c1][  1][1]
1626		[data][t1.c2][  1][1]
1627
1628		[data][t1.c1][  3][100]
1629		[data][t1.c2][  1][2]
1630
1631		[data][t1.c1][  1][3]
1632		[data][t1.c2][  1][3]
1633
1634		[data][t1.c1][  1][4]
1635		[data][t1.c2][  1][1]
1636
1637		[data][t1.c1][  3][100]
1638		[data][t1.c2][  1][2]
1639
1640		[data][t1.c1][  1][6]
1641		[data][t1.c2][  1][3]
1642
1643		[data][t1.c1][  1][1]
1644		[data][t1.c2][  1][1]
1645
1646		[data][t1.c1][  3][100]
1647		[data][t1.c2][  1][2]
1648
1649		[data][t1.c1][  1][3]
1650		[data][t1.c2][  1][3]
1651
1652		[data][t1.c1][  1][4]
1653		[data][t1.c2][  1][1]
1654
1655		[data][t1.c1][  3][100]
1656		[data][t1.c2][  1][2]
1657
1658		[data][t1.c1][  1][6]
1659		[data][t1.c2][  1][3]
1660
1661		[data][t1.c1][  1][1]
1662		[data][t1.c2][  1][1]
1663
1664		[data][t1.c1][  1][2]
1665		[data][t1.c2][  1][2]
1666
1667		[data][t1.c1][  1][3]
1668		[data][t1.c2][  1][3]
1669
1670		[data][t1.c1][  1][4]
1671		[data][t1.c2][  1][1]
1672
1673		[data][t1.c1][  1][5]
1674		[data][t1.c2][  1][2]
1675
1676		[data][t1.c1][  1][6]
1677		[data][t1.c2][  1][3]
1678
1679		[end] server status: 34
1680		[end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1681		[end] warning count:  0
1682		[end] affected rows:  0
1683		[end] last insert id: 0
1684		[end] message:
1685========================================================================
1686EXECUTING:[COM_INIT_DB][test]
1687========================================================================
1688EXECUTING:[35][UPDATE t1 SET c1 = 100 WHERE c2 = 2]
1689[CS_TEXT_REPRESENTATION]
1690		[meta] rows: 0
1691		[meta] cols: 0
1692		[meta] server status: 0
1693		[meta] server status:
1694		[meta] warning count: 0
1695
1696		[meta] no columns
1697
1698		[meta] no charset
1699
1700		[data] no rows
1701
1702		[end] server status: 34
1703		[end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1704		[end] warning count:  0
1705		[end] affected rows:  2
1706		[end] last insert id: 0
1707		[end] message: Rows matched: 8  Changed: 2  Warnings: 0
1708========================================================================
1709EXECUTING:[COM_INIT_DB][test]
1710========================================================================
1711EXECUTING:[16][SELECT * FROM t1]
1712[CS_TEXT_REPRESENTATION]
1713		[meta] rows: 24
1714		[meta] cols: 2
1715		[meta] server status: 34
1716		[meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1717		[meta] warning count: 0
1718
1719			[meta][field] db name: test
1720			[meta][field] table name: t1
1721			[meta][field] org table name: t1
1722			[meta][field] col name: c1
1723			[meta][field] org col name: c1
1724			[meta][field] length: 11
1725			[meta][field] charsetnr: 8
1726			[meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE )
1727			[meta][field] decimals: 0
1728			[meta][field] type: LONG (3)
1729
1730			[meta][field] db name: test
1731			[meta][field] table name: t1
1732			[meta][field] org table name: t1
1733			[meta][field] col name: c2
1734			[meta][field] org col name: c2
1735			[meta][field] length: 11
1736			[meta][field] charsetnr: 8
1737			[meta][field] flags: 0
1738			[meta][field] decimals: 0
1739			[meta][field] type: LONG (3)
1740
1741
1742		[meta][charset result] number: 33
1743		[meta][charset result] name: utf8
1744		[meta][charset result] collation: utf8_general_ci
1745		[meta][charset result] sort order:
1746
1747		[data][t1.c1][  1][1]
1748		[data][t1.c2][  1][1]
1749
1750		[data][t1.c1][  3][100]
1751		[data][t1.c2][  1][2]
1752
1753		[data][t1.c1][  1][3]
1754		[data][t1.c2][  1][3]
1755
1756		[data][t1.c1][  1][4]
1757		[data][t1.c2][  1][1]
1758
1759		[data][t1.c1][  3][100]
1760		[data][t1.c2][  1][2]
1761
1762		[data][t1.c1][  1][6]
1763		[data][t1.c2][  1][3]
1764
1765		[data][t1.c1][  1][1]
1766		[data][t1.c2][  1][1]
1767
1768		[data][t1.c1][  3][100]
1769		[data][t1.c2][  1][2]
1770
1771		[data][t1.c1][  1][3]
1772		[data][t1.c2][  1][3]
1773
1774		[data][t1.c1][  1][4]
1775		[data][t1.c2][  1][1]
1776
1777		[data][t1.c1][  3][100]
1778		[data][t1.c2][  1][2]
1779
1780		[data][t1.c1][  1][6]
1781		[data][t1.c2][  1][3]
1782
1783		[data][t1.c1][  1][1]
1784		[data][t1.c2][  1][1]
1785
1786		[data][t1.c1][  3][100]
1787		[data][t1.c2][  1][2]
1788
1789		[data][t1.c1][  1][3]
1790		[data][t1.c2][  1][3]
1791
1792		[data][t1.c1][  1][4]
1793		[data][t1.c2][  1][1]
1794
1795		[data][t1.c1][  3][100]
1796		[data][t1.c2][  1][2]
1797
1798		[data][t1.c1][  1][6]
1799		[data][t1.c2][  1][3]
1800
1801		[data][t1.c1][  1][1]
1802		[data][t1.c2][  1][1]
1803
1804		[data][t1.c1][  3][100]
1805		[data][t1.c2][  1][2]
1806
1807		[data][t1.c1][  1][3]
1808		[data][t1.c2][  1][3]
1809
1810		[data][t1.c1][  1][4]
1811		[data][t1.c2][  1][1]
1812
1813		[data][t1.c1][  3][100]
1814		[data][t1.c2][  1][2]
1815
1816		[data][t1.c1][  1][6]
1817		[data][t1.c2][  1][3]
1818
1819		[end] server status: 34
1820		[end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1821		[end] warning count:  0
1822		[end] affected rows:  0
1823		[end] last insert id: 0
1824		[end] message:
1825[CS_BINARY_REPRESENTATION]
1826		[meta] rows: 24
1827		[meta] cols: 2
1828		[meta] server status: 34
1829		[meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1830		[meta] warning count: 0
1831
1832			[meta][field] db name: test
1833			[meta][field] table name: t1
1834			[meta][field] org table name: t1
1835			[meta][field] col name: c1
1836			[meta][field] org col name: c1
1837			[meta][field] length: 11
1838			[meta][field] charsetnr: 8
1839			[meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE )
1840			[meta][field] decimals: 0
1841			[meta][field] type: LONG (3)
1842
1843			[meta][field] db name: test
1844			[meta][field] table name: t1
1845			[meta][field] org table name: t1
1846			[meta][field] col name: c2
1847			[meta][field] org col name: c2
1848			[meta][field] length: 11
1849			[meta][field] charsetnr: 8
1850			[meta][field] flags: 0
1851			[meta][field] decimals: 0
1852			[meta][field] type: LONG (3)
1853
1854
1855		[meta][charset result] number: 33
1856		[meta][charset result] name: utf8
1857		[meta][charset result] collation: utf8_general_ci
1858		[meta][charset result] sort order:
1859
1860		[data][t1.c1][  1][1]
1861		[data][t1.c2][  1][1]
1862
1863		[data][t1.c1][  3][100]
1864		[data][t1.c2][  1][2]
1865
1866		[data][t1.c1][  1][3]
1867		[data][t1.c2][  1][3]
1868
1869		[data][t1.c1][  1][4]
1870		[data][t1.c2][  1][1]
1871
1872		[data][t1.c1][  3][100]
1873		[data][t1.c2][  1][2]
1874
1875		[data][t1.c1][  1][6]
1876		[data][t1.c2][  1][3]
1877
1878		[data][t1.c1][  1][1]
1879		[data][t1.c2][  1][1]
1880
1881		[data][t1.c1][  3][100]
1882		[data][t1.c2][  1][2]
1883
1884		[data][t1.c1][  1][3]
1885		[data][t1.c2][  1][3]
1886
1887		[data][t1.c1][  1][4]
1888		[data][t1.c2][  1][1]
1889
1890		[data][t1.c1][  3][100]
1891		[data][t1.c2][  1][2]
1892
1893		[data][t1.c1][  1][6]
1894		[data][t1.c2][  1][3]
1895
1896		[data][t1.c1][  1][1]
1897		[data][t1.c2][  1][1]
1898
1899		[data][t1.c1][  3][100]
1900		[data][t1.c2][  1][2]
1901
1902		[data][t1.c1][  1][3]
1903		[data][t1.c2][  1][3]
1904
1905		[data][t1.c1][  1][4]
1906		[data][t1.c2][  1][1]
1907
1908		[data][t1.c1][  3][100]
1909		[data][t1.c2][  1][2]
1910
1911		[data][t1.c1][  1][6]
1912		[data][t1.c2][  1][3]
1913
1914		[data][t1.c1][  1][1]
1915		[data][t1.c2][  1][1]
1916
1917		[data][t1.c1][  3][100]
1918		[data][t1.c2][  1][2]
1919
1920		[data][t1.c1][  1][3]
1921		[data][t1.c2][  1][3]
1922
1923		[data][t1.c1][  1][4]
1924		[data][t1.c2][  1][1]
1925
1926		[data][t1.c1][  3][100]
1927		[data][t1.c2][  1][2]
1928
1929		[data][t1.c1][  1][6]
1930		[data][t1.c2][  1][3]
1931
1932		[end] server status: 34
1933		[end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
1934		[end] warning count:  0
1935		[end] affected rows:  0
1936		[end] last insert id: 0
1937		[end] message:
1938========================================================================
1939[srv_session_close]
1940deinit thread
1941SELECT * FROM t1;
1942c1	c2
19431	1
1944100	2
19453	3
19464	1
1947100	2
19486	3
19491	1
1950100	2
19513	3
19524	1
1953100	2
19546	3
19551	1
1956100	2
19573	3
19584	1
1959100	2
19606	3
19611	1
1962100	2
19633	3
19644	1
1965100	2
19666	3
1967include/sync_slave_sql_with_master.inc
1968[Connection Slave]
1969SELECT * FROM t1;
1970c1	c2
19711	1
1972100	2
19733	3
19744	1
1975100	2
19766	3
19771	1
1978100	2
19793	3
19804	1
1981100	2
19826	3
19831	1
1984100	2
19853	3
19864	1
1987100	2
19886	3
19891	1
1990100	2
19913	3
19924	1
1993100	2
19946	3
1995include/diff_tables.inc [master:t1,slave:t1]
1996[Connection Master]
1997# Dropping the created table
1998DROP TABLE t1;
1999SELECT * FROM t1;
2000ERROR 42S02: Table 'test.t1' doesn't exist
2001include/sync_slave_sql_with_master.inc
2002[Connection Slave]
2003SELECT * FROM t1;
2004ERROR 42S02: Table 'test.t1' doesn't exist
2005include/rpl_end.inc
2006