Debian Codegraph @

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

raw
1 SET @old_binlog_format=@@binlog_format;
2 SET BINLOG_FORMAT=ROW;
3 RESET MASTER;
4 CREATE TABLE t1 (a INT) ENGINE=MyISAM;
5 CREATE TABLE t2 (a INT) ENGINE=MyISAM;
6 INSERT INTO t2 VALUES (1),(2),(3);
7 **** Truncate of empty table shall be logged
8 TRUNCATE TABLE t1;
9 TRUNCATE TABLE t2;
10 include/show_binlog_events.inc
11 Log_name Pos Event_type Server_id End_log_pos Info
12 master-bin.000001 # Gtid # # GTID #-#-#
13 master-bin.000001 # Query # # use `test`; TRUNCATE TABLE t1
14 master-bin.000001 # Gtid # # GTID #-#-#
15 master-bin.000001 # Query # # use `test`; TRUNCATE TABLE t2
16 DROP TABLE t1,t2;
17 #
18 # Bug#42643: InnoDB does not support replication of TRUNCATE TABLE
19 #
20 CREATE TABLE t1 (a INT) ENGINE=MyISAM;
21 CREATE TABLE t2 (a INT) ENGINE=MyISAM;
22 INSERT INTO t1 VALUES (1),(2);
23 BEGIN;
24 INSERT INTO t2 SELECT * FROM t1;
25 connect truncate,localhost,root,,;
26 TRUNCATE TABLE t1;
27 connection default;
28 INSERT INTO t2 SELECT * FROM t1;
29 SELECT COUNT(*) FROM t2;
30 COUNT(*)
31 4
32 COMMIT;
33 connection truncate;
34 # Reaping TRUNCATE TABLE
35 SELECT COUNT(*) FROM t1;
36 COUNT(*)
37 0
38 SELECT COUNT(*) FROM t2;
39 COUNT(*)
40 4
41 connection default;
42 include/show_binlog_events.inc
43 Log_name Pos Event_type Server_id End_log_pos Info
44 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
45 master-bin.000001 # Annotate_rows # # INSERT INTO t2 SELECT * FROM t1
46 master-bin.000001 # Table_map # # table_id: # (test.t2)
47 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
48 master-bin.000001 # Query # # COMMIT
49 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
50 master-bin.000001 # Annotate_rows # # INSERT INTO t2 SELECT * FROM t1
51 master-bin.000001 # Table_map # # table_id: # (test.t2)
52 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
53 master-bin.000001 # Query # # COMMIT
54 master-bin.000001 # Gtid # # GTID #-#-#
55 master-bin.000001 # Query # # use `test`; TRUNCATE TABLE t1
56 disconnect truncate;
57 DROP TABLE t1,t2;
58 SET BINLOG_FORMAT=STATEMENT;
59 RESET MASTER;
60 CREATE TABLE t1 (a INT) ENGINE=MyISAM;
61 CREATE TABLE t2 (a INT) ENGINE=MyISAM;
62 INSERT INTO t2 VALUES (1),(2),(3);
63 **** Truncate of empty table shall be logged
64 TRUNCATE TABLE t1;
65 TRUNCATE TABLE t2;
66 include/show_binlog_events.inc
67 Log_name Pos Event_type Server_id End_log_pos Info
68 master-bin.000001 # Gtid # # GTID #-#-#
69 master-bin.000001 # Query # # use `test`; TRUNCATE TABLE t1
70 master-bin.000001 # Gtid # # GTID #-#-#
71 master-bin.000001 # Query # # use `test`; TRUNCATE TABLE t2
72 DROP TABLE t1,t2;
73 #
74 # Bug#42643: InnoDB does not support replication of TRUNCATE TABLE
75 #
76 CREATE TABLE t1 (a INT) ENGINE=MyISAM;
77 CREATE TABLE t2 (a INT) ENGINE=MyISAM;
78 INSERT INTO t1 VALUES (1),(2);
79 BEGIN;
80 INSERT INTO t2 SELECT * FROM t1;
81 connect truncate,localhost,root,,;
82 TRUNCATE TABLE t1;
83 connection default;
84 INSERT INTO t2 SELECT * FROM t1;
85 SELECT COUNT(*) FROM t2;
86 COUNT(*)
87 4
88 COMMIT;
89 connection truncate;
90 # Reaping TRUNCATE TABLE
91 SELECT COUNT(*) FROM t1;
92 COUNT(*)
93 0
94 SELECT COUNT(*) FROM t2;
95 COUNT(*)
96 4
97 connection default;
98 include/show_binlog_events.inc
99 Log_name Pos Event_type Server_id End_log_pos Info
100 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
101 master-bin.000001 # Query # # use `test`; INSERT INTO t2 SELECT * FROM t1
102 master-bin.000001 # Query # # COMMIT
103 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
104 master-bin.000001 # Query # # use `test`; INSERT INTO t2 SELECT * FROM t1
105 master-bin.000001 # Query # # COMMIT
106 master-bin.000001 # Gtid # # GTID #-#-#
107 master-bin.000001 # Query # # use `test`; TRUNCATE TABLE t1
108 disconnect truncate;
109 DROP TABLE t1,t2;
110 SET BINLOG_FORMAT=@old_binlog_format;