Debian Codegraph @

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

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 SET SQL_LOG_BIN=0;
7 CREATE DATABASE B37656;
8 SET SQL_LOG_BIN=1;
9 CREATE DATABASE BUG37656;
10 ### action: show that database on slave is created in lowercase
11 SHOW DATABASES LIKE '%37656';
12 Database (%37656)
13 bug37656
14 USE B37656;
15 CREATE TABLE T1 (a int);
16 INSERT INTO T1 VALUES (1);
17 ### assertion: master contains capitalized case table
18 SHOW TABLES;
19 Tables_in_B37656
20 T1
21 include/sync_slave_sql_with_master.inc
22 use bug37656;
23 ### assertion: slave contains lowered case table
24 SHOW TABLES;
25 Tables_in_bug37656
26 t1
27 ### assertion: master and slave tables do not differ
28 include/diff_tables.inc [master:B37656.T1, slave:bug37656.t1]
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 CALL mtr.add_suppression("The source\'s UUID has changed.*");
35 DROP DATABASE BUG37656;
36 SHOW DATABASES LIKE '%37656';
37 Database (%37656)
38 include/rpl_end.inc