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