Debian Codegraph @

mysql-test/suite/sys_vars/t/replicate_rewrite_db.test

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