Debian Codegraph @

mysql-test/suite/sys_vars/r/replicate_rewrite_db.result

raw
1 #
2 # MDEV-15530: Variable replicate_rewrite_db
3 # cannot be found in "show global variables"
4 #
5 SET @save_replicate_rewrite_db = @@GLOBAL.replicate_rewrite_db;
6 SELECT @save_replicate_rewrite_db;
7 @save_replicate_rewrite_db
8 test->rewrite,mysqltest1->test,a->b
9 # Test session/Scope (it is global variable)
10 select @@global.replicate_rewrite_db;
11 @@global.replicate_rewrite_db
12 test->rewrite,mysqltest1->test,a->b
13 SELECT @@SESSION.replicate_rewrite_db;
14 ERROR HY000: Variable 'replicate_rewrite_db' is a GLOBAL variable
15 SET @@SESSION.replicate_rewrite_db = "";
16 ERROR HY000: Variable 'replicate_rewrite_db' is a GLOBAL variable and should be set with SET GLOBAL
17 show global variables like 'replicate_rewrite_db';
18 Variable_name Value
19 replicate_rewrite_db test->rewrite,mysqltest1->test,a->b
20 show session variables like 'replicate_rewrite_db';
21 Variable_name Value
22 replicate_rewrite_db test->rewrite,mysqltest1->test,a->b
23 select * from information_schema.global_variables where variable_name='replicate_rewrite_db';
24 VARIABLE_NAME VARIABLE_VALUE
25 REPLICATE_REWRITE_DB test->rewrite,mysqltest1->test,a->b
26 select * from information_schema.session_variables where variable_name='replicate_rewrite_db';
27 VARIABLE_NAME VARIABLE_VALUE
28 REPLICATE_REWRITE_DB test->rewrite,mysqltest1->test,a->b
29 # Incorrect type
30 SET @@GLOBAL.replicate_rewrite_db=1;
31 ERROR 42000: Incorrect argument type to variable 'replicate_rewrite_db'
32 SET @@GLOBAL.replicate_rewrite_db="->";
33 ERROR HY000: Incorrect arguments to SET
34 SET @@GLOBAL.replicate_rewrite_db=" ";
35 ERROR HY000: Incorrect arguments to SET
36 SET @@GLOBAL.replicate_rewrite_db="a->";
37 ERROR HY000: Incorrect arguments to SET
38 SET @@GLOBAL.replicate_rewrite_db="->b";
39 ERROR HY000: Incorrect arguments to SET
40 # Check arguments
41 set session replicate_rewrite_db=1;
42 ERROR HY000: Variable 'replicate_rewrite_db' is a GLOBAL variable and should be set with SET GLOBAL
43 set global replicate_rewrite_db=1;
44 ERROR 42000: Incorrect argument type to variable 'replicate_rewrite_db'
45 SET @@SESSION.replicate_do_db = "";
46 ERROR HY000: Variable 'replicate_do_db' is a GLOBAL variable and should be set with SET GLOBAL
47 SET @@GLOBAL.replicate_rewrite_db="";
48 SELECT @@GLOBAL.replicate_rewrite_db;
49 @@GLOBAL.replicate_rewrite_db
50
51 SET @@GLOBAL.replicate_rewrite_db=null;
52 SELECT @@GLOBAL.replicate_rewrite_db;
53 @@GLOBAL.replicate_rewrite_db
54
55 SET @@GLOBAL.replicate_rewrite_db=DEFAULT;
56 SELECT @@GLOBAL.replicate_rewrite_db;
57 @@GLOBAL.replicate_rewrite_db
58
59 SET @@GLOBAL.replicate_rewrite_db="db1->db3";
60 SELECT @@GLOBAL.replicate_rewrite_db;
61 @@GLOBAL.replicate_rewrite_db
62 db1->db3
63 SET @@GLOBAL.replicate_rewrite_db="db2 ->db4";
64 SELECT @@GLOBAL.replicate_rewrite_db;
65 @@GLOBAL.replicate_rewrite_db
66 db2->db4
67 SET @@GLOBAL.replicate_rewrite_db=" db5 ->db7 ";
68 SELECT @@GLOBAL.replicate_rewrite_db;
69 @@GLOBAL.replicate_rewrite_db
70 db5->db7
71 SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='replicate_rewrite_db';
72 VARIABLE_NAME VARIABLE_VALUE
73 REPLICATE_REWRITE_DB db5->db7
74 select * from information_schema.session_variables where variable_name='replicate_rewrite_db';
75 VARIABLE_NAME VARIABLE_VALUE
76 REPLICATE_REWRITE_DB db5->db7
77 show global variables like 'replicate_rewrite_db';
78 Variable_name Value
79 replicate_rewrite_db db5->db7
80 SET @@GLOBAL.replicate_rewrite_db="db1->db2, db3->db4";
81 SELECT @@GLOBAL.replicate_rewrite_db;
82 @@GLOBAL.replicate_rewrite_db
83 db1->db2,db3->db4
84 SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='replicate_rewrite_db';
85 VARIABLE_NAME VARIABLE_VALUE
86 REPLICATE_REWRITE_DB db1->db2,db3->db4
87 # Check restart with appending the value
88 # restart: --replicate_rewrite_db='X->Y'
89 SELECT @@GLOBAL.replicate_rewrite_db;
90 @@GLOBAL.replicate_rewrite_db
91 test->rewrite,mysqltest1->test,a->b,'X->Y'
92 # Check restart with wrong value on CLI
93 [ERROR] Bad syntax in replicate-rewrite-db.Expected syntax is FROM->TO.
94 # restart
95 SELECT @@GLOBAL.replicate_rewrite_db;
96 @@GLOBAL.replicate_rewrite_db
97 test->rewrite,mysqltest1->test,a->b