Debian Codegraph @

mysql-test/suite/ndb_binlog/r/ndb_binlog_ignore_db.result

raw
1 reset master;
2 create database mysqltest;
3 use mysqltest;
4 create table t1 (a int primary key, b int) engine=ndb;
5 insert into t1 values (1, 1);
6 use test;
7 insert into mysqltest.t1 values(2,2);
8 include/show_binlog_events.inc
9 Log_name Pos Event_type Server_id End_log_pos Info
10 drop database mysqltest;
11 --bug58698 Epoch not in ndb_apply_status
12 reset master;
13 use mysql;
14 -- MyISAM table in mysql db
15 create table invisible(a int primary key) engine=myisam;
16 insert into invisible values (1);
17 insert into invisible values (2);
18 delete from invisible;
19 drop table invisible;
20 -- Should be nothing in binlog
21 include/show_binlog_events.inc
22 Log_name Pos Event_type Server_id End_log_pos Info
23 -- Ndb table in mysql db
24 create table invisible(a int primary key) engine=ndb;
25 insert into invisible values (1);
26 insert into invisible values (2);
27 delete from invisible;
28 drop table invisible;
29 -- Should be nothing in binlog
30 include/show_binlog_events.inc
31 Log_name Pos Event_type Server_id End_log_pos Info
32 -- ndb_binlog_index table (MyISAM) in mysql db
33 insert into ndb_binlog_index values (12, 'F', 23, 0, 0, 0, 0, 3, 44, 55, 66, 'H');
34 insert into ndb_binlog_index values (20, 'G', 23, 0, 0, 0, 0, 5, 44, 55, 77, 'I');
35 delete from ndb_binlog_index;
36 -- Should be nothing in binlog
37 include/show_binlog_events.inc
38 Log_name Pos Event_type Server_id End_log_pos Info
39 -- Non-ignored db (test2)
40 create database test2;
41 use test2;
42 create table t1 (a int primary key) engine=ndb;
43 insert into t1 values (1);
44 insert into t1 values (2);
45 delete from t1;
46 drop table t1;
47 drop database test2;
48 -- Should have events in Binlog, *including ndb_apply_status*
49 use test;
50 create table raw_binlog_rows (txt varchar(1000));
51 select count(1) > 0 from raw_binlog_rows where txt like '%ndb_apply_status%';
52 count(1) > 0
53 1
54 drop table raw_binlog_rows;