Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 SET SQL_LOG_BIN=0;
4 CREATE DATABASE B37656;
5 SET SQL_LOG_BIN=1;
6 connection slave;
7 CREATE DATABASE BUG37656;
8 ### action: show that database on slave is created in lowercase
9 SHOW DATABASES LIKE '%37656';
10 Database (%37656)
11 bug37656
12 connection master;
13 USE B37656;
14 CREATE TABLE T1 (a int);
15 INSERT INTO T1 VALUES (1);
16 ### assertion: master contains capitalized case table
17 SHOW TABLES;
18 Tables_in_B37656
19 T1
20 connection slave;
21 use bug37656;
22 ### assertion: slave contains lowered case table
23 SHOW TABLES;
24 Tables_in_bug37656
25 t1
26 ### assertion: master and slave tables do not differ
27 include/diff_tables.inc [master:B37656.T1, slave:bug37656.t1]
28 connection master;
29 SET SQL_LOG_BIN=0;
30 DROP DATABASE B37656;
31 SET SQL_LOG_BIN=1;
32 SHOW DATABASES LIKE '%37656';
33 Database (%37656)
34 connection slave;
35 DROP DATABASE BUG37656;
36 SHOW DATABASES LIKE '%37656';
37 Database (%37656)
38 include/rpl_end.inc