Debian Codegraph @

mysql-test/suite/sys_vars/t/offline_mode_basic.test

raw
1 ###############################################################################
2 # #
3 # File containing basic tests for offline mode variable #
4 # #
5 ###############################################################################
6
7
8 --echo #
9 --echo # Variable name : offline_mode
10 --echo # Scope : Global
11 --echo #
12
13 --echo # Global - default
14 SELECT @@global.offline_mode;
15 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
16 SELECT @@session.offline_mode;
17 --echo
18
19 --error ER_WRONG_VALUE_FOR_VAR
20 SET @@global.offline_mode= 'true';
21 --echo
22
23 --error ER_WRONG_VALUE_FOR_VAR
24 SET @@global.offline_mode= 100;
25 --echo
26
27 --error ER_WRONG_VALUE_FOR_VAR
28 SET @@global.offline_mode= WRONGVALUE;
29 --echo
30
31 --echo # via performance_schema.global_variables
32 --disable_warnings
33 SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME LIKE 'offline_mode';
34 --enable_warnings
35
36 # Save the global value to be used to restore the original value.
37 SET @global_saved_tmp = @@global.offline_mode;
38 --echo
39
40 --echo # Altering global variable's value
41 SET @@global.offline_mode = 0;
42 SELECT @@global.offline_mode;
43
44 SET @@global.offline_mode = TrUe;
45 SELECT @@global.offline_mode;
46
47 SET @@global.offline_mode = FaLsE;
48 SELECT @@global.offline_mode;
49 --echo
50
51 --echo # Variables' values in a new session.
52 connect (con1,"127.0.0.1",root,,test,$MASTER_MYPORT,);
53
54 --echo # Global - expect 0
55 SELECT @@global.offline_mode;
56 --echo
57
58 --echo # Switching to the default connection.
59 connection default;
60
61 SELECT @@global.offline_mode;
62 --echo
63
64 --echo # Test if DEFAULT is working as expected.
65 SET @@global.offline_mode = DEFAULT;
66 --echo
67
68 --echo # Global - expect 0
69 SELECT @@global.offline_mode;
70 --echo
71
72 --echo # Restoring the original values.
73 SET @@global.offline_mode = @global_saved_tmp;
74
75 --echo # End of tests.
76