Debian Codegraph @

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

raw
1 call mtr.add_suppression("duplicate variable name");
2 call mtr.add_suppression("variable name.*not found");
3 # Simple load test
4 INSTALL COMPONENT "file://component_test_sys_var_service";
5 INSTALL COMPONENT "file://component_test_sys_var_service_same";
6 # Testing enum type variable
7 SELECT @@test_component.enum_sys_var;
8 @@test_component.enum_sys_var
9 MEDIUM
10 SET GLOBAL test_component.enum_sys_var="LOW";
11 SELECT @@test_component.enum_sys_var;
12 @@test_component.enum_sys_var
13 LOW
14 # Testing string type variable
15 SELECT @@test_component.str_sys_var;
16 @@test_component.str_sys_var
17 NULL
18 SET GLOBAL test_component.str_sys_var="dictionary.txt";
19 SELECT @@test_component.str_sys_var;
20 @@test_component.str_sys_var
21 dictionary.txt
22 SET GLOBAL test_component.str_sys_var=default;
23 SELECT @@test_component.str_sys_var;
24 @@test_component.str_sys_var
25 NULL
26 # Testing unsigned integer type variable
27 SELECT @@test_component.uint_sys_var;
28 @@test_component.uint_sys_var
29 1024
30 SET GLOBAL test_component.uint_sys_var=12345678;
31 Warnings:
32 Warning 1292 Truncated incorrect test_component.uint_sys_var value: '12345678'
33 SELECT @@test_component.uint_sys_var;
34 @@test_component.uint_sys_var
35 10241024
36 SET GLOBAL test_component.uint_sys_var=default;
37 SELECT @@test_component.uint_sys_var;
38 @@test_component.uint_sys_var
39 1024
40 # Testing long type variable
41 SELECT @@test_component.long_sys_var;
42 @@test_component.long_sys_var
43 100
44 SET GLOBAL test_component.long_sys_var=1234567890;
45 Warnings:
46 Warning 1292 Truncated incorrect test_component.long_sys_var value: '1234567890'
47 SELECT @@test_component.long_sys_var;
48 @@test_component.long_sys_var
49 100
50 SET GLOBAL test_component.long_sys_var=default;
51 SELECT @@test_component.long_sys_var;
52 @@test_component.long_sys_var
53 100
54 # Testing unsigned long type variable
55 SELECT @@test_component.ulong_sys_var;
56 @@test_component.ulong_sys_var
57 8192
58 SET GLOBAL test_component.ulong_sys_var=1234567890;
59 Warnings:
60 Warning 1292 Truncated incorrect test_component.ulong_sys_var value: '1234567890'
61 SELECT @@test_component.ulong_sys_var;
62 @@test_component.ulong_sys_var
63 81928192
64 SET GLOBAL test_component.ulong_sys_var=default;
65 SELECT @@test_component.ulong_sys_var;
66 @@test_component.ulong_sys_var
67 8192
68 # Testing long long type variable
69 SELECT @@test_component.longlong_sys_var;
70 @@test_component.longlong_sys_var
71 8192
72 SET GLOBAL test_component.longlong_sys_var=1234567890;
73 SELECT @@test_component.longlong_sys_var;
74 @@test_component.longlong_sys_var
75 1234567890
76 SET GLOBAL test_component.longlong_sys_var=default;
77 SELECT @@test_component.longlong_sys_var;
78 @@test_component.longlong_sys_var
79 8192
80 UNINSTALL COMPONENT "file://component_test_sys_var_service";
81 UNINSTALL COMPONENT "file://component_test_sys_var_service_same";
82 ########## test_component_sys_var_service.log:
83 test_component_sys_var init:
84 int register_variable failed.
85 variable value : 8
86 variable value : 1024
87 variable value : 100
88 variable value : 8192
89 variable value : 8192
90 variable value : 8192
91 variable value : ON
92 variable value : MEDIUM
93 variable value :
94 test_component_sys_var end of init:
95 test_component_sys_var deinit:
96 test_component_sys_var end of deinit:
97 ########## test_component_sys_var_service_same.log:
98 test_component_sys_var_same init:
99 int register_variable failed.
100 int register_variable failed.
101 uint register_variable failed.
102 long register_variable failed.
103 ulong register_variable failed.
104 longlong register_variable failed.
105 unsigned longlong register_variable failed.
106 register_variable failed.
107 register_variable failed.
108 register_variable failed.
109 variable value : 8
110 End of init
111 test_component_sys_var_same deinit:
112 int unregister_variable failed.
113 unsigned int unregister_variable failed.
114 long unregister_variable failed.
115 unsigned long unregister_variable failed.
116 longlong unregister_variable failed.
117 unsigned longlong unregister_variable failed.
118 unregister_variable failed.
119 unregister_variable failed.
120 unregister_variable failed.
121 unregister_variable failed.