Debian Codegraph @

mysql-test/suite/sys_vars/r/aria_recover_options_basic.result

raw
1 SET @start_global_value = @@global.aria_recover_options;
2 set @@global.aria_recover_options=default;
3 select @@global.aria_recover_options;
4 @@global.aria_recover_options
5 BACKUP,QUICK
6 select @@session.aria_recover_options;
7 ERROR HY000: Variable 'aria_recover_options' is a GLOBAL variable
8 show global variables like 'aria_recover_options';
9 Variable_name Value
10 aria_recover_options BACKUP,QUICK
11 show session variables like 'aria_recover_options';
12 Variable_name Value
13 aria_recover_options BACKUP,QUICK
14 select * from information_schema.global_variables where variable_name='aria_recover_options';
15 VARIABLE_NAME VARIABLE_VALUE
16 ARIA_RECOVER_OPTIONS BACKUP,QUICK
17 select * from information_schema.session_variables where variable_name='aria_recover_options';
18 VARIABLE_NAME VARIABLE_VALUE
19 ARIA_RECOVER_OPTIONS BACKUP,QUICK
20 set global aria_recover_options=1;
21 select @@global.aria_recover_options;
22 @@global.aria_recover_options
23 NORMAL
24 set session aria_recover_options=1;
25 ERROR HY000: Variable 'aria_recover_options' is a GLOBAL variable and should be set with SET GLOBAL
26 set global aria_recover_options=normal;
27 select @@global.aria_recover_options;
28 @@global.aria_recover_options
29 NORMAL
30 set global aria_recover_options=backup;
31 select @@global.aria_recover_options;
32 @@global.aria_recover_options
33 BACKUP
34 set global aria_recover_options='force';
35 select @@global.aria_recover_options;
36 @@global.aria_recover_options
37 FORCE
38 set global aria_recover_options=off;
39 select @@global.aria_recover_options;
40 @@global.aria_recover_options
41 OFF
42 set global aria_recover_options='quick,force';
43 select @@global.aria_recover_options;
44 @@global.aria_recover_options
45 FORCE,QUICK
46 set global aria_recover_options=16;
47 select @@global.aria_recover_options;
48 @@global.aria_recover_options
49 OFF
50 set global aria_recover_options=1.1;
51 ERROR 42000: Incorrect argument type to variable 'aria_recover_options'
52 set global aria_recover_options=1e1;
53 ERROR 42000: Incorrect argument type to variable 'aria_recover_options'
54 set global aria_recover_options="foo";
55 ERROR 42000: Variable 'aria_recover_options' can't be set to the value of 'foo'
56 set global aria_recover_options=32;
57 ERROR 42000: Variable 'aria_recover_options' can't be set to the value of '32'
58 SET @@global.aria_recover_options = @start_global_value;