Debian Codegraph @

mysql-test/suite/perfschema/r/binlog_edge_row_myisam.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_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 insert into my_non_tx_table(a)
24 select id from information_schema.processlist;
25 Warnings:
26 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
27 insert into my_non_tx_table(a)
28 select thread_id from mysql.general_log;
29 insert into my_non_tx_table(a)
30 select thread_id from mysql.slow_log;
31 insert into my_non_tx_table(a)
32 select Relay_log_pos from mysql.slave_relay_log_info;
33 insert into my_non_tx_table(a)
34 select Master_log_pos from mysql.slave_master_info;
35 insert into my_non_tx_table(a)
36 select Relay_log_pos from mysql.slave_worker_info;
37 use test;
38 drop table if exists marker_multi_update;
39 Warnings:
40 Note 1051 Unknown table 'test.marker_multi_update'
41 use my_replicated_db;
42 update my_non_tx_table, performance_schema.setup_instruments
43 set my_non_tx_table.a = my_non_tx_table.a + 1,
44 performance_schema.setup_instruments.timed= 'NO';
45 use test;
46 drop table if exists marker_multi_delete;
47 Warnings:
48 Note 1051 Unknown table 'test.marker_multi_delete'
49 use my_replicated_db;
50 insert into performance_schema.setup_actors
51 values ('BAR', 'BAR', 'BAR', 'YES', 'YES');
52 delete my_non_tx_table.*, performance_schema.setup_actors.*
53 from my_non_tx_table, performance_schema.setup_actors
54 where my_non_tx_table.a != 1000
55 or performance_schema.setup_actors.role='BAR';
56 use test;
57 drop table if exists marker_end;
58 Warnings:
59 Note 1051 Unknown table 'test.marker_end'
60 drop database my_replicated_db;
61 include/show_binlog_events.inc
62 Log_name Pos Event_type Server_id End_log_pos Info
63 binlog.000001 # Query # # drop database if exists my_replicated_db
64 binlog.000001 # Query # # BEGIN
65 binlog.000001 # Table_map # # table_id: # (mtr.test_suppressions)
66 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
67 binlog.000001 # Xid # # COMMIT /* XID */
68 binlog.000001 # Query # # create database my_replicated_db
69 binlog.000001 # Query # # use `test`; create table my_replicated_db.my_non_tx_table(a bigint) engine = myisam
70 binlog.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_start` /* generated by server */
71 binlog.000001 # Query # # BEGIN
72 binlog.000001 # Table_map # # table_id: # (my_replicated_db.my_non_tx_table)
73 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
74 binlog.000001 # Query # # COMMIT
75 binlog.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_insert_select` /* generated by server */
76 binlog.000001 # Query # # BEGIN
77 binlog.000001 # Table_map # # table_id: # (my_replicated_db.my_non_tx_table)
78 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
79 binlog.000001 # Query # # COMMIT
80 binlog.000001 # Query # # BEGIN
81 binlog.000001 # Table_map # # table_id: # (my_replicated_db.my_non_tx_table)
82 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
83 binlog.000001 # Query # # COMMIT
84 binlog.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_multi_update` /* generated by server */
85 binlog.000001 # Query # # BEGIN
86 binlog.000001 # Table_map # # table_id: # (my_replicated_db.my_non_tx_table)
87 binlog.000001 # Update_rows # # table_id: # flags: STMT_END_F
88 binlog.000001 # Query # # COMMIT
89 binlog.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_multi_delete` /* generated by server */
90 binlog.000001 # Query # # BEGIN
91 binlog.000001 # Table_map # # table_id: # (my_replicated_db.my_non_tx_table)
92 binlog.000001 # Delete_rows # # table_id: # flags: STMT_END_F
93 binlog.000001 # Query # # COMMIT
94 binlog.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_end` /* generated by server */
95 binlog.000001 # Query # # use `my_replicated_db`; DROP TABLE IF EXISTS `my_non_tx_table` /* generated by server */
96 binlog.000001 # Query # # drop database my_replicated_db
97 truncate table performance_schema.setup_actors;
98 insert into performance_schema.setup_actors values ('%', '%', '%', 'YES', 'YES');