Debian Codegraph @

mysql-test/suite/rpl/t/rpl_create_drop_db.test

raw
1 --source include/master-slave.inc
2
3 connection master;
4
5 CREATE DATABASE db1;
6 CREATE DATABASE IF NOT EXISTS db1;
7 CREATE OR REPLACE DATABASE db2;
8 CREATE OR REPLACE DATABASE db1;
9 sync_slave_with_master;
10
11 SHOW DATABASES LIKE 'db%';
12
13 connection master;
14 --error ER_DB_CREATE_EXISTS
15 CREATE DATABASE db1;
16
17 --error ER_DB_DROP_EXISTS
18 DROP DATABASE db3;
19
20 CREATE DATABASE IF NOT EXISTS db3;
21 sync_slave_with_master;
22
23 SHOW DATABASES LIKE 'db%';
24
25 connection master;
26 DROP DATABASE db1;
27 DROP DATABASE db2;
28 DROP DATABASE IF EXISTS db3;
29 sync_slave_with_master;
30
31 SHOW DATABASES LIKE 'db%';
32
33 --source include/rpl_end.inc