sys_vars/t/read_only_basic.test

3 # Variable Name: read_only                                                    #
14 # Description: Test Cases of Dynamic System Variable read_only                #
30 #                    START OF read_only TESTS                  #
35 # Saving initial value of read_only in a temporary variable    #
38 SET @start_value = @@global.read_only;
44 #              Display the DEFAULT value of read_only          #
47 SET @@global.read_only = 1;
48 SET @@global.read_only = DEFAULT;
49 SELECT @@global.read_only;
57 SET @@global.read_only = @start_value;
58 SELECT @@global.read_only = 0;
63 #        Change the value of read_only to a valid value         #
66 SET @@global.read_only = 0;
67 SELECT @@global.read_only;
68 SET @@global.read_only = 1;
69 SELECT @@global.read_only;
70 SET @@global.read_only = TRUE;
71 SELECT @@global.read_only;
72 SET @@global.read_only = FALSE;
73 SELECT @@global.read_only;
74 SET @@global.read_only = ON;
75 SELECT @@global.read_only;
76 SET @@global.read_only = OFF;
77 SELECT @@global.read_only;
81 #         Change the value of read_only to invalid value           #
85 SET @@global.read_only = -1;
86 SELECT @@global.read_only;
88 SET @@global.read_only = 4294967296;
89 SELECT @@global.read_only;
91 SET @@global.read_only = 10240022115;
92 SELECT @@global.read_only;
94 SET @@global.read_only = 10000.01;
95 SELECT @@global.read_only;
97 SET @@global.read_only = -1024;
98 SELECT @@global.read_only;
100 SET @@global.read_only = 42949672950;
101 SELECT @@global.read_only;
104 SET @@global.read_only = 'test';
105 SELECT @@global.read_only;
110 #       Test if accessing session read_only gives error            #
114 SET @@session.read_only = 0;
115 SELECT @@read_only;
123 SELECT IF(@@global.read_only, "ON", "OFF") = VARIABLE_VALUE
125 WHERE VARIABLE_NAME='read_only';
127 SELECT IF(@@read_only, "ON", "OFF") = VARIABLE_VALUE
129 WHERE VARIABLE_NAME='read_only';
137 SET @@global.read_only = 1;
138 SELECT @@read_only = @@global.read_only;
143 #   Check if read_only can be accessed with and without @@ sign   #
147 SET read_only = 1;
148 SELECT @@read_only;
150 SELECT local.read_only;
152 SELECT global.read_only;
154 SELECT read_only = @@session.read_only;
161 SET @@global.read_only = @start_value;
162 SELECT @@global.read_only;
166 #              END OF read_only TESTS                           #