Debian Codegraph @

mysql-test/suite/service_status_var_registration/r/status_var_service_con.result

raw
1 SET @start_value= @@global.wait_timeout;
2 SET @@global.wait_timeout= 2;
3 CREATE USER 'testuser'@'localhost' IDENTIFIED BY 'pw';
4 INSTALL COMPONENT "file://component_test_status_var_service";
5 SHOW STATUS WHERE VARIABLE_NAME LIKE 'test_component.int_variable';
6 connect con1,localhost,root,,;
7 SHOW STATUS WHERE VARIABLE_NAME LIKE '%component%';
8 connect con2,localhost,testuser,'pw',;
9 SHOW STATUS WHERE VARIABLE_NAME LIKE '%component%';
10 connection default;
11 Variable_name Value
12 connection con1;
13 Variable_name Value
14 Com_install_component 0
15 Com_uninstall_component 0
16 test_component.array_var1 MySQL
17 test_component.array_var2 8.000000
18 test_component.bool_var ON
19 test_component.char_ptr_var Testing CHAR_PTR for status vars
20 test_component.char_var Testing CHAR status variable
21 test_component.double_var 8.000000
22 test_component.func_var Testing SHOW_FUNC type for component status variables
23 test_component.int_var 7
24 test_component.long_var 1234567
25 test_component.longlong_var 123456789
26 connection con2;
27 Variable_name Value
28 Com_install_component 0
29 Com_uninstall_component 0
30 test_component.array_var1 MySQL
31 test_component.array_var2 8.000000
32 test_component.bool_var ON
33 test_component.char_ptr_var Testing CHAR_PTR for status vars
34 test_component.char_var Testing CHAR status variable
35 test_component.double_var 8.000000
36 test_component.func_var Testing SHOW_FUNC type for component status variables
37 test_component.int_var 7
38 test_component.long_var 1234567
39 test_component.longlong_var 123456789
40 connection default;
41 disconnect con1;
42 disconnect con2;
43 UNINSTALL COMPONENT "file://component_test_status_var_service";
44 DROP USER 'testuser'@'localhost';
45 SET @@global.wait_timeout= @start_value;
46 ########## test_component_status_var_service.log:
47 test_component_status_var init:
48 test_component_status_var end of init:
49 test_component_status_var deinit:
50 test_component_status_var_service end of deinit: