1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
|
--source include/not_embedded.inc
--echo #
--echo # MDEV-15530: Variable replicate_rewrite_db
--echo # cannot be found in "show global variables"
--echo #
SET @save_replicate_rewrite_db = @@GLOBAL.replicate_rewrite_db;
SELECT @save_replicate_rewrite_db;
--echo # Test session/Scope (it is global variable)
select @@global.replicate_rewrite_db;
--error ER_INCORRECT_GLOBAL_LOCAL_VAR
SELECT @@SESSION.replicate_rewrite_db;
--error ER_GLOBAL_VARIABLE
SET @@SESSION.replicate_rewrite_db = "";
show global variables like 'replicate_rewrite_db';
show session variables like 'replicate_rewrite_db';
select * from information_schema.global_variables where variable_name='replicate_rewrite_db';
select * from information_schema.session_variables where variable_name='replicate_rewrite_db';
--echo # Incorrect type
--error ER_WRONG_TYPE_FOR_VAR
SET @@GLOBAL.replicate_rewrite_db=1;
--error ER_WRONG_ARGUMENTS
SET @@GLOBAL.replicate_rewrite_db="->";
--error ER_WRONG_ARGUMENTS
SET @@GLOBAL.replicate_rewrite_db=" ";
--error ER_WRONG_ARGUMENTS
SET @@GLOBAL.replicate_rewrite_db="a->";
--error ER_WRONG_ARGUMENTS
SET @@GLOBAL.replicate_rewrite_db="->b";
--echo # Check arguments
--error ER_GLOBAL_VARIABLE
set session replicate_rewrite_db=1;
--error ER_WRONG_TYPE_FOR_VAR
set global replicate_rewrite_db=1;
--error ER_GLOBAL_VARIABLE
SET @@SESSION.replicate_do_db = "";
# This should work
SET @@GLOBAL.replicate_rewrite_db="";
SELECT @@GLOBAL.replicate_rewrite_db;
SET @@GLOBAL.replicate_rewrite_db=null;
SELECT @@GLOBAL.replicate_rewrite_db;
SET @@GLOBAL.replicate_rewrite_db=DEFAULT;
SELECT @@GLOBAL.replicate_rewrite_db;
SET @@GLOBAL.replicate_rewrite_db="db1->db3";
SELECT @@GLOBAL.replicate_rewrite_db;
SET @@GLOBAL.replicate_rewrite_db="db2 ->db4";
SELECT @@GLOBAL.replicate_rewrite_db;
SET @@GLOBAL.replicate_rewrite_db=" db5 ->db7 ";
SELECT @@GLOBAL.replicate_rewrite_db;
SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='replicate_rewrite_db';
select * from information_schema.session_variables where variable_name='replicate_rewrite_db';
show global variables like 'replicate_rewrite_db';
SET @@GLOBAL.replicate_rewrite_db="db1->db2, db3->db4";
SELECT @@GLOBAL.replicate_rewrite_db;
SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='replicate_rewrite_db';
--echo # Check restart with appending the value
--let $restart_parameters = --replicate_rewrite_db='X->Y'
--source include/restart_mysqld.inc
SELECT @@GLOBAL.replicate_rewrite_db;
--echo # Check restart with wrong value on CLI
--source include/shutdown_mysqld.inc
# Expect the server to fail to come up with these options
--let $args="--replicate_rewrite_db=x-" --log-warnings=1 --silent-startup --help --verbose
--error 1
--exec $MYSQLD_CMD $args > $MYSQL_TMP_DIR/mysqld--replicate.txt 2> $MYSQL_TMP_DIR/mysqld--replicate.err
--replace_regex /mysqld/mariadbd/ /\d\d\d\d-\d*-\d* *\d*:\d*:\d* \d* //
--cat_file $MYSQL_TMP_DIR/mysqld--replicate.err
# Restart the server with the default options
--let $restart_parameters =
--source include/start_mysqld.inc
SELECT @@GLOBAL.replicate_rewrite_db;
|
