Debian Codegraph @

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

raw
1 # Shows that by component registered system variables survive a crash like global or
2 # persistent variables.
3
4 --source ../include/have_component_test_sys_var_service.inc
5
6 call mtr.add_suppression("duplicate variable name");
7 INSTALL COMPONENT "file://component_test_sys_var_service";
8
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
13 SET GLOBAL test_component.str_sys_var="Before crash";
14 SET GLOBAL test_component.int_sys_var=123;
15
16 SELECT @@test_component.str_sys_var;
17 SELECT @@test_component.int_sys_var;
18
19 --source include/kill_and_restart_mysqld.inc
20
21 SELECT VARIABLE_NAME, MIN_VALUE, MAX_VALUE FROM performance_schema.variables_info
22 WHERE VARIABLE_NAME LIKE '%component%'
23 ORDER BY VARIABLE_NAME;
24
25 SELECT @@test_component.str_sys_var;
26 SELECT @@test_component.int_sys_var;
27
28 SET PERSIST test_component.int_sys_var=7;
29 SELECT @@test_component.int_sys_var;
30
31 --source include/kill_and_restart_mysqld.inc
32
33 SELECT @@test_component.int_sys_var;
34 SELECT @@test_component.str_sys_var;
35
36 RESET PERSIST;
37
38 UNINSTALL COMPONENT "file://component_test_sys_var_service";
39
40 let $MYSQLD_DATADIR= `select @@datadir`;
41 remove_file $MYSQLD_DATADIR/test_component_sys_var_service.log;