77 lines
1.9 KiB
Plaintext
77 lines
1.9 KiB
Plaintext
###############################################################################
|
|
# #
|
|
# File containing basic tests for offline mode variable #
|
|
# #
|
|
###############################################################################
|
|
|
|
|
|
--echo #
|
|
--echo # Variable name : offline_mode
|
|
--echo # Scope : Global
|
|
--echo #
|
|
|
|
--echo # Global - default
|
|
SELECT @@global.offline_mode;
|
|
--error ER_INCORRECT_GLOBAL_LOCAL_VAR
|
|
SELECT @@session.offline_mode;
|
|
--echo
|
|
|
|
--error ER_WRONG_VALUE_FOR_VAR
|
|
SET @@global.offline_mode= 'true';
|
|
--echo
|
|
|
|
--error ER_WRONG_VALUE_FOR_VAR
|
|
SET @@global.offline_mode= 100;
|
|
--echo
|
|
|
|
--error ER_WRONG_VALUE_FOR_VAR
|
|
SET @@global.offline_mode= WRONGVALUE;
|
|
--echo
|
|
|
|
--echo # via performance_schema.global_variables
|
|
--disable_warnings
|
|
SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME LIKE 'offline_mode';
|
|
--enable_warnings
|
|
|
|
# Save the global value to be used to restore the original value.
|
|
SET @global_saved_tmp = @@global.offline_mode;
|
|
--echo
|
|
|
|
--echo # Altering global variable's value
|
|
SET @@global.offline_mode = 0;
|
|
SELECT @@global.offline_mode;
|
|
|
|
SET @@global.offline_mode = TrUe;
|
|
SELECT @@global.offline_mode;
|
|
|
|
SET @@global.offline_mode = FaLsE;
|
|
SELECT @@global.offline_mode;
|
|
--echo
|
|
|
|
--echo # Variables' values in a new session.
|
|
connect (con1,"127.0.0.1",root,,test,$MASTER_MYPORT,);
|
|
|
|
--echo # Global - expect 0
|
|
SELECT @@global.offline_mode;
|
|
--echo
|
|
|
|
--echo # Switching to the default connection.
|
|
connection default;
|
|
|
|
SELECT @@global.offline_mode;
|
|
--echo
|
|
|
|
--echo # Test if DEFAULT is working as expected.
|
|
SET @@global.offline_mode = DEFAULT;
|
|
--echo
|
|
|
|
--echo # Global - expect 0
|
|
SELECT @@global.offline_mode;
|
|
--echo
|
|
|
|
--echo # Restoring the original values.
|
|
SET @@global.offline_mode = @global_saved_tmp;
|
|
|
|
--echo # End of tests.
|
|
|