Debian Codegraph @

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

raw
1 set binlog_format=statement;
2 Warnings:
3 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
4 RESET MASTER;
5 drop database if exists my_replicated_db;
6 call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");
7 create database my_replicated_db;
8 create table my_replicated_db.my_tx_table(a bigint) engine = innodb;
9 create table my_replicated_db.my_bh_table(a bigint) engine = blackhole;
10 use test;
11 drop table if exists marker_start;
12 Warnings:
13 Note 1051 Unknown table 'test.marker_start'
14 use my_replicated_db;
15 insert into my_tx_table(a)
16 values (1000), (2000), (3000);
17 insert into my_bh_table(a)
18 values (1000), (2000), (3000);
19 use test;
20 drop table if exists marker_insert_select;
21 Warnings:
22 Note 1051 Unknown table 'test.marker_insert_select'
23 use my_replicated_db;
24 insert into my_tx_table(a)
25 select thread_id from performance_schema.threads;
26 Warnings:
27 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 replicas.
28 insert into my_bh_table(a)
29 select thread_id from performance_schema.threads;
30 Warnings:
31 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 replicas.
32 insert into my_tx_table(a)
33 select id from information_schema.processlist;
34 Warnings:
35 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
36 insert into my_bh_table(a)
37 select id from information_schema.processlist;
38 Warnings:
39 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
40 insert into my_tx_table(a)
41 select thread_id from mysql.general_log;
42 Warnings:
43 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 replicas.
44 insert into my_bh_table(a)
45 select thread_id from mysql.general_log;
46 Warnings:
47 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 replicas.
48 insert into my_tx_table(a)
49 select thread_id from mysql.slow_log;
50 Warnings:
51 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 replicas.
52 insert into my_bh_table(a)
53 select thread_id from mysql.slow_log;
54 Warnings:
55 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 replicas.
56 insert into my_tx_table(a)
57 select Relay_log_pos from mysql.slave_relay_log_info;
58 Warnings:
59 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 replicas.
60 insert into my_bh_table(a)
61 select Relay_log_pos from mysql.slave_relay_log_info;
62 Warnings:
63 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 replicas.
64 insert into my_tx_table(a)
65 select Master_log_pos from mysql.slave_master_info;
66 Warnings:
67 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 replicas.
68 insert into my_bh_table(a)
69 select Master_log_pos from mysql.slave_master_info;
70 Warnings:
71 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 replicas.
72 insert into my_tx_table(a)
73 select Relay_log_pos from mysql.slave_worker_info;
74 Warnings:
75 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 replicas.
76 insert into my_bh_table(a)
77 select Relay_log_pos from mysql.slave_worker_info;
78 Warnings:
79 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 replicas.
80 use test;
81 drop table if exists marker_multi_update;
82 Warnings:
83 Note 1051 Unknown table 'test.marker_multi_update'
84 use my_replicated_db;
85 update my_tx_table, performance_schema.setup_instruments
86 set my_tx_table.a = my_tx_table.a + 1,
87 performance_schema.setup_instruments.timed= 'NO';
88 update my_bh_table, performance_schema.setup_instruments
89 set my_bh_table.a = my_bh_table.a + 1,
90 performance_schema.setup_instruments.timed= 'NO';
91 use test;
92 drop table if exists marker_multi_delete;
93 Warnings:
94 Note 1051 Unknown table 'test.marker_multi_delete'
95 use my_replicated_db;
96 insert into performance_schema.setup_actors
97 values ('FOO', 'FOO', 'FOO', 'YES', 'YES');
98 delete my_tx_table.*, performance_schema.setup_actors.*
99 from my_tx_table, performance_schema.setup_actors
100 where my_tx_table.a != 1000
101 or performance_schema.setup_actors.role='FOO';
102 insert into performance_schema.setup_actors
103 values ('BAZ', 'BAZ', 'BAZ', 'YES', 'YES');
104 delete my_bh_table.*, performance_schema.setup_actors.*
105 from my_bh_table, performance_schema.setup_actors
106 where my_bh_table.a != 1000
107 or performance_schema.setup_actors.role='BAZ';
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 binlog.000001 # Query # # drop database if exists my_replicated_db
116 binlog.000001 # Query # # BEGIN
117 binlog.000001 # Query # # use `mtr`; INSERT INTO test_suppressions (pattern) VALUES ( NAME_CONST('pattern',_utf8mb4'Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT' COLLATE 'utf8mb4_0900_ai_ci'))
118 binlog.000001 # Xid # # COMMIT /* XID */
119 binlog.000001 # Query # # create database my_replicated_db
120 binlog.000001 # Query # # use `test`; create table my_replicated_db.my_tx_table(a bigint) engine = innodb
121 binlog.000001 # Query # # use `test`; create table my_replicated_db.my_bh_table(a bigint) engine = blackhole
122 binlog.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_start` /* generated by server */
123 binlog.000001 # Query # # BEGIN
124 binlog.000001 # Query # # use `my_replicated_db`; insert into my_tx_table(a)
125 values (1000), (2000), (3000)
126 binlog.000001 # Xid # # COMMIT /* XID */
127 binlog.000001 # Query # # BEGIN
128 binlog.000001 # Query # # use `my_replicated_db`; insert into my_bh_table(a)
129 values (1000), (2000), (3000)
130 binlog.000001 # Query # # COMMIT
131 binlog.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_insert_select` /* generated by server */
132 binlog.000001 # Query # # BEGIN
133 binlog.000001 # Query # # use `my_replicated_db`; insert into my_tx_table(a)
134 select thread_id from performance_schema.threads
135 binlog.000001 # Xid # # COMMIT /* XID */
136 binlog.000001 # Query # # BEGIN
137 binlog.000001 # Query # # use `my_replicated_db`; insert into my_bh_table(a)
138 select thread_id from performance_schema.threads
139 binlog.000001 # Query # # COMMIT
140 binlog.000001 # Query # # BEGIN
141 binlog.000001 # Query # # use `my_replicated_db`; insert into my_tx_table(a)
142 select id from information_schema.processlist
143 binlog.000001 # Xid # # COMMIT /* XID */
144 binlog.000001 # Query # # BEGIN
145 binlog.000001 # Query # # use `my_replicated_db`; insert into my_bh_table(a)
146 select id from information_schema.processlist
147 binlog.000001 # Query # # COMMIT
148 binlog.000001 # Query # # BEGIN
149 binlog.000001 # Query # # use `my_replicated_db`; insert into my_tx_table(a)
150 select thread_id from mysql.general_log
151 binlog.000001 # Query # # COMMIT
152 binlog.000001 # Query # # BEGIN
153 binlog.000001 # Query # # use `my_replicated_db`; insert into my_bh_table(a)
154 select thread_id from mysql.general_log
155 binlog.000001 # Query # # COMMIT
156 binlog.000001 # Query # # BEGIN
157 binlog.000001 # Query # # use `my_replicated_db`; insert into my_tx_table(a)
158 select thread_id from mysql.slow_log
159 binlog.000001 # Query # # COMMIT
160 binlog.000001 # Query # # BEGIN
161 binlog.000001 # Query # # use `my_replicated_db`; insert into my_bh_table(a)
162 select thread_id from mysql.slow_log
163 binlog.000001 # Query # # COMMIT
164 binlog.000001 # Query # # BEGIN
165 binlog.000001 # Query # # use `my_replicated_db`; insert into my_tx_table(a)
166 select Relay_log_pos from mysql.slave_relay_log_info
167 binlog.000001 # Query # # COMMIT
168 binlog.000001 # Query # # BEGIN
169 binlog.000001 # Query # # use `my_replicated_db`; insert into my_bh_table(a)
170 select Relay_log_pos from mysql.slave_relay_log_info
171 binlog.000001 # Query # # COMMIT
172 binlog.000001 # Query # # BEGIN
173 binlog.000001 # Query # # use `my_replicated_db`; insert into my_tx_table(a)
174 select Master_log_pos from mysql.slave_master_info
175 binlog.000001 # Query # # COMMIT
176 binlog.000001 # Query # # BEGIN
177 binlog.000001 # Query # # use `my_replicated_db`; insert into my_bh_table(a)
178 select Master_log_pos from mysql.slave_master_info
179 binlog.000001 # Query # # COMMIT
180 binlog.000001 # Query # # BEGIN
181 binlog.000001 # Query # # use `my_replicated_db`; insert into my_tx_table(a)
182 select Relay_log_pos from mysql.slave_worker_info
183 binlog.000001 # Query # # COMMIT
184 binlog.000001 # Query # # BEGIN
185 binlog.000001 # Query # # use `my_replicated_db`; insert into my_bh_table(a)
186 select Relay_log_pos from mysql.slave_worker_info
187 binlog.000001 # Query # # COMMIT
188 binlog.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_multi_update` /* generated by server */
189 binlog.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_multi_delete` /* generated by server */
190 binlog.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_end` /* generated by server */
191 binlog.000001 # Query # # use `my_replicated_db`; DROP TABLE IF EXISTS `my_bh_table` /* generated by server */
192 binlog.000001 # Query # # drop database my_replicated_db
193 truncate table performance_schema.setup_actors;
194 insert into performance_schema.setup_actors values ('%', '%', '%', 'YES', 'YES');