Debian Codegraph @

mysql-test/suite/rpl/r/rpl_create_database.result

raw
1 include/master-slave.inc
2 [connection master]
3 DROP DATABASE IF EXISTS mysqltest_prometheus;
4 DROP DATABASE IF EXISTS mysqltest_sisyfos;
5 DROP DATABASE IF EXISTS mysqltest_bob;
6 connection slave;
7 DROP DATABASE IF EXISTS mysqltest_bob;
8 connection master;
9 CREATE DATABASE mysqltest_prometheus;
10 CREATE DATABASE mysqltest_sisyfos;
11 CREATE DATABASE mysqltest_bob;
12 USE mysqltest_sisyfos;
13 CREATE TABLE t1 (b int);
14 INSERT INTO t1 VALUES(1);
15 USE mysqltest_bob;
16 CREATE TABLE t2 (b int);
17 INSERT INTO t2 VALUES(2);
18 ALTER DATABASE mysqltest_sisyfos CHARACTER SET latin1;
19 USE mysqltest_sisyfos;
20 ALTER DATABASE mysqltest_bob CHARACTER SET latin1;
21 SHOW DATABASES LIKE 'mysql%';
22 Database (mysql%)
23 mysql
24 mysqltest_bob
25 mysqltest_prometheus
26 mysqltest_sisyfos
27 connection slave;
28 SHOW DATABASES LIKE 'mysql%';
29 Database (mysql%)
30 mysql
31 mysqltest_prometheus
32 mysqltest_sisyfos
33 connection master;
34 DROP DATABASE IF EXISTS mysqltest_sisyfos;
35 USE mysqltest_prometheus;
36 CREATE TABLE t1 (a INT);
37 INSERT INTO t1 VALUES (1);
38 CREATE DATABASE mysqltest_sisyfos;
39 USE mysqltest_sisyfos;
40 CREATE TABLE t2 (a INT);
41 SHOW DATABASES LIKE 'mysql%';
42 Database (mysql%)
43 mysql
44 mysqltest_bob
45 mysqltest_prometheus
46 mysqltest_sisyfos
47 connection slave;
48 SHOW DATABASES LIKE 'mysql%';
49 Database (mysql%)
50 mysql
51 mysqltest_prometheus
52 mysqltest_sisyfos
53 USE mysqltest_prometheus;
54 SHOW TABLES;
55 Tables_in_mysqltest_prometheus
56 t1
57 USE mysqltest_sisyfos;
58 SHOW TABLES;
59 Tables_in_mysqltest_sisyfos
60 t2
61 connection master;
62 DROP DATABASE IF EXISTS mysqltest_prometheus;
63 DROP DATABASE IF EXISTS mysqltest_sisyfos;
64 DROP DATABASE IF EXISTS mysqltest_bob;
65 connection slave;
66 include/rpl_end.inc