Debian Codegraph @

mysql-test/suite/perfschema/r/binlog_edge_stmt_myisam.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_non_tx_table(a bigint) engine = myisam;
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_non_tx_table(a)
15 values (1000), (2000), (3000);
16 use test;
17 drop table if exists marker_insert_select;
18 Warnings:
19 Note 1051 Unknown table 'test.marker_insert_select'
20 use my_replicated_db;
21 insert into my_non_tx_table(a)
22 select thread_id from performance_schema.threads;
23 Warnings:
24 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.
25 insert into my_non_tx_table(a)
26 select id from information_schema.processlist;
27 Warnings:
28 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
29 insert into my_non_tx_table(a)
30 select thread_id from mysql.general_log;
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 replicas.
33 insert into my_non_tx_table(a)
34 select thread_id from mysql.slow_log;
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 replicas.
37 insert into my_non_tx_table(a)
38 select Relay_log_pos from mysql.slave_relay_log_info;
39 Warnings:
40 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.
41 insert into my_non_tx_table(a)
42 select Master_log_pos from mysql.slave_master_info;
43 Warnings:
44 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.
45 insert into my_non_tx_table(a)
46 select Relay_log_pos from mysql.slave_worker_info;
47 Warnings:
48 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.
49 use test;
50 drop table if exists marker_multi_update;
51 Warnings:
52 Note 1051 Unknown table 'test.marker_multi_update'
53 use my_replicated_db;
54 update my_non_tx_table, performance_schema.setup_instruments
55 set my_non_tx_table.a = my_non_tx_table.a + 1,
56 performance_schema.setup_instruments.timed= 'NO';
57 use test;
58 drop table if exists marker_multi_delete;
59 Warnings:
60 Note 1051 Unknown table 'test.marker_multi_delete'
61 use my_replicated_db;
62 insert into performance_schema.setup_actors
63 values ('BAR', 'BAR', 'BAR', 'YES', 'YES');
64 delete my_non_tx_table.*, performance_schema.setup_actors.*
65 from my_non_tx_table, performance_schema.setup_actors
66 where my_non_tx_table.a != 1000
67 or performance_schema.setup_actors.role='BAR';
68 use test;
69 drop table if exists marker_end;
70 Warnings:
71 Note 1051 Unknown table 'test.marker_end'
72 drop database my_replicated_db;
73 include/show_binlog_events.inc
74 Log_name Pos Event_type Server_id End_log_pos Info
75 binlog.000001 # Query # # drop database if exists my_replicated_db
76 binlog.000001 # Query # # BEGIN
77 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'))
78 binlog.000001 # Xid # # COMMIT /* XID */
79 binlog.000001 # Query # # create database my_replicated_db
80 binlog.000001 # Query # # use `test`; create table my_replicated_db.my_non_tx_table(a bigint) engine = myisam
81 binlog.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_start` /* generated by server */
82 binlog.000001 # Query # # BEGIN
83 binlog.000001 # Query # # use `my_replicated_db`; insert into my_non_tx_table(a)
84 values (1000), (2000), (3000)
85 binlog.000001 # Query # # COMMIT
86 binlog.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_insert_select` /* generated by server */
87 binlog.000001 # Query # # BEGIN
88 binlog.000001 # Query # # use `my_replicated_db`; insert into my_non_tx_table(a)
89 select thread_id from performance_schema.threads
90 binlog.000001 # Query # # COMMIT
91 binlog.000001 # Query # # BEGIN
92 binlog.000001 # Query # # use `my_replicated_db`; insert into my_non_tx_table(a)
93 select id from information_schema.processlist
94 binlog.000001 # Query # # COMMIT
95 binlog.000001 # Query # # BEGIN
96 binlog.000001 # Query # # use `my_replicated_db`; insert into my_non_tx_table(a)
97 select thread_id from mysql.general_log
98 binlog.000001 # Query # # COMMIT
99 binlog.000001 # Query # # BEGIN
100 binlog.000001 # Query # # use `my_replicated_db`; insert into my_non_tx_table(a)
101 select thread_id from mysql.slow_log
102 binlog.000001 # Query # # COMMIT
103 binlog.000001 # Query # # BEGIN
104 binlog.000001 # Query # # use `my_replicated_db`; insert into my_non_tx_table(a)
105 select Relay_log_pos from mysql.slave_relay_log_info
106 binlog.000001 # Query # # COMMIT
107 binlog.000001 # Query # # BEGIN
108 binlog.000001 # Query # # use `my_replicated_db`; insert into my_non_tx_table(a)
109 select Master_log_pos from mysql.slave_master_info
110 binlog.000001 # Query # # COMMIT
111 binlog.000001 # Query # # BEGIN
112 binlog.000001 # Query # # use `my_replicated_db`; insert into my_non_tx_table(a)
113 select Relay_log_pos from mysql.slave_worker_info
114 binlog.000001 # Query # # COMMIT
115 binlog.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_multi_update` /* generated by server */
116 binlog.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_multi_delete` /* generated by server */
117 binlog.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_end` /* generated by server */
118 binlog.000001 # Query # # use `my_replicated_db`; DROP TABLE IF EXISTS `my_non_tx_table` /* generated by server */
119 binlog.000001 # Query # # drop database my_replicated_db
120 truncate table performance_schema.setup_actors;
121 insert into performance_schema.setup_actors values ('%', '%', '%', 'YES', 'YES');