Debian Codegraph @

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

raw
1 #
2 # Variable name : offline_mode
3 # Scope : Global
4 #
5 # Global - default
6 SELECT @@global.offline_mode;
7 @@global.offline_mode
8 0
9 SELECT @@session.offline_mode;
10 ERROR HY000: Variable 'offline_mode' is a GLOBAL variable
11
12 SET @@global.offline_mode= 'true';
13 ERROR 42000: Variable 'offline_mode' can't be set to the value of 'true'
14
15 SET @@global.offline_mode= 100;
16 ERROR 42000: Variable 'offline_mode' can't be set to the value of '100'
17
18 SET @@global.offline_mode= WRONGVALUE;
19 ERROR 42000: Variable 'offline_mode' can't be set to the value of 'WRONGVALUE'
20
21 # via performance_schema.global_variables
22 SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME LIKE 'offline_mode';
23 VARIABLE_NAME VARIABLE_VALUE
24 offline_mode OFF
25 SET @global_saved_tmp = @@global.offline_mode;
26
27 # Altering global variable's value
28 SET @@global.offline_mode = 0;
29 SELECT @@global.offline_mode;
30 @@global.offline_mode
31 0
32 SET @@global.offline_mode = TrUe;
33 SELECT @@global.offline_mode;
34 @@global.offline_mode
35 1
36 SET @@global.offline_mode = FaLsE;
37 SELECT @@global.offline_mode;
38 @@global.offline_mode
39 0
40
41 # Variables' values in a new session.
42 # Global - expect 0
43 SELECT @@global.offline_mode;
44 @@global.offline_mode
45 0
46
47 # Switching to the default connection.
48 SELECT @@global.offline_mode;
49 @@global.offline_mode
50 0
51
52 # Test if DEFAULT is working as expected.
53 SET @@global.offline_mode = DEFAULT;
54
55 # Global - expect 0
56 SELECT @@global.offline_mode;
57 @@global.offline_mode
58 0
59
60 # Restoring the original values.
61 SET @@global.offline_mode = @global_saved_tmp;
62 # End of tests.