Debian Codegraph @

mysql-test/suite/rpl/include/rpl_lower_case_table_names.test

raw
1 # BUG#37656
2 #
3 # This test aims at checking whether lower_case_table_names=1 option works
4 # for database names and table names.
5 #
6 # This test checks the following (when lower_case_table_names=1 is set on slave):
7 # (i) creating a database on upper case on master results in lower case
8 # database name on slave
9 # (ii) creating tables with upper case names on master results in lower case
10 # table names on slave
11 # (iii) loading data infile into capitalized table name on master replicates to
12 # lower case table name on slave
13 # (iv) Propagating changes from upper case table names on into correspondent
14 # lower case table names on slave works.
15
16
17 # setup: create database and tables
18 -- echo ******** [ MASTER ] ********
19 -- let $dbname_upper= BUG_37656
20 -- let $dbname_lower= `SELECT LOWER('$dbname_upper')`
21 -- eval CREATE DATABASE $dbname_upper
22 -- eval use $dbname_upper
23
24 # assert: database names are in upper case in master and lower
25 # case in slave
26 -- eval show databases like '$dbname_upper'
27 sync_slave_with_master;
28 -- echo ******** [ SLAVE ] ********
29 --eval show databases like '$dbname_lower'
30
31 -- connection master
32 -- echo ******** [ MASTER ] ********
33 CREATE TABLE T1 (a int);
34 -- eval CREATE TABLE T2 (b int) ENGINE=$engine
35 CREATE TABLE T3 (txt TEXT);
36
37 # assert: that tables exist on master with upper case names
38 show tables;
39
40 # assert: that tables exist on slave but with lower case names
41 -- sync_slave_with_master
42 -- echo ******** [ SLAVE ] ********
43 -- eval use $dbname_lower
44 show tables;
45
46 # action: lets create t1 for asserting below that t1 does not get changes
47 # from master (slave configured with --replicate-ignore-db=$dbname_lower.t1)
48 CREATE TABLE t1 (a INT);
49
50 # action: fill data into tables
51 -- connection master
52 -- echo ******** [ MASTER ] ********
53 -- eval use $dbname_upper
54 INSERT INTO T1 VALUES (1);
55 INSERT INTO T2 VALUES (1);
56 if (`SELECT @@session.binlog_format != 'ROW'`)
57 {
58 -- eval LOAD DATA INFILE '../../std_data/words.dat' INTO TABLE $dbname_upper.T3
59 }
60
61 if (`SELECT @@session.binlog_format = 'ROW'`)
62 {
63 use test;
64 -- eval INSERT INTO $dbname_upper.T1 VALUES (2)
65 -- eval INSERT INTO $dbname_upper.T2 VALUES (2)
66 -- eval LOAD DATA INFILE '../../std_data/words.dat' INTO TABLE $dbname_upper.T3
67 }
68 # assert: lower case tables on lower case database on slave
69 # get updates from upper case tables on upper case
70 # database on master
71 -- sync_slave_with_master
72 -- echo ******** [ SLAVE ] ********
73
74 # assert: changes for slave's t1 were filterd out
75 if (`SELECT count(*) != 0 FROM t1`)
76 {
77 -- echo UNEXPECTED DATA on $dbname_lower.t1 as table is filtered by replicate-ignore-table rules
78 }
79
80 -- let $diff_tables=master:$dbname_upper.T2, slave:$dbname_lower.t2
81 -- source include/diff_tables.inc
82
83 -- let $diff_tables=master:$dbname_upper.T3, slave:$dbname_lower.t3
84 -- source include/diff_tables.inc
85
86 # clean up
87 -- connection master
88 -- echo ******** [ MASTER ] ********
89 -- eval DROP DATABASE $dbname_upper
90 -- sync_slave_with_master
91
92
93 #
94 # BUG#50653: drop procedure implicitely treats db name in a case sensitive way
95 #
96
97 -- connection master
98
99 -- let $dbname= B50653
100 -- let $procname= b50653_proc
101
102 -- eval CREATE DATABASE $dbname
103 -- eval USE $dbname
104 -- eval CREATE PROCEDURE $procname() BEGIN SELECT 1; END
105
106 if (`SELECT count(*) = 1 FROM mysql.proc WHERE name like '$dbname'`)
107 {
108 -- die Procedure not created on MASTER
109 }
110
111 -- sync_slave_with_master
112 if (`SELECT count(*) = 1 FROM mysql.proc WHERE name like '$dbname'`)
113 {
114 -- die Procedure not created on SLAVE
115 }
116
117 -- connection master
118 -- eval DROP PROCEDURE $procname
119
120 if (`SELECT count(*) FROM mysql.proc WHERE name like '$dbname'`)
121 {
122 -- die Procedure not dropped on MASTER
123 }
124
125 -- sync_slave_with_master
126 if (`SELECT count(*) FROM mysql.proc WHERE name like '$dbname'`)
127 {
128 -- die Procedure not dropped on SLAVE
129 }
130
131 -- let $last_error = query_get_value("SHOW SLAVE STATUS", Last_SQL_Errno, 1)
132 if ($last_error)
133 {
134 -- die UNEXPECTED SLAVE SQL error: $last_error
135 }
136
137 -- connection master
138 -- eval DROP DATABASE $dbname
139 -- sync_slave_with_master
140
141 -- source include/rpl_end.inc