Debian Codegraph @

mysql-test/suite/service_sys_var_registration/r/rpl_sys_var_reg_diff.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 call mtr.add_suppression("duplicate variable name");
7 # Simple load test
8 INSTALL COMPONENT "file://component_test_sys_var_service";
9 SELECT VARIABLE_NAME, MIN_VALUE, MAX_VALUE FROM performance_schema.variables_info
10 WHERE VARIABLE_NAME LIKE '%component%'
11 ORDER BY VARIABLE_NAME;
12 VARIABLE_NAME MIN_VALUE MAX_VALUE
13 test_component.bool_ro_sys_var 0 0
14 test_component.bool_sys_var 0 0
15 test_component.enum_sys_var 0 0
16 test_component.int_sys_var 0 1024
17 test_component.long_sys_var 10 100
18 test_component.longlong_sys_var 1000 8192819281928192
19 test_component.str_sys_var 0 0
20 test_component.str_sys_var_default 0 0
21 test_component.uint_sys_var 10 10241024
22 test_component.ulong_sys_var 1000 81928192
23 test_component.ulonglong_sys_var 1000 8192819281928192
24 # Testing integer and bool type variable
25 SELECT @@test_component.int_sys_var;
26 @@test_component.int_sys_var
27 8
28 SELECT @@global.test_component.int_sys_var;
29 @@global.test_component.int_sys_var
30 8
31 SELECT @@global.test_component.bool_sys_var;
32 @@global.test_component.bool_sys_var
33 1
34 SELECT @@test_component.int_sys_var, @@test_component.bool_sys_var;
35 @@test_component.int_sys_var @@test_component.bool_sys_var
36 8 1
37 SET test_component.bool_sys_var=1;
38 ERROR HY000: Variable 'test_component.bool_sys_var' is a GLOBAL variable and should be set with SET GLOBAL
39 SET GLOBAL test_component.int_sys_var=7;
40 SET GLOBAL test_component.int_sys_var=1234567;
41 Warnings:
42 Warning 1292 Truncated incorrect test_component.int_sys_var value: '1234567'
43 SELECT @@test_component.int_sys_var;
44 @@test_component.int_sys_var
45 1024
46 SET GLOBAL test_component.int_sys_var=-1;
47 Warnings:
48 Warning 1292 Truncated incorrect test_component.int_sys_var value: '-1'
49 SELECT @@test_component.int_sys_var;
50 @@test_component.int_sys_var
51 0
52 SET GLOBAL test_component.int_sys_var=1.25;
53 ERROR 42000: Incorrect argument type to variable 'test_component.int_sys_var'
54 SET GLOBAL test_component.int_sys_var="hello";
55 ERROR 42000: Incorrect argument type to variable 'test_component.int_sys_var'
56 SET GLOBAL test_component.int_sys_var=123, test_component.bool_sys_var=0;
57 SELECT @@test_component.int_sys_var, @@test_component.bool_sys_var;
58 @@test_component.int_sys_var @@test_component.bool_sys_var
59 123 0
60 SET SESSION test_component.int_sys_var=123;
61 ERROR HY000: Variable 'test_component.int_sys_var' is a GLOBAL variable and should be set with SET GLOBAL
62 # Testing enum type variable
63 SELECT @@test_component.enum_sys_var;
64 @@test_component.enum_sys_var
65 MEDIUM
66 SET GLOBAL test_component.enum_sys_var="LOW";
67 SELECT @@test_component.enum_sys_var;
68 @@test_component.enum_sys_var
69 LOW
70 # Testing string type variable
71 SELECT @@test_component.str_sys_var;
72 @@test_component.str_sys_var
73 NULL
74 SET GLOBAL test_component.str_sys_var="dictionary.txt";
75 SELECT @@test_component.str_sys_var;
76 @@test_component.str_sys_var
77 dictionary.txt
78 SET GLOBAL test_component.str_sys_var=default;
79 SELECT @@test_component.str_sys_var;
80 @@test_component.str_sys_var
81 NULL
82 # Testing unsigned integer type variable
83 SELECT @@test_component.uint_sys_var;
84 @@test_component.uint_sys_var
85 1024
86 SET GLOBAL test_component.uint_sys_var=12345678;
87 Warnings:
88 Warning 1292 Truncated incorrect test_component.uint_sys_var value: '12345678'
89 SELECT @@test_component.uint_sys_var;
90 @@test_component.uint_sys_var
91 10241024
92 SET GLOBAL test_component.uint_sys_var=default;
93 SELECT @@test_component.uint_sys_var;
94 @@test_component.uint_sys_var
95 1024
96 # Testing long type variable
97 SELECT @@test_component.long_sys_var;
98 @@test_component.long_sys_var
99 100
100 SET GLOBAL test_component.long_sys_var=1234567890;
101 Warnings:
102 Warning 1292 Truncated incorrect test_component.long_sys_var value: '1234567890'
103 SELECT @@test_component.long_sys_var;
104 @@test_component.long_sys_var
105 100
106 SET GLOBAL test_component.long_sys_var=default;
107 SELECT @@test_component.long_sys_var;
108 @@test_component.long_sys_var
109 100
110 # Testing unsigned long type variable
111 SELECT @@test_component.ulong_sys_var;
112 @@test_component.ulong_sys_var
113 8192
114 SET GLOBAL test_component.ulong_sys_var=1234567890;
115 Warnings:
116 Warning 1292 Truncated incorrect test_component.ulong_sys_var value: '1234567890'
117 SELECT @@test_component.ulong_sys_var;
118 @@test_component.ulong_sys_var
119 81928192
120 SET GLOBAL test_component.ulong_sys_var=default;
121 SELECT @@test_component.ulong_sys_var;
122 @@test_component.ulong_sys_var
123 8192
124 # Testing long long type variable
125 SELECT @@test_component.longlong_sys_var;
126 @@test_component.longlong_sys_var
127 8192
128 SET GLOBAL test_component.longlong_sys_var=1234567890;
129 SELECT @@test_component.longlong_sys_var;
130 @@test_component.longlong_sys_var
131 1234567890
132 SET GLOBAL test_component.longlong_sys_var=default;
133 SELECT @@test_component.longlong_sys_var;
134 @@test_component.longlong_sys_var
135 8192
136 # Testing unsigned long long type variable
137 SELECT @@test_component.ulonglong_sys_var;
138 @@test_component.ulonglong_sys_var
139 8192
140 SET GLOBAL test_component.ulonglong_sys_var=1234567890;
141 SELECT @@test_component.ulonglong_sys_var;
142 @@test_component.ulonglong_sys_var
143 1234567890
144 SET GLOBAL test_component.ulonglong_sys_var=default;
145 SELECT @@test_component.ulonglong_sys_var;
146 @@test_component.ulonglong_sys_var
147 8192
148 # Testing PERSIST for component system variables
149 SET PERSIST test_component.int_sys_var=7;
150 SELECT @@test_component.int_sys_var;
151 @@test_component.int_sys_var
152 7
153 SELECT * FROM performance_schema.persisted_variables;
154 VARIABLE_NAME VARIABLE_VALUE
155 test_component.int_sys_var 7
156 RESET PERSIST `test_component.int_sys_var`;
157 SELECT * FROM performance_schema.persisted_variables;
158 VARIABLE_NAME VARIABLE_VALUE
159 sync_slave_with_master;
160 connection slave;
161 INSTALL COMPONENT "file://component_test_sys_var_service_str";
162 SELECT VARIABLE_NAME, MIN_VALUE, MAX_VALUE FROM performance_schema.variables_info
163 WHERE VARIABLE_NAME LIKE '%component%'
164 ORDER BY VARIABLE_NAME;
165 VARIABLE_NAME MIN_VALUE MAX_VALUE
166 test_component_str.str_sys_var 0 0
167 SET GLOBAL test_component_int.int_sys_var=7;
168 ERROR HY000: Unknown system variable 'test_component_int.int_sys_var'
169 SET GLOBAL test_component_str.str_sys_var="salve.txt";
170 SELECT @@test_component_int.int_sys_var;
171 ERROR HY000: Unknown system variable 'test_component_int.int_sys_var'
172 SELECT @@test_component_str.str_sys_var;
173 @@test_component_str.str_sys_var
174 salve.txt
175 UNINSTALL COMPONENT "file://component_test_sys_var_service_str";
176 connection master;
177 UNINSTALL COMPONENT "file://component_test_sys_var_service";
178 include/rpl_end.inc