Debian Codegraph @

mysql-test/suite/service_sys_var_registration/t/rpl_sys_var_reg_diff.test

raw
1 # Test to verfy that registered system variables of components behave like normal system variables
2 # in rpl configrations. On master and slave different components register system variables.
3
4 --source ../include/have_component_test_sys_var_service.inc
5
6 --source include/master-slave.inc
7
8 call mtr.add_suppression("duplicate variable name");
9 --echo # Simple load test
10 INSTALL COMPONENT "file://component_test_sys_var_service";
11
12 SELECT VARIABLE_NAME, MIN_VALUE, MAX_VALUE FROM performance_schema.variables_info
13 WHERE VARIABLE_NAME LIKE '%component%'
14 ORDER BY VARIABLE_NAME;
15
16 --echo # Testing integer and bool type variable
17 SELECT @@test_component.int_sys_var;
18 SELECT @@global.test_component.int_sys_var;
19 SELECT @@global.test_component.bool_sys_var;
20 SELECT @@test_component.int_sys_var, @@test_component.bool_sys_var;
21 --error 1229
22 SET test_component.bool_sys_var=1;
23 SET GLOBAL test_component.int_sys_var=7;
24 # The max value for the test_component.int_sys_var is 1024. Hence below SET
25 # stmt will set the value to 1024.
26 SET GLOBAL test_component.int_sys_var=1234567;
27 SELECT @@test_component.int_sys_var;
28 # The min value for the test_component.int_sys_var is 0. Hence below SET stmt
29 # will set the value to 0.
30 SET GLOBAL test_component.int_sys_var=-1;
31 SELECT @@test_component.int_sys_var;
32 --error 1232
33 SET GLOBAL test_component.int_sys_var=1.25;
34 --error 1232
35 SET GLOBAL test_component.int_sys_var="hello";
36 SET GLOBAL test_component.int_sys_var=123, test_component.bool_sys_var=0;
37 SELECT @@test_component.int_sys_var, @@test_component.bool_sys_var;
38 --error 1229
39 SET SESSION test_component.int_sys_var=123;
40
41 --echo # Testing enum type variable
42 SELECT @@test_component.enum_sys_var;
43 SET GLOBAL test_component.enum_sys_var="LOW";
44 SELECT @@test_component.enum_sys_var;
45
46 --echo # Testing string type variable
47 SELECT @@test_component.str_sys_var;
48 SET GLOBAL test_component.str_sys_var="dictionary.txt";
49 SELECT @@test_component.str_sys_var;
50 SET GLOBAL test_component.str_sys_var=default;
51 SELECT @@test_component.str_sys_var;
52
53 --echo # Testing unsigned integer type variable
54 SELECT @@test_component.uint_sys_var;
55 SET GLOBAL test_component.uint_sys_var=12345678;
56 SELECT @@test_component.uint_sys_var;
57 SET GLOBAL test_component.uint_sys_var=default;
58 SELECT @@test_component.uint_sys_var;
59
60 --echo # Testing long type variable
61 SELECT @@test_component.long_sys_var;
62 SET GLOBAL test_component.long_sys_var=1234567890;
63 SELECT @@test_component.long_sys_var;
64 SET GLOBAL test_component.long_sys_var=default;
65 SELECT @@test_component.long_sys_var;
66
67 --echo # Testing unsigned long type variable
68 SELECT @@test_component.ulong_sys_var;
69 SET GLOBAL test_component.ulong_sys_var=1234567890;
70 SELECT @@test_component.ulong_sys_var;
71 SET GLOBAL test_component.ulong_sys_var=default;
72 SELECT @@test_component.ulong_sys_var;
73
74 --echo # Testing long long type variable
75 SELECT @@test_component.longlong_sys_var;
76 SET GLOBAL test_component.longlong_sys_var=1234567890;
77 SELECT @@test_component.longlong_sys_var;
78 SET GLOBAL test_component.longlong_sys_var=default;
79 SELECT @@test_component.longlong_sys_var;
80
81 --echo # Testing unsigned long long type variable
82 SELECT @@test_component.ulonglong_sys_var;
83 SET GLOBAL test_component.ulonglong_sys_var=1234567890;
84 SELECT @@test_component.ulonglong_sys_var;
85 SET GLOBAL test_component.ulonglong_sys_var=default;
86 SELECT @@test_component.ulonglong_sys_var;
87
88 --echo # Testing PERSIST for component system variables
89 SET PERSIST test_component.int_sys_var=7;
90 SELECT @@test_component.int_sys_var;
91 SELECT * FROM performance_schema.persisted_variables;
92 RESET PERSIST `test_component.int_sys_var`;
93 SELECT * FROM performance_schema.persisted_variables;
94
95 --echo sync_slave_with_master;
96 sync_slave_with_master;
97
98 --echo connection slave;
99 connection slave;
100 INSTALL COMPONENT "file://component_test_sys_var_service_str";
101
102 SELECT VARIABLE_NAME, MIN_VALUE, MAX_VALUE FROM performance_schema.variables_info
103 WHERE VARIABLE_NAME LIKE '%component%'
104 ORDER BY VARIABLE_NAME;
105
106 --error 1193
107 SET GLOBAL test_component_int.int_sys_var=7;
108 SET GLOBAL test_component_str.str_sys_var="salve.txt";
109 --error 1193
110 SELECT @@test_component_int.int_sys_var;
111 SELECT @@test_component_str.str_sys_var;
112
113 UNINSTALL COMPONENT "file://component_test_sys_var_service_str";
114
115 --echo connection master;
116 connection master;
117 UNINSTALL COMPONENT "file://component_test_sys_var_service";
118
119 sync_slave_with_master;
120 --source include/rpl_end.inc