Debian Codegraph @

mysql-test/suite/sys_vars/inc/global_boolean_var_basic.inc

raw
1 #
2 # This checks if a given global boolean variable exists and works.
3 #
4
5 --echo # Save default value.
6
7 eval SET @default_var_value = @@GLOBAL.$var_name;
8
9 eval SELECT @@GLOBAL.$var_name;
10
11 --echo # Try setting to 1.
12
13 eval SET @@GLOBAL.$var_name = 1;
14
15 eval SELECT @@GLOBAL.$var_name;
16
17 --echo # Try setting to 0.
18
19 eval SET @@GLOBAL.$var_name = 0;
20
21 eval SELECT @@GLOBAL.$var_name;
22
23 --echo # Try setting to 1 (again).
24
25 eval SET @@GLOBAL.$var_name = 1;
26
27 eval SELECT @@GLOBAL.$var_name;
28
29 --echo # Try setting to 0 (again).
30
31 eval SET @@GLOBAL.$var_name = 0;
32
33 eval SELECT @@GLOBAL.$var_name;
34
35 --echo # Check what happens if we set the same value as current.
36
37 eval SET @@GLOBAL.$var_name = 1;
38
39 eval SET @@GLOBAL.$var_name = 1;
40
41 eval SET @@GLOBAL.$var_name = 0;
42
43 eval SET @@GLOBAL.$var_name = 0;
44
45 --echo # Try using variable as local.
46
47 --error ER_GLOBAL_VARIABLE
48 eval SET $var_name = 1;
49
50 --echo # Finished. Restore default value.
51
52 eval SET @@GLOBAL.$var_name = @default_var_value;