Debian Codegraph @

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

raw
1 set binlog_format=statement;
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 Warnings:
28 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on slaves
29 insert into my_non_tx_table(a)
30 select thread_id from performance_schema.threads;
31 Warnings:
32 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on slaves
33 insert into my_bh_table(a)
34 select thread_id from performance_schema.threads;
35 Warnings:
36 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on slaves
37 insert into my_tx_table(a)
38 select id from information_schema.processlist;
39 insert into my_non_tx_table(a)
40 select id from information_schema.processlist;
41 insert into my_bh_table(a)
42 select id from information_schema.processlist;
43 insert into my_tx_table(a)
44 select thread_id from mysql.general_log;
45 Warnings:
46 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on slaves
47 insert into my_non_tx_table(a)
48 select thread_id from mysql.general_log;
49 Warnings:
50 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on slaves
51 insert into my_bh_table(a)
52 select thread_id from mysql.general_log;
53 Warnings:
54 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on slaves
55 insert into my_tx_table(a)
56 select thread_id from mysql.slow_log;
57 Warnings:
58 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on slaves
59 insert into my_non_tx_table(a)
60 select thread_id from mysql.slow_log;
61 Warnings:
62 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on slaves
63 insert into my_bh_table(a)
64 select thread_id from mysql.slow_log;
65 Warnings:
66 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on slaves
67 insert into my_tx_table(a)
68 select Relay_log_pos from mysql.slave_relay_log_info;
69 Warnings:
70 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on slaves
71 insert into my_non_tx_table(a)
72 select Relay_log_pos from mysql.slave_relay_log_info;
73 Warnings:
74 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on slaves
75 insert into my_bh_table(a)
76 select Relay_log_pos from mysql.slave_relay_log_info;
77 Warnings:
78 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on slaves
79 insert into my_tx_table(a)
80 select Master_log_pos from mysql.slave_master_info;
81 Warnings:
82 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on slaves
83 insert into my_non_tx_table(a)
84 select Master_log_pos from mysql.slave_master_info;
85 Warnings:
86 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on slaves
87 insert into my_bh_table(a)
88 select Master_log_pos from mysql.slave_master_info;
89 Warnings:
90 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on slaves
91 insert into my_tx_table(a)
92 select Relay_log_pos from mysql.slave_worker_info;
93 Warnings:
94 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on slaves
95 insert into my_non_tx_table(a)
96 select Relay_log_pos from mysql.slave_worker_info;
97 Warnings:
98 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on slaves
99 insert into my_bh_table(a)
100 select Relay_log_pos from mysql.slave_worker_info;
101 Warnings:
102 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on slaves
103 use test;
104 drop table if exists marker_multi_update;
105 Warnings:
106 Note 1051 Unknown table 'test.marker_multi_update'
107 use my_replicated_db;
108 update my_tx_table, performance_schema.setup_instruments
109 set my_tx_table.a = my_tx_table.a + 1,
110 performance_schema.setup_instruments.timed= 'NO';
111 update my_non_tx_table, performance_schema.setup_instruments
112 set my_non_tx_table.a = my_non_tx_table.a + 1,
113 performance_schema.setup_instruments.timed= 'NO';
114 update my_bh_table, performance_schema.setup_instruments
115 set my_bh_table.a = my_bh_table.a + 1,
116 performance_schema.setup_instruments.timed= 'NO';
117 use test;
118 drop table if exists marker_multi_delete;
119 Warnings:
120 Note 1051 Unknown table 'test.marker_multi_delete'
121 use my_replicated_db;
122 insert into performance_schema.setup_actors
123 values ('FOO', 'FOO', 'FOO', 'YES', 'YES');
124 delete my_tx_table.*, performance_schema.setup_actors.*
125 from my_tx_table, performance_schema.setup_actors
126 where my_tx_table.a != 1000
127 or performance_schema.setup_actors.role='FOO';
128 insert into performance_schema.setup_actors
129 values ('BAR', 'BAR', 'BAR', 'YES', 'YES');
130 delete my_non_tx_table.*, performance_schema.setup_actors.*
131 from my_non_tx_table, performance_schema.setup_actors
132 where my_non_tx_table.a != 1000
133 or performance_schema.setup_actors.role='BAR';
134 insert into performance_schema.setup_actors
135 values ('BAZ', 'BAZ', 'BAZ', 'YES', 'YES');
136 delete my_bh_table.*, performance_schema.setup_actors.*
137 from my_bh_table, performance_schema.setup_actors
138 where my_bh_table.a != 1000
139 or performance_schema.setup_actors.role='BAZ';
140 use test;
141 drop table if exists marker_end;
142 Warnings:
143 Note 1051 Unknown table 'test.marker_end'
144 drop database my_replicated_db;
145 include/show_binlog_events.inc
146 Log_name Pos Event_type Server_id End_log_pos Info
147 master-bin.000001 # Query # # drop database if exists my_replicated_db
148 master-bin.000001 # Query # # BEGIN
149 master-bin.000001 # Query # # use `mtr`; INSERT INTO test_suppressions (pattern) VALUES ( NAME_CONST('pattern',_latin1'Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT' COLLATE 'latin1_swedish_ci'))
150 master-bin.000001 # Query # # COMMIT
151 master-bin.000001 # Query # # create database my_replicated_db
152 master-bin.000001 # Query # # use `test`; create table my_replicated_db.my_tx_table(a bigint) engine = innodb
153 master-bin.000001 # Query # # use `test`; create table my_replicated_db.my_non_tx_table(a bigint) engine = myisam
154 master-bin.000001 # Query # # use `test`; create table my_replicated_db.my_bh_table(a bigint) engine = blackhole
155 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_start` /* generated by server */
156 master-bin.000001 # Query # # BEGIN
157 master-bin.000001 # Query # # use `my_replicated_db`; insert into my_tx_table(a)
158 values (1000), (2000), (3000)
159 master-bin.000001 # Xid # # COMMIT /* XID */
160 master-bin.000001 # Query # # BEGIN
161 master-bin.000001 # Query # # use `my_replicated_db`; insert into my_non_tx_table(a)
162 values (1000), (2000), (3000)
163 master-bin.000001 # Query # # COMMIT
164 master-bin.000001 # Query # # BEGIN
165 master-bin.000001 # Query # # use `my_replicated_db`; insert into my_bh_table(a)
166 values (1000), (2000), (3000)
167 master-bin.000001 # Query # # COMMIT
168 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_insert_select` /* generated by server */
169 master-bin.000001 # Query # # BEGIN
170 master-bin.000001 # Query # # use `my_replicated_db`; insert into my_tx_table(a)
171 select thread_id from performance_schema.threads
172 master-bin.000001 # Xid # # COMMIT /* XID */
173 master-bin.000001 # Query # # BEGIN
174 master-bin.000001 # Query # # use `my_replicated_db`; insert into my_non_tx_table(a)
175 select thread_id from performance_schema.threads
176 master-bin.000001 # Query # # COMMIT
177 master-bin.000001 # Query # # BEGIN
178 master-bin.000001 # Query # # use `my_replicated_db`; insert into my_bh_table(a)
179 select thread_id from performance_schema.threads
180 master-bin.000001 # Query # # COMMIT
181 master-bin.000001 # Query # # BEGIN
182 master-bin.000001 # Query # # use `my_replicated_db`; insert into my_tx_table(a)
183 select id from information_schema.processlist
184 master-bin.000001 # Xid # # COMMIT /* XID */
185 master-bin.000001 # Query # # BEGIN
186 master-bin.000001 # Query # # use `my_replicated_db`; insert into my_non_tx_table(a)
187 select id from information_schema.processlist
188 master-bin.000001 # Query # # COMMIT
189 master-bin.000001 # Query # # BEGIN
190 master-bin.000001 # Query # # use `my_replicated_db`; insert into my_bh_table(a)
191 select id from information_schema.processlist
192 master-bin.000001 # Query # # COMMIT
193 master-bin.000001 # Query # # BEGIN
194 master-bin.000001 # Query # # use `my_replicated_db`; insert into my_tx_table(a)
195 select thread_id from mysql.general_log
196 master-bin.000001 # Query # # COMMIT
197 master-bin.000001 # Query # # BEGIN
198 master-bin.000001 # Query # # use `my_replicated_db`; insert into my_non_tx_table(a)
199 select thread_id from mysql.general_log
200 master-bin.000001 # Query # # COMMIT
201 master-bin.000001 # Query # # BEGIN
202 master-bin.000001 # Query # # use `my_replicated_db`; insert into my_bh_table(a)
203 select thread_id from mysql.general_log
204 master-bin.000001 # Query # # COMMIT
205 master-bin.000001 # Query # # BEGIN
206 master-bin.000001 # Query # # use `my_replicated_db`; insert into my_tx_table(a)
207 select thread_id from mysql.slow_log
208 master-bin.000001 # Query # # COMMIT
209 master-bin.000001 # Query # # BEGIN
210 master-bin.000001 # Query # # use `my_replicated_db`; insert into my_non_tx_table(a)
211 select thread_id from mysql.slow_log
212 master-bin.000001 # Query # # COMMIT
213 master-bin.000001 # Query # # BEGIN
214 master-bin.000001 # Query # # use `my_replicated_db`; insert into my_bh_table(a)
215 select thread_id from mysql.slow_log
216 master-bin.000001 # Query # # COMMIT
217 master-bin.000001 # Query # # BEGIN
218 master-bin.000001 # Query # # use `my_replicated_db`; insert into my_tx_table(a)
219 select Relay_log_pos from mysql.slave_relay_log_info
220 master-bin.000001 # Query # # COMMIT
221 master-bin.000001 # Query # # BEGIN
222 master-bin.000001 # Query # # use `my_replicated_db`; insert into my_non_tx_table(a)
223 select Relay_log_pos from mysql.slave_relay_log_info
224 master-bin.000001 # Query # # COMMIT
225 master-bin.000001 # Query # # BEGIN
226 master-bin.000001 # Query # # use `my_replicated_db`; insert into my_bh_table(a)
227 select Relay_log_pos from mysql.slave_relay_log_info
228 master-bin.000001 # Query # # COMMIT
229 master-bin.000001 # Query # # BEGIN
230 master-bin.000001 # Query # # use `my_replicated_db`; insert into my_tx_table(a)
231 select Master_log_pos from mysql.slave_master_info
232 master-bin.000001 # Query # # COMMIT
233 master-bin.000001 # Query # # BEGIN
234 master-bin.000001 # Query # # use `my_replicated_db`; insert into my_non_tx_table(a)
235 select Master_log_pos from mysql.slave_master_info
236 master-bin.000001 # Query # # COMMIT
237 master-bin.000001 # Query # # BEGIN
238 master-bin.000001 # Query # # use `my_replicated_db`; insert into my_bh_table(a)
239 select Master_log_pos from mysql.slave_master_info
240 master-bin.000001 # Query # # COMMIT
241 master-bin.000001 # Query # # BEGIN
242 master-bin.000001 # Query # # use `my_replicated_db`; insert into my_tx_table(a)
243 select Relay_log_pos from mysql.slave_worker_info
244 master-bin.000001 # Query # # COMMIT
245 master-bin.000001 # Query # # BEGIN
246 master-bin.000001 # Query # # use `my_replicated_db`; insert into my_non_tx_table(a)
247 select Relay_log_pos from mysql.slave_worker_info
248 master-bin.000001 # Query # # COMMIT
249 master-bin.000001 # Query # # BEGIN
250 master-bin.000001 # Query # # use `my_replicated_db`; insert into my_bh_table(a)
251 select Relay_log_pos from mysql.slave_worker_info
252 master-bin.000001 # Query # # COMMIT
253 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_multi_update` /* generated by server */
254 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_multi_delete` /* generated by server */
255 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_end` /* generated by server */
256 master-bin.000001 # Query # # drop database my_replicated_db
257 truncate table performance_schema.setup_actors;
258 insert into performance_schema.setup_actors values ('%', '%', '%', 'YES', 'YES');