13
13
CREATE TABLE t2 (a INT, b INT) ENGINE=Merge;
14
14
CREATE TABLE t3 (a INT, b INT) CHARSET=utf8;
15
15
CREATE TABLE t4 (a INT, b INT) ENGINE=Merge CHARSET=utf8;
16
SHOW BINLOG EVENTS FROM 106;
22
Info use `test`; CREATE TABLE t1 (a INT, b INT)
28
Info use `test`; CREATE TABLE t2 (a INT, b INT) ENGINE=Merge
34
Info use `test`; CREATE TABLE t3 (a INT, b INT) CHARSET=utf8
40
Info use `test`; CREATE TABLE t4 (a INT, b INT) ENGINE=Merge CHARSET=utf8
16
show binlog events from <binlog_start>;
17
Log_name Pos Event_type Server_id End_log_pos Info
18
master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT, b INT)
19
master-bin.000001 # Query # # use `test`; CREATE TABLE t2 (a INT, b INT) ENGINE=Merge
20
master-bin.000001 # Query # # use `test`; CREATE TABLE t3 (a INT, b INT) CHARSET=utf8
21
master-bin.000001 # Query # # use `test`; CREATE TABLE t4 (a INT, b INT) ENGINE=Merge CHARSET=utf8
41
22
**** On Master ****
42
23
SHOW CREATE TABLE t1;
137
118
include/start_slave.inc
138
119
CREATE TABLE t7 (UNIQUE(b)) SELECT a,b FROM tt3;
139
120
ERROR 23000: Duplicate entry '2' for key 'b'
140
SHOW BINLOG EVENTS FROM 106;
121
show binlog events from <binlog_start>;
141
122
Log_name Pos Event_type Server_id End_log_pos Info
142
123
CREATE TABLE t7 (a INT, b INT UNIQUE);
143
124
INSERT INTO t7 SELECT a,b FROM tt3;
150
SHOW BINLOG EVENTS FROM 106;
131
show binlog events from <binlog_start>;
151
132
Log_name Pos Event_type Server_id End_log_pos Info
152
# 106 Query # 206 use `test`; CREATE TABLE t7 (a INT, b INT UNIQUE)
153
# 206 Query # 274 BEGIN
154
# 274 Table_map # 316 table_id: # (test.t7)
155
# 316 Write_rows # 372 table_id: # flags: STMT_END_F
156
# 372 Query # 443 ROLLBACK
133
master-bin.000001 # Query # # use `test`; CREATE TABLE t7 (a INT, b INT UNIQUE)
134
master-bin.000001 # Query # # BEGIN
135
master-bin.000001 # Table_map # # table_id: # (test.t7)
136
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
137
master-bin.000001 # Query # # ROLLBACK
157
138
SELECT * FROM t7 ORDER BY a,b;
173
154
Warning 1196 Some non-transactional changed tables couldn't be rolled back
174
SHOW BINLOG EVENTS FROM 106;
155
show binlog events from <binlog_start>;
175
156
Log_name Pos Event_type Server_id End_log_pos Info
176
# 106 Query # 174 BEGIN
177
# 174 Table_map # 216 table_id: # (test.t7)
178
# 216 Write_rows # 272 table_id: # flags: STMT_END_F
179
# 272 Query # 341 COMMIT
157
master-bin.000001 # Query # # BEGIN
158
master-bin.000001 # Table_map # # table_id: # (test.t7)
159
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
160
master-bin.000001 # Query # # COMMIT
180
161
SELECT * FROM t7 ORDER BY a,b;
216
197
`a` int(11) DEFAULT NULL,
217
198
`b` int(11) DEFAULT NULL
218
199
) ENGINE=MyISAM DEFAULT CHARSET=latin1
219
SHOW BINLOG EVENTS FROM 106;
200
show binlog events from <binlog_start>;
220
201
Log_name Pos Event_type Server_id End_log_pos Info
221
# 106 Query # 192 use `test`; CREATE TABLE t8 LIKE t4
222
# 192 Query # 331 use `test`; CREATE TABLE `t9` (
202
master-bin.000001 # Query # # use `test`; CREATE TABLE t8 LIKE t4
203
master-bin.000001 # Query # # use `test`; CREATE TABLE `t9` (
223
204
`a` int(11) DEFAULT NULL,
224
205
`b` int(11) DEFAULT NULL
292
SHOW BINLOG EVENTS FROM 106;
273
show binlog events from <binlog_start>;
293
274
Log_name Pos Event_type Server_id End_log_pos Info
294
# 106 Query # 192 use `test`; CREATE TABLE t1 (a INT)
295
# 192 Query # 260 BEGIN
296
# 260 Table_map # 301 table_id: # (test.t1)
297
# 301 Write_rows # 345 table_id: # flags: STMT_END_F
298
# 345 Query # 414 COMMIT
299
# 414 Query # 482 BEGIN
300
# 482 Query # 607 use `test`; CREATE TABLE `t2` (
301
`a` int(11) DEFAULT NULL
303
# 607 Table_map # 648 table_id: # (test.t2)
304
# 648 Write_rows # 692 table_id: # flags: STMT_END_F
305
# 692 Xid # 719 COMMIT /* XID */
306
# 719 Query # 787 BEGIN
307
# 787 Query # 912 use `test`; CREATE TABLE `t3` (
308
`a` int(11) DEFAULT NULL
310
# 912 Table_map # 953 table_id: # (test.t3)
311
# 953 Write_rows # 997 table_id: # flags: STMT_END_F
312
# 997 Xid # 1024 COMMIT /* XID */
313
# 1024 Query # 1092 BEGIN
314
# 1092 Query # 1217 use `test`; CREATE TABLE `t4` (
315
`a` int(11) DEFAULT NULL
317
# 1217 Table_map # 1258 table_id: # (test.t4)
318
# 1258 Write_rows # 1302 table_id: # flags: STMT_END_F
319
# 1302 Xid # 1329 COMMIT /* XID */
320
# 1329 Query # 1397 BEGIN
321
# 1397 Table_map # 1438 table_id: # (test.t1)
322
# 1438 Write_rows # 1482 table_id: # flags: STMT_END_F
323
# 1482 Query # 1551 COMMIT
275
master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT)
276
master-bin.000001 # Query # # BEGIN
277
master-bin.000001 # Table_map # # table_id: # (test.t1)
278
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
279
master-bin.000001 # Query # # COMMIT
280
master-bin.000001 # Query # # BEGIN
281
master-bin.000001 # Query # # use `test`; CREATE TABLE `t2` (
282
`a` int(11) DEFAULT NULL
284
master-bin.000001 # Table_map # # table_id: # (test.t2)
285
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
286
master-bin.000001 # Xid # # COMMIT /* XID */
287
master-bin.000001 # Query # # BEGIN
288
master-bin.000001 # Query # # use `test`; CREATE TABLE `t3` (
289
`a` int(11) DEFAULT NULL
291
master-bin.000001 # Table_map # # table_id: # (test.t3)
292
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
293
master-bin.000001 # Xid # # COMMIT /* XID */
294
master-bin.000001 # Query # # BEGIN
295
master-bin.000001 # Query # # use `test`; CREATE TABLE `t4` (
296
`a` int(11) DEFAULT NULL
298
master-bin.000001 # Table_map # # table_id: # (test.t4)
299
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
300
master-bin.000001 # Xid # # COMMIT /* XID */
301
master-bin.000001 # Query # # BEGIN
302
master-bin.000001 # Table_map # # table_id: # (test.t1)
303
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
304
master-bin.000001 # Query # # COMMIT
377
SHOW BINLOG EVENTS FROM 106;
358
show binlog events from <binlog_start>;
378
359
Log_name Pos Event_type Server_id End_log_pos Info
379
# 106 Query # 192 use `test`; CREATE TABLE t1 (a INT)
380
# 192 Query # 260 BEGIN
381
# 260 Table_map # 301 table_id: # (test.t1)
382
# 301 Write_rows # 345 table_id: # flags: STMT_END_F
383
# 345 Query # 414 COMMIT
384
# 414 Query # 514 use `test`; CREATE TABLE t2 (a INT) ENGINE=INNODB
385
# 514 Query # 582 BEGIN
386
# 582 Table_map # 623 table_id: # (test.t2)
387
# 623 Write_rows # 667 table_id: # flags: STMT_END_F
388
# 667 Table_map # 708 table_id: # (test.t2)
389
# 708 Write_rows # 747 table_id: # flags: STMT_END_F
390
# 747 Xid # 774 COMMIT /* XID */
360
master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT)
361
master-bin.000001 # Query # # BEGIN
362
master-bin.000001 # Table_map # # table_id: # (test.t1)
363
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
364
master-bin.000001 # Query # # COMMIT
365
master-bin.000001 # Query # # use `test`; CREATE TABLE t2 (a INT) ENGINE=INNODB
366
master-bin.000001 # Query # # BEGIN
367
master-bin.000001 # Table_map # # table_id: # (test.t2)
368
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
369
master-bin.000001 # Table_map # # table_id: # (test.t2)
370
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
371
master-bin.000001 # Xid # # COMMIT /* XID */
391
372
SELECT * FROM t2 ORDER BY a;
413
394
Warning 1196 Some non-transactional changed tables couldn't be rolled back
414
395
SELECT * FROM t2 ORDER BY a;
416
SHOW BINLOG EVENTS FROM 106;
397
show binlog events from <binlog_start>;
417
398
Log_name Pos Event_type Server_id End_log_pos Info
418
# 106 Query # 174 BEGIN
419
# 174 Table_map # 215 table_id: # (test.t2)
420
# 215 Write_rows # 259 table_id: # flags: STMT_END_F
421
# 259 Table_map # 300 table_id: # (test.t2)
422
# 300 Write_rows # 339 table_id: # flags: STMT_END_F
423
# 339 Query # 410 ROLLBACK
399
master-bin.000001 # Query # # BEGIN
400
master-bin.000001 # Table_map # # table_id: # (test.t2)
401
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
402
master-bin.000001 # Table_map # # table_id: # (test.t2)
403
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
404
master-bin.000001 # Query # # ROLLBACK
424
405
SELECT * FROM t2 ORDER BY a;
426
407
DROP TABLE t1,t2;