Debian Codegraph @

mysql-test/suite/rpl_nogtid/t/rpl_replicate_ignore_db.test

raw
1 # see if --replicate-ignore-db works
2
3 --source include/not_group_replication_plugin.inc
4 --source include/master-slave.inc
5
6 --disable_warnings
7 drop database if exists mysqltest1;
8 drop database if exists mysqltest2;
9 --enable_warnings
10 create database mysqltest1;
11 create database mysqltest2;
12
13 use mysqltest1;
14 create table t1 (a int);
15 insert into t1 values(1);
16 --source include/sync_slave_sql_with_master.inc
17 --error ER_BAD_DB_ERROR
18 select * from mysqltest1.t1;
19
20 connection master;
21 use mysqltest2;
22 create table t1 (a int);
23 insert into t1 values(1);
24 --source include/sync_slave_sql_with_master.inc
25 select * from mysqltest2.t1;
26
27 # cleanup
28 connection master;
29 drop database mysqltest1;
30 drop database mysqltest2;
31 --source include/sync_slave_sql_with_master.inc
32 --source include/rpl_end.inc