Debian Codegraph @

mysql-test/suite/perfschema/r/binlog_edge_row.result

raw
1 set binlog_format=row;
2 RESET MASTER;
3 drop database if exists my_replicated_db;
4 call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");
5 create database my_replicated_db;
6 create table my_replicated_db.my_tx_table(a bigint) engine = innodb;
7 create table my_replicated_db.my_non_tx_table(a bigint) engine = myisam;
8 create table my_replicated_db.my_bh_table(a bigint) engine = blackhole;
9 use test;
10 drop table if exists marker_start;
11 Warnings:
12 Note 1051 Unknown table 'test.marker_start'
13 use my_replicated_db;
14 insert into my_tx_table(a)
15 values (1000), (2000), (3000);
16 insert into my_non_tx_table(a)
17 values (1000), (2000), (3000);
18 insert into my_bh_table(a)
19 values (1000), (2000), (3000);
20 use test;
21 drop table if exists marker_insert_select;
22 Warnings:
23 Note 1051 Unknown table 'test.marker_insert_select'
24 use my_replicated_db;
25 insert into my_tx_table(a)
26 select thread_id from performance_schema.threads;
27 insert into my_non_tx_table(a)
28 select thread_id from performance_schema.threads;
29 insert into my_bh_table(a)
30 select thread_id from performance_schema.threads;
31 insert into my_tx_table(a)
32 select id from information_schema.processlist;
33 insert into my_non_tx_table(a)
34 select id from information_schema.processlist;
35 insert into my_bh_table(a)
36 select id from information_schema.processlist;
37 insert into my_tx_table(a)
38 select thread_id from mysql.general_log;
39 insert into my_non_tx_table(a)
40 select thread_id from mysql.general_log;
41 insert into my_bh_table(a)
42 select thread_id from mysql.general_log;
43 insert into my_tx_table(a)
44 select thread_id from mysql.slow_log;
45 insert into my_non_tx_table(a)
46 select thread_id from mysql.slow_log;
47 insert into my_bh_table(a)
48 select thread_id from mysql.slow_log;
49 insert into my_tx_table(a)
50 select Relay_log_pos from mysql.slave_relay_log_info;
51 insert into my_non_tx_table(a)
52 select Relay_log_pos from mysql.slave_relay_log_info;
53 insert into my_bh_table(a)
54 select Relay_log_pos from mysql.slave_relay_log_info;
55 insert into my_tx_table(a)
56 select Master_log_pos from mysql.slave_master_info;
57 insert into my_non_tx_table(a)
58 select Master_log_pos from mysql.slave_master_info;
59 insert into my_bh_table(a)
60 select Master_log_pos from mysql.slave_master_info;
61 insert into my_tx_table(a)
62 select Relay_log_pos from mysql.slave_worker_info;
63 insert into my_non_tx_table(a)
64 select Relay_log_pos from mysql.slave_worker_info;
65 insert into my_bh_table(a)
66 select Relay_log_pos from mysql.slave_worker_info;
67 use test;
68 drop table if exists marker_multi_update;
69 Warnings:
70 Note 1051 Unknown table 'test.marker_multi_update'
71 use my_replicated_db;
72 update my_tx_table, performance_schema.setup_instruments
73 set my_tx_table.a = my_tx_table.a + 1,
74 performance_schema.setup_instruments.timed= 'NO';
75 update my_non_tx_table, performance_schema.setup_instruments
76 set my_non_tx_table.a = my_non_tx_table.a + 1,
77 performance_schema.setup_instruments.timed= 'NO';
78 update my_bh_table, performance_schema.setup_instruments
79 set my_bh_table.a = my_bh_table.a + 1,
80 performance_schema.setup_instruments.timed= 'NO';
81 Warnings:
82 Warning 1870 Row events are not logged for UPDATE statements that modify BLACKHOLE tables in row format. Table(s): 'my_bh_table.'
83 use test;
84 drop table if exists marker_multi_delete;
85 Warnings:
86 Note 1051 Unknown table 'test.marker_multi_delete'
87 use my_replicated_db;
88 insert into performance_schema.setup_actors
89 values ('FOO', 'FOO', 'FOO', 'YES', 'YES');
90 delete my_tx_table.*, performance_schema.setup_actors.*
91 from my_tx_table, performance_schema.setup_actors
92 where my_tx_table.a != 1000
93 or performance_schema.setup_actors.role='FOO';
94 insert into performance_schema.setup_actors
95 values ('BAR', 'BAR', 'BAR', 'YES', 'YES');
96 delete my_non_tx_table.*, performance_schema.setup_actors.*
97 from my_non_tx_table, performance_schema.setup_actors
98 where my_non_tx_table.a != 1000
99 or performance_schema.setup_actors.role='BAR';
100 insert into performance_schema.setup_actors
101 values ('BAZ', 'BAZ', 'BAZ', 'YES', 'YES');
102 delete my_bh_table.*, performance_schema.setup_actors.*
103 from my_bh_table, performance_schema.setup_actors
104 where my_bh_table.a != 1000
105 or performance_schema.setup_actors.role='BAZ';
106 Warnings:
107 Warning 1870 Row events are not logged for DELETE statements that modify BLACKHOLE tables in row format. Table(s): 'my_bh_table.'
108 use test;
109 drop table if exists marker_end;
110 Warnings:
111 Note 1051 Unknown table 'test.marker_end'
112 drop database my_replicated_db;
113 include/show_binlog_events.inc
114 Log_name Pos Event_type Server_id End_log_pos Info
115 master-bin.000001 # Query # # drop database if exists my_replicated_db
116 master-bin.000001 # Query # # BEGIN
117 master-bin.000001 # Table_map # # table_id: # (mtr.test_suppressions)
118 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
119 master-bin.000001 # Query # # COMMIT
120 master-bin.000001 # Query # # create database my_replicated_db
121 master-bin.000001 # Query # # use `test`; create table my_replicated_db.my_tx_table(a bigint) engine = innodb
122 master-bin.000001 # Query # # use `test`; create table my_replicated_db.my_non_tx_table(a bigint) engine = myisam
123 master-bin.000001 # Query # # use `test`; create table my_replicated_db.my_bh_table(a bigint) engine = blackhole
124 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_start` /* generated by server */
125 master-bin.000001 # Query # # BEGIN
126 master-bin.000001 # Table_map # # table_id: # (my_replicated_db.my_tx_table)
127 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
128 master-bin.000001 # Xid # # COMMIT /* XID */
129 master-bin.000001 # Query # # BEGIN
130 master-bin.000001 # Table_map # # table_id: # (my_replicated_db.my_non_tx_table)
131 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
132 master-bin.000001 # Query # # COMMIT
133 master-bin.000001 # Query # # BEGIN
134 master-bin.000001 # Table_map # # table_id: # (my_replicated_db.my_bh_table)
135 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
136 master-bin.000001 # Query # # COMMIT
137 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_insert_select` /* generated by server */
138 master-bin.000001 # Query # # BEGIN
139 master-bin.000001 # Table_map # # table_id: # (my_replicated_db.my_tx_table)
140 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
141 master-bin.000001 # Xid # # COMMIT /* XID */
142 master-bin.000001 # Query # # BEGIN
143 master-bin.000001 # Table_map # # table_id: # (my_replicated_db.my_non_tx_table)
144 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
145 master-bin.000001 # Query # # COMMIT
146 master-bin.000001 # Query # # BEGIN
147 master-bin.000001 # Table_map # # table_id: # (my_replicated_db.my_bh_table)
148 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
149 master-bin.000001 # Query # # COMMIT
150 master-bin.000001 # Query # # BEGIN
151 master-bin.000001 # Table_map # # table_id: # (my_replicated_db.my_tx_table)
152 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
153 master-bin.000001 # Xid # # COMMIT /* XID */
154 master-bin.000001 # Query # # BEGIN
155 master-bin.000001 # Table_map # # table_id: # (my_replicated_db.my_non_tx_table)
156 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
157 master-bin.000001 # Query # # COMMIT
158 master-bin.000001 # Query # # BEGIN
159 master-bin.000001 # Table_map # # table_id: # (my_replicated_db.my_bh_table)
160 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
161 master-bin.000001 # Query # # COMMIT
162 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_multi_update` /* generated by server */
163 master-bin.000001 # Query # # BEGIN
164 master-bin.000001 # Table_map # # table_id: # (my_replicated_db.my_tx_table)
165 master-bin.000001 # Update_rows # # table_id: # flags: STMT_END_F
166 master-bin.000001 # Xid # # COMMIT /* XID */
167 master-bin.000001 # Query # # BEGIN
168 master-bin.000001 # Table_map # # table_id: # (my_replicated_db.my_non_tx_table)
169 master-bin.000001 # Update_rows # # table_id: # flags: STMT_END_F
170 master-bin.000001 # Query # # COMMIT
171 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_multi_delete` /* generated by server */
172 master-bin.000001 # Query # # BEGIN
173 master-bin.000001 # Table_map # # table_id: # (my_replicated_db.my_tx_table)
174 master-bin.000001 # Delete_rows # # table_id: # flags: STMT_END_F
175 master-bin.000001 # Xid # # COMMIT /* XID */
176 master-bin.000001 # Query # # BEGIN
177 master-bin.000001 # Table_map # # table_id: # (my_replicated_db.my_non_tx_table)
178 master-bin.000001 # Delete_rows # # table_id: # flags: STMT_END_F
179 master-bin.000001 # Query # # COMMIT
180 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_end` /* generated by server */
181 master-bin.000001 # Query # # drop database my_replicated_db
182 truncate table performance_schema.setup_actors;
183 insert into performance_schema.setup_actors values ('%', '%', '%', 'YES', 'YES');