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