Debian Codegraph @

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

raw
1 set binlog_format=mixed;
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 insert into my_non_tx_table(a)
28 select thread_id from performance_schema.threads;
29 insert into my_bh_table(a)
30 select thread_id from performance_schema.threads;
31 insert into my_tx_table(a)
32 select id from information_schema.processlist;
33 insert into my_non_tx_table(a)
34 select id from information_schema.processlist;
35 insert into my_bh_table(a)
36 select id from information_schema.processlist;
37 insert into my_tx_table(a)
38 select thread_id from mysql.general_log;
39 insert into my_non_tx_table(a)
40 select thread_id from mysql.general_log;
41 insert into my_bh_table(a)
42 select thread_id from mysql.general_log;
43 insert into my_tx_table(a)
44 select thread_id from mysql.slow_log;
45 insert into my_non_tx_table(a)
46 select thread_id from mysql.slow_log;
47 insert into my_bh_table(a)
48 select thread_id from mysql.slow_log;
49 insert into my_tx_table(a)
50 select Relay_log_pos from mysql.slave_relay_log_info;
51 insert into my_non_tx_table(a)
52 select Relay_log_pos from mysql.slave_relay_log_info;
53 insert into my_bh_table(a)
54 select Relay_log_pos from mysql.slave_relay_log_info;
55 insert into my_tx_table(a)
56 select Master_log_pos from mysql.slave_master_info;
57 insert into my_non_tx_table(a)
58 select Master_log_pos from mysql.slave_master_info;
59 insert into my_bh_table(a)
60 select Master_log_pos from mysql.slave_master_info;
61 insert into my_tx_table(a)
62 select Relay_log_pos from mysql.slave_worker_info;
63 insert into my_non_tx_table(a)
64 select Relay_log_pos from mysql.slave_worker_info;
65 insert into my_bh_table(a)
66 select Relay_log_pos from mysql.slave_worker_info;
67 use test;
68 drop table if exists marker_multi_update;
69 Warnings:
70 Note 1051 Unknown table 'test.marker_multi_update'
71 use my_replicated_db;
72 update my_tx_table, performance_schema.setup_instruments
73 set my_tx_table.a = my_tx_table.a + 1,
74 performance_schema.setup_instruments.timed= 'NO';
75 update my_non_tx_table, performance_schema.setup_instruments
76 set my_non_tx_table.a = my_non_tx_table.a + 1,
77 performance_schema.setup_instruments.timed= 'NO';
78 update my_bh_table, performance_schema.setup_instruments
79 set my_bh_table.a = my_bh_table.a + 1,
80 performance_schema.setup_instruments.timed= 'NO';
81 use test;
82 drop table if exists marker_multi_delete;
83 Warnings:
84 Note 1051 Unknown table 'test.marker_multi_delete'
85 use my_replicated_db;
86 insert into performance_schema.setup_actors
87 values ('FOO', 'FOO', 'FOO', 'YES', 'YES');
88 delete my_tx_table.*, performance_schema.setup_actors.*
89 from my_tx_table, performance_schema.setup_actors
90 where my_tx_table.a != 1000
91 or performance_schema.setup_actors.role='FOO';
92 insert into performance_schema.setup_actors
93 values ('BAR', 'BAR', 'BAR', 'YES', 'YES');
94 delete my_non_tx_table.*, performance_schema.setup_actors.*
95 from my_non_tx_table, performance_schema.setup_actors
96 where my_non_tx_table.a != 1000
97 or performance_schema.setup_actors.role='BAR';
98 insert into performance_schema.setup_actors
99 values ('BAZ', 'BAZ', 'BAZ', 'YES', 'YES');
100 delete my_bh_table.*, performance_schema.setup_actors.*
101 from my_bh_table, performance_schema.setup_actors
102 where my_bh_table.a != 1000
103 or performance_schema.setup_actors.role='BAZ';
104 use test;
105 drop table if exists marker_end;
106 Warnings:
107 Note 1051 Unknown table 'test.marker_end'
108 drop database my_replicated_db;
109 include/show_binlog_events.inc
110 Log_name Pos Event_type Server_id End_log_pos Info
111 master-bin.000001 # Query # # drop database if exists my_replicated_db
112 master-bin.000001 # Query # # BEGIN
113 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'))
114 master-bin.000001 # Query # # COMMIT
115 master-bin.000001 # Query # # create database my_replicated_db
116 master-bin.000001 # Query # # use `test`; create table my_replicated_db.my_tx_table(a bigint) engine = innodb
117 master-bin.000001 # Query # # use `test`; create table my_replicated_db.my_non_tx_table(a bigint) engine = myisam
118 master-bin.000001 # Query # # use `test`; create table my_replicated_db.my_bh_table(a bigint) engine = blackhole
119 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_start` /* generated by server */
120 master-bin.000001 # Query # # BEGIN
121 master-bin.000001 # Query # # use `my_replicated_db`; insert into my_tx_table(a)
122 values (1000), (2000), (3000)
123 master-bin.000001 # Xid # # COMMIT /* XID */
124 master-bin.000001 # Query # # BEGIN
125 master-bin.000001 # Query # # use `my_replicated_db`; insert into my_non_tx_table(a)
126 values (1000), (2000), (3000)
127 master-bin.000001 # Query # # COMMIT
128 master-bin.000001 # Query # # BEGIN
129 master-bin.000001 # Query # # use `my_replicated_db`; insert into my_bh_table(a)
130 values (1000), (2000), (3000)
131 master-bin.000001 # Query # # COMMIT
132 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_insert_select` /* generated by server */
133 master-bin.000001 # Query # # BEGIN
134 master-bin.000001 # Table_map # # table_id: # (my_replicated_db.my_tx_table)
135 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
136 master-bin.000001 # Xid # # COMMIT /* XID */
137 master-bin.000001 # Query # # BEGIN
138 master-bin.000001 # Table_map # # table_id: # (my_replicated_db.my_non_tx_table)
139 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
140 master-bin.000001 # Query # # COMMIT
141 master-bin.000001 # Query # # BEGIN
142 master-bin.000001 # Table_map # # table_id: # (my_replicated_db.my_bh_table)
143 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
144 master-bin.000001 # Query # # COMMIT
145 master-bin.000001 # Query # # BEGIN
146 master-bin.000001 # Query # # use `my_replicated_db`; insert into my_tx_table(a)
147 select id from information_schema.processlist
148 master-bin.000001 # Xid # # COMMIT /* XID */
149 master-bin.000001 # Query # # BEGIN
150 master-bin.000001 # Query # # use `my_replicated_db`; insert into my_non_tx_table(a)
151 select id from information_schema.processlist
152 master-bin.000001 # Query # # COMMIT
153 master-bin.000001 # Query # # BEGIN
154 master-bin.000001 # Query # # use `my_replicated_db`; insert into my_bh_table(a)
155 select id from information_schema.processlist
156 master-bin.000001 # Query # # COMMIT
157 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_multi_update` /* generated by server */
158 master-bin.000001 # Query # # BEGIN
159 master-bin.000001 # Table_map # # table_id: # (my_replicated_db.my_tx_table)
160 master-bin.000001 # Update_rows # # table_id: # flags: STMT_END_F
161 master-bin.000001 # Xid # # COMMIT /* XID */
162 master-bin.000001 # Query # # BEGIN
163 master-bin.000001 # Table_map # # table_id: # (my_replicated_db.my_non_tx_table)
164 master-bin.000001 # Update_rows # # table_id: # flags: STMT_END_F
165 master-bin.000001 # Query # # COMMIT
166 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_multi_delete` /* generated by server */
167 master-bin.000001 # Query # # BEGIN
168 master-bin.000001 # Table_map # # table_id: # (my_replicated_db.my_tx_table)
169 master-bin.000001 # Delete_rows # # table_id: # flags: STMT_END_F
170 master-bin.000001 # Xid # # COMMIT /* XID */
171 master-bin.000001 # Query # # BEGIN
172 master-bin.000001 # Table_map # # table_id: # (my_replicated_db.my_non_tx_table)
173 master-bin.000001 # Delete_rows # # table_id: # flags: STMT_END_F
174 master-bin.000001 # Query # # COMMIT
175 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_end` /* generated by server */
176 master-bin.000001 # Query # # drop database my_replicated_db
177 truncate table performance_schema.setup_actors;
178 insert into performance_schema.setup_actors values ('%', '%', '%', 'YES', 'YES');