Debian Codegraph @

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

raw
1 set binlog_format=mixed;
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 insert into my_bh_table(a)
27 select thread_id from performance_schema.threads;
28 insert into my_tx_table(a)
29 select id from information_schema.processlist;
30 Warnings:
31 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
32 insert into my_bh_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_tx_table(a)
37 select thread_id from mysql.general_log;
38 insert into my_bh_table(a)
39 select thread_id from mysql.general_log;
40 insert into my_tx_table(a)
41 select thread_id from mysql.slow_log;
42 insert into my_bh_table(a)
43 select thread_id from mysql.slow_log;
44 insert into my_tx_table(a)
45 select Relay_log_pos from mysql.slave_relay_log_info;
46 insert into my_bh_table(a)
47 select Relay_log_pos from mysql.slave_relay_log_info;
48 insert into my_tx_table(a)
49 select Master_log_pos from mysql.slave_master_info;
50 insert into my_bh_table(a)
51 select Master_log_pos from mysql.slave_master_info;
52 insert into my_tx_table(a)
53 select Relay_log_pos from mysql.slave_worker_info;
54 insert into my_bh_table(a)
55 select Relay_log_pos from mysql.slave_worker_info;
56 use test;
57 drop table if exists marker_multi_update;
58 Warnings:
59 Note 1051 Unknown table 'test.marker_multi_update'
60 use my_replicated_db;
61 update my_tx_table, performance_schema.setup_instruments
62 set my_tx_table.a = my_tx_table.a + 1,
63 performance_schema.setup_instruments.timed= 'NO';
64 update my_bh_table, performance_schema.setup_instruments
65 set my_bh_table.a = my_bh_table.a + 1,
66 performance_schema.setup_instruments.timed= 'NO';
67 use test;
68 drop table if exists marker_multi_delete;
69 Warnings:
70 Note 1051 Unknown table 'test.marker_multi_delete'
71 use my_replicated_db;
72 insert into performance_schema.setup_actors
73 values ('FOO', 'FOO', 'FOO', 'YES', 'YES');
74 delete my_tx_table.*, performance_schema.setup_actors.*
75 from my_tx_table, performance_schema.setup_actors
76 where my_tx_table.a != 1000
77 or performance_schema.setup_actors.role='FOO';
78 insert into performance_schema.setup_actors
79 values ('BAZ', 'BAZ', 'BAZ', 'YES', 'YES');
80 delete my_bh_table.*, performance_schema.setup_actors.*
81 from my_bh_table, performance_schema.setup_actors
82 where my_bh_table.a != 1000
83 or performance_schema.setup_actors.role='BAZ';
84 use test;
85 drop table if exists marker_end;
86 Warnings:
87 Note 1051 Unknown table 'test.marker_end'
88 drop database my_replicated_db;
89 include/show_binlog_events.inc
90 Log_name Pos Event_type Server_id End_log_pos Info
91 binlog.000001 # Query # # drop database if exists my_replicated_db
92 binlog.000001 # Query # # BEGIN
93 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'))
94 binlog.000001 # Xid # # COMMIT /* XID */
95 binlog.000001 # Query # # create database my_replicated_db
96 binlog.000001 # Query # # use `test`; create table my_replicated_db.my_tx_table(a bigint) engine = innodb
97 binlog.000001 # Query # # use `test`; create table my_replicated_db.my_bh_table(a bigint) engine = blackhole
98 binlog.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_start` /* generated by server */
99 binlog.000001 # Query # # BEGIN
100 binlog.000001 # Query # # use `my_replicated_db`; insert into my_tx_table(a)
101 values (1000), (2000), (3000)
102 binlog.000001 # Xid # # COMMIT /* XID */
103 binlog.000001 # Query # # BEGIN
104 binlog.000001 # Query # # use `my_replicated_db`; insert into my_bh_table(a)
105 values (1000), (2000), (3000)
106 binlog.000001 # Query # # COMMIT
107 binlog.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_insert_select` /* generated by server */
108 binlog.000001 # Query # # BEGIN
109 binlog.000001 # Table_map # # table_id: # (my_replicated_db.my_tx_table)
110 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
111 binlog.000001 # Xid # # COMMIT /* XID */
112 binlog.000001 # Query # # BEGIN
113 binlog.000001 # Table_map # # table_id: # (my_replicated_db.my_bh_table)
114 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
115 binlog.000001 # Query # # COMMIT
116 binlog.000001 # Query # # BEGIN
117 binlog.000001 # Query # # use `my_replicated_db`; insert into my_tx_table(a)
118 select id from information_schema.processlist
119 binlog.000001 # Xid # # COMMIT /* XID */
120 binlog.000001 # Query # # BEGIN
121 binlog.000001 # Query # # use `my_replicated_db`; insert into my_bh_table(a)
122 select id from information_schema.processlist
123 binlog.000001 # Query # # COMMIT
124 binlog.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_multi_update` /* generated by server */
125 binlog.000001 # Query # # BEGIN
126 binlog.000001 # Table_map # # table_id: # (my_replicated_db.my_tx_table)
127 binlog.000001 # Update_rows # # table_id: # flags: STMT_END_F
128 binlog.000001 # Xid # # COMMIT /* XID */
129 binlog.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_multi_delete` /* generated by server */
130 binlog.000001 # Query # # BEGIN
131 binlog.000001 # Table_map # # table_id: # (my_replicated_db.my_tx_table)
132 binlog.000001 # Delete_rows # # table_id: # flags: STMT_END_F
133 binlog.000001 # Xid # # COMMIT /* XID */
134 binlog.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_end` /* generated by server */
135 binlog.000001 # Query # # use `my_replicated_db`; DROP TABLE IF EXISTS `my_bh_table` /* generated by server */
136 binlog.000001 # Query # # drop database my_replicated_db
137 truncate table performance_schema.setup_actors;
138 insert into performance_schema.setup_actors values ('%', '%', '%', 'YES', 'YES');