Debian Codegraph @

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

raw
1 set binlog_format='row';
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 Warnings:
68 Warning 1870 Row events are not logged for UPDATE statements that modify BLACKHOLE tables in row format. Table(s): 'my_bh_table.'
69 use test;
70 drop table if exists marker_multi_delete;
71 Warnings:
72 Note 1051 Unknown table 'test.marker_multi_delete'
73 use my_replicated_db;
74 insert into performance_schema.setup_actors
75 values ('FOO', 'FOO', 'FOO', 'YES', 'YES');
76 delete my_tx_table.*, performance_schema.setup_actors.*
77 from my_tx_table, performance_schema.setup_actors
78 where my_tx_table.a != 1000
79 or performance_schema.setup_actors.role='FOO';
80 insert into performance_schema.setup_actors
81 values ('BAZ', 'BAZ', 'BAZ', 'YES', 'YES');
82 delete my_bh_table.*, performance_schema.setup_actors.*
83 from my_bh_table, performance_schema.setup_actors
84 where my_bh_table.a != 1000
85 or performance_schema.setup_actors.role='BAZ';
86 Warnings:
87 Warning 1870 Row events are not logged for DELETE statements that modify BLACKHOLE tables in row format. Table(s): 'my_bh_table.'
88 use test;
89 drop table if exists marker_end;
90 Warnings:
91 Note 1051 Unknown table 'test.marker_end'
92 drop database my_replicated_db;
93 include/show_binlog_events.inc
94 Log_name Pos Event_type Server_id End_log_pos Info
95 binlog.000001 # Query # # drop database if exists my_replicated_db
96 binlog.000001 # Query # # BEGIN
97 binlog.000001 # Table_map # # table_id: # (mtr.test_suppressions)
98 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
99 binlog.000001 # Xid # # COMMIT /* XID */
100 binlog.000001 # Query # # create database my_replicated_db
101 binlog.000001 # Query # # use `test`; create table my_replicated_db.my_tx_table(a bigint) engine = innodb
102 binlog.000001 # Query # # use `test`; create table my_replicated_db.my_bh_table(a bigint) engine = blackhole
103 binlog.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_start` /* generated by server */
104 binlog.000001 # Query # # BEGIN
105 binlog.000001 # Table_map # # table_id: # (my_replicated_db.my_tx_table)
106 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
107 binlog.000001 # Xid # # COMMIT /* XID */
108 binlog.000001 # Query # # BEGIN
109 binlog.000001 # Table_map # # table_id: # (my_replicated_db.my_bh_table)
110 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
111 binlog.000001 # Query # # COMMIT
112 binlog.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_insert_select` /* generated by server */
113 binlog.000001 # Query # # BEGIN
114 binlog.000001 # Table_map # # table_id: # (my_replicated_db.my_tx_table)
115 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
116 binlog.000001 # Xid # # COMMIT /* XID */
117 binlog.000001 # Query # # BEGIN
118 binlog.000001 # Table_map # # table_id: # (my_replicated_db.my_bh_table)
119 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
120 binlog.000001 # Query # # COMMIT
121 binlog.000001 # Query # # BEGIN
122 binlog.000001 # Table_map # # table_id: # (my_replicated_db.my_tx_table)
123 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
124 binlog.000001 # Xid # # COMMIT /* XID */
125 binlog.000001 # Query # # BEGIN
126 binlog.000001 # Table_map # # table_id: # (my_replicated_db.my_bh_table)
127 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
128 binlog.000001 # Query # # COMMIT
129 binlog.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_multi_update` /* generated by server */
130 binlog.000001 # Query # # BEGIN
131 binlog.000001 # Table_map # # table_id: # (my_replicated_db.my_tx_table)
132 binlog.000001 # Update_rows # # table_id: # flags: STMT_END_F
133 binlog.000001 # Xid # # COMMIT /* XID */
134 binlog.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_multi_delete` /* generated by server */
135 binlog.000001 # Query # # BEGIN
136 binlog.000001 # Table_map # # table_id: # (my_replicated_db.my_tx_table)
137 binlog.000001 # Delete_rows # # table_id: # flags: STMT_END_F
138 binlog.000001 # Xid # # COMMIT /* XID */
139 binlog.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_end` /* generated by server */
140 binlog.000001 # Query # # use `my_replicated_db`; DROP TABLE IF EXISTS `my_bh_table` /* generated by server */
141 binlog.000001 # Query # # drop database my_replicated_db
142 truncate table performance_schema.setup_actors;
143 insert into performance_schema.setup_actors values ('%', '%', '%', 'YES', 'YES');