Debian Codegraph @

mysql-test/suite/rpl/t/rpl_replicate_rewrite_db.test

raw
1 ##---------------------------------------------------------------------------
2 # Purpose: Testing error messages for --replicate-rewrite-db option
3 ##--------------------------------------------------------------------------
4
5 #check single character databases. Bug#11747866
6 --let $rpl_skip_reset_master_and_slave= 1
7 --let $rpl_skip_start_slave= 1
8 --source include/master-slave.inc
9
10 --connection master
11 --let $rpl_server_number=1
12 --source include/rpl_stop_server.inc
13
14 #check for normal functionality
15 --echo testing for normal fuctionality
16 --let $rpl_server_number= 1
17 --let $rpl_server_parameters= --replicate-rewrite-db='mysql->test'
18 --source include/rpl_start_server.inc
19 --echo [PASS]
20
21 --let $rpl_server_number=1
22 --source include/rpl_stop_server.inc
23
24 #check for single characters databases. BUG#11747866
25 --echo testing with single letter databases name.
26 --let $rpl_server_number= 1
27 --let $rpl_server_parameters= --replicate-rewrite-db='a->b'
28 --source include/rpl_start_server.inc
29 --echo [PASS]
30
31 #check for '->' operator not found. Should fail with error
32 --echo check for '->' operator not found. Should FAIL with error
33 --disable_result_log
34 --error 1
35 exec $MYSQLD --replicate-rewrite-db='mysql' 2>&1;
36 --enable_result_log
37 --echo [FAIL]
38
39 #check for empty "from" db name. Should fail with error
40 --echo check for empty "from" db name. Should FAIL with error
41 --disable_result_log
42 --error 1
43 exec $MYSQLD --replicate-rewrite-db= '->test ' 2>&1;
44 --enable_result_log
45 --echo [FAIL]
46
47 #check for empty "to" db name. Should fail with error.
48 --echo check for empty "to" db name. Should FAIL with error
49 --disable_result_log
50 --error 1
51 exec $MYSQLD --replicate-rewrite-db='acc-> ' 2>&1;
52 --enable_result_log
53 --echo [FAIL]
54
55 # End of test
56 --source include/rpl_connection_slave.inc
57 --source include/start_slave.inc
58
59 --source include/rpl_end.inc