1# BUG#37656
2#
3# DESCRIPTION
4#
5#
6#  This test case is tests whether replication works properly when
7#  slave is configured with --lower-case-table-names=1 and replication
8#  rewrite rules are in effect.
9#
10#  It checks four issues:
11#
12#   (i) master contains capitalized table name
13#
14#  (ii) slave contains lowered case table name
15#
16# (iii) master and slave tables do not differ
17#
18-- source include/master-slave.inc
19-- source include/not_windows.inc
20
21SET SQL_LOG_BIN=0;
22CREATE DATABASE B37656;
23SET SQL_LOG_BIN=1;
24
25-- connection slave
26CREATE DATABASE BUG37656;
27
28-- echo ### action: show that database on slave is created in lowercase
29SHOW DATABASES LIKE '%37656';
30
31-- connection master
32USE B37656;
33CREATE TABLE T1 (a int);
34INSERT INTO T1 VALUES (1);
35
36-- echo ### assertion: master contains capitalized case table
37SHOW TABLES;
38
39-- sync_slave_with_master
40
41use bug37656;
42
43-- echo ### assertion: slave contains lowered case table
44SHOW TABLES;
45
46-- echo ### assertion: master and slave tables do not differ
47let $diff_tables= master:B37656.T1, slave:bug37656.t1;
48
49-- source include/diff_tables.inc
50
51-- connection master
52SET SQL_LOG_BIN=0;
53DROP DATABASE B37656;
54SET SQL_LOG_BIN=1;
55SHOW DATABASES LIKE '%37656';
56
57-- connection slave
58DROP DATABASE BUG37656;
59SHOW DATABASES LIKE '%37656';
60--source include/rpl_end.inc
61