Debian Codegraph @

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

raw
1 call mtr.add_suppression("duplicate variable name");
2 INSTALL COMPONENT "file://component_test_sys_var_service";
3 SELECT VARIABLE_NAME, MIN_VALUE, MAX_VALUE FROM performance_schema.variables_info
4 WHERE VARIABLE_NAME LIKE '%component%'
5 ORDER BY VARIABLE_NAME;
6 VARIABLE_NAME MIN_VALUE MAX_VALUE
7 test_component.bool_ro_sys_var 0 0
8 test_component.bool_sys_var 0 0
9 test_component.enum_sys_var 0 0
10 test_component.int_sys_var 0 1024
11 test_component.long_sys_var 10 100
12 test_component.longlong_sys_var 1000 8192819281928192
13 test_component.str_sys_var 0 0
14 test_component.str_sys_var_default 0 0
15 test_component.uint_sys_var 10 10241024
16 test_component.ulong_sys_var 1000 81928192
17 test_component.ulonglong_sys_var 1000 8192819281928192
18 SET GLOBAL test_component.str_sys_var="Before crash";
19 SET GLOBAL test_component.int_sys_var=123;
20 SELECT @@test_component.str_sys_var;
21 @@test_component.str_sys_var
22 Before crash
23 SELECT @@test_component.int_sys_var;
24 @@test_component.int_sys_var
25 123
26 # Kill and restart
27 SELECT VARIABLE_NAME, MIN_VALUE, MAX_VALUE FROM performance_schema.variables_info
28 WHERE VARIABLE_NAME LIKE '%component%'
29 ORDER BY VARIABLE_NAME;
30 VARIABLE_NAME MIN_VALUE MAX_VALUE
31 test_component.bool_ro_sys_var 0 0
32 test_component.bool_sys_var 0 0
33 test_component.enum_sys_var 0 0
34 test_component.int_sys_var 0 1024
35 test_component.long_sys_var 10 100
36 test_component.longlong_sys_var 1000 8192819281928192
37 test_component.str_sys_var 0 0
38 test_component.str_sys_var_default 0 0
39 test_component.uint_sys_var 10 10241024
40 test_component.ulong_sys_var 1000 81928192
41 test_component.ulonglong_sys_var 1000 8192819281928192
42 SELECT @@test_component.str_sys_var;
43 @@test_component.str_sys_var
44 NULL
45 SELECT @@test_component.int_sys_var;
46 @@test_component.int_sys_var
47 8
48 SET PERSIST test_component.int_sys_var=7;
49 SELECT @@test_component.int_sys_var;
50 @@test_component.int_sys_var
51 7
52 # Kill and restart
53 SELECT @@test_component.int_sys_var;
54 @@test_component.int_sys_var
55 7
56 SELECT @@test_component.str_sys_var;
57 @@test_component.str_sys_var
58 NULL
59 RESET PERSIST;
60 UNINSTALL COMPONENT "file://component_test_sys_var_service";