Debian Codegraph @

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

raw
1 ############## mysql-test\t\max_allowed_packet_basic.test ###############
2 # #
3 # Variable Name: max_allowed_packet #
4 # Scope: GLOBAL | SESSION #
5 # Access Type: Dynamic #
6 # Data Type: numeric #
7 # Default Value:67108864 #
8 # Range:1024-1073741824 #
9 # #
10 # #
11 # Creation Date: 2008-02-07 #
12 # Author: Salman #
13 # #
14 # Description: Test Cases of Dynamic System Variable max_allowed_packet #
15 # that checks the behavior of this variable in the following ways#
16 # * Default Value #
17 # * Valid & Invalid values #
18 # * Scope & Access method #
19 # * Data Integrity #
20 # #
21 # Reference: http://dev.mysql.com/doc/refman/5.1/en/ #
22 # server-system-variables.html #
23 # #
24 ###############################################################################
25
26 --source include/load_sysvars.inc
27
28 ##################################################################
29 # START OF max_allowed_packet TESTS #
30 ##################################################################
31
32
33 #############################################################
34 # Save initial value #
35 #############################################################
36
37 SET @start_global_value = @@global.max_allowed_packet;
38 SELECT @start_global_value;
39
40 # give a known value to @@session.max_allowed_packet by assigning to
41 # @@global and setting up a new connection (for deterministic result
42 # file diffing)
43 SET @@global.max_allowed_packet = DEFAULT;
44 connect (conn1, localhost, root,,);
45
46
47
48 --echo '#--------------------FN_DYNVARS_070_01-------------------------#'
49 ##################################################################
50 # Display the DEFAULT value of max_allowed_packet #
51 ##################################################################
52
53 SET @@global.max_allowed_packet = 1000;
54 SET @@global.max_allowed_packet = DEFAULT;
55 SELECT @@global.max_allowed_packet;
56
57 --Error ER_VARIABLE_IS_READONLY
58 SET @@session.max_allowed_packet = 20000;
59 --Error ER_VARIABLE_IS_READONLY
60 SET @@session.max_allowed_packet = DEFAULT;
61 SELECT @@session.max_allowed_packet;
62
63
64 --echo '#--------------------FN_DYNVARS_070_02-------------------------#'
65 ##################################################################
66 # Check the DEFAULT value of max_allowed_packet #
67 ##################################################################
68
69 SET @@global.max_allowed_packet = DEFAULT;
70 SELECT @@global.max_allowed_packet = 67108864;
71
72
73 --echo '#--------------------FN_DYNVARS_070_03-------------------------#'
74 ############################################################################
75 # Change the value of max_allowed_packet to a valid value for GLOBAL Scope #
76 ############################################################################
77
78 SET @@global.max_allowed_packet = 1024;
79 SELECT @@global.max_allowed_packet;
80 SET @@global.max_allowed_packet = 1025;
81 SELECT @@global.max_allowed_packet;
82 SET @@global.max_allowed_packet = 1073741824;
83 SELECT @@global.max_allowed_packet;
84 SET @@global.max_allowed_packet = 1073741823;
85 SELECT @@global.max_allowed_packet;
86
87 --echo '#--------------------FN_DYNVARS_070_04-------------------------#'
88 #############################################################################
89 # Change the value of max_allowed_packet to a valid value for SESSION Scope #
90 #############################################################################
91
92 --Error ER_VARIABLE_IS_READONLY
93 SET @@session.max_allowed_packet = 1024;
94 SELECT @@session.max_allowed_packet;
95 --Error ER_VARIABLE_IS_READONLY
96 SET @@session.max_allowed_packet = 1025;
97 SELECT @@session.max_allowed_packet;
98 --Error ER_VARIABLE_IS_READONLY
99 SET @@session.max_allowed_packet = 65535;
100 SELECT @@session.max_allowed_packet;
101 --Error ER_VARIABLE_IS_READONLY
102 SET @@session.max_allowed_packet = 1073741824;
103 SELECT @@session.max_allowed_packet;
104 --Error ER_VARIABLE_IS_READONLY
105 SET @@session.max_allowed_packet = 1073741823;
106 SELECT @@session.max_allowed_packet;
107
108
109 --echo '#------------------FN_DYNVARS_070_05-----------------------#'
110 ##############################################################
111 # Change the value of max_allowed_packet to an invalid value #
112 ##############################################################
113
114 SET @@global.max_allowed_packet = 0;
115 SELECT @@global.max_allowed_packet;
116 SET @@global.max_allowed_packet = -1024;
117 SELECT @@global.max_allowed_packet;
118 SET @@global.max_allowed_packet = 1023;
119 SELECT @@global.max_allowed_packet;
120 SET @@global.max_allowed_packet = 10737418241;
121 SELECT @@global.max_allowed_packet;
122 SET @@global.max_allowed_packet = 1073741826;
123 SELECT @@global.max_allowed_packet;
124
125 --Error ER_WRONG_TYPE_FOR_VAR
126 SET @@global.max_allowed_packet = 65530.34;
127 SELECT @@global.max_allowed_packet;
128 --Error ER_WRONG_TYPE_FOR_VAR
129 SET @@global.max_allowed_packet = test;
130 SELECT @@global.max_allowed_packet;
131 --Error ER_WRONG_TYPE_FOR_VAR
132 SET @@global.max_allowed_packet = ' ';
133 SELECT @@global.max_allowed_packet;
134 --Error ER_VARIABLE_IS_READONLY
135 SET @@session.max_allowed_packet = 0;
136 SELECT @@session.max_allowed_packet;
137 --Error ER_VARIABLE_IS_READONLY
138 SET @@session.max_allowed_packet = 1023;
139 SELECT @@session.max_allowed_packet;
140 --Error ER_VARIABLE_IS_READONLY
141 SET @@session.max_allowed_packet = -2;
142 SELECT @@session.max_allowed_packet;
143 --Error ER_WRONG_TYPE_FOR_VAR
144 SET @@session.max_allowed_packet = 65530.34;
145 --Error ER_VARIABLE_IS_READONLY
146 SET @@session.max_allowed_packet = 10737418241;
147 SELECT @@session.max_allowed_packet;
148
149 --Error ER_WRONG_TYPE_FOR_VAR
150 SET @@session.max_allowed_packet = test;
151 SELECT @@session.max_allowed_packet;
152 --Error ER_WRONG_TYPE_FOR_VAR
153 SET @@session.max_allowed_packet = ' ';
154 SELECT @@session.max_allowed_packet;
155
156
157 --echo '#------------------FN_DYNVARS_070_06-----------------------#'
158 ####################################################################
159 # Check if the value in GLOBAL Table matches value in variable #
160 ####################################################################
161
162
163 --disable_warnings
164 SELECT @@global.max_allowed_packet = VARIABLE_VALUE
165 FROM performance_schema.global_variables
166 WHERE VARIABLE_NAME='max_allowed_packet';
167 --enable_warnings
168
169 --echo '#------------------FN_DYNVARS_070_07-----------------------#'
170 ####################################################################
171 # Check if the value in SESSION Table matches value in variable #
172 ####################################################################
173
174 --disable_warnings
175 SELECT @@session.max_allowed_packet = VARIABLE_VALUE
176 FROM performance_schema.session_variables
177 WHERE VARIABLE_NAME='max_allowed_packet';
178 --enable_warnings
179
180
181 --echo '#------------------FN_DYNVARS_070_08-----------------------#'
182 ####################################################################
183 # Check if TRUE and FALSE values can be used on variable #
184 ####################################################################
185
186 SET @@global.max_allowed_packet = TRUE;
187 SELECT @@global.max_allowed_packet;
188 SET @@global.max_allowed_packet = FALSE;
189 SELECT @@global.max_allowed_packet;
190
191
192 --echo '#---------------------FN_DYNVARS_070_09----------------------#'
193 #################################################################################
194 # Check if accessing variable with and without GLOBAL point to same variable #
195 #################################################################################
196
197 SET @@global.max_allowed_packet = 2048;
198 SELECT @@max_allowed_packet = @@global.max_allowed_packet;
199
200
201 --echo '#---------------------FN_DYNVARS_070_10----------------------#'
202 ########################################################################################################
203 # Check if accessing variable with SESSION,LOCAL and without SCOPE points to same session variable #
204 ########################################################################################################
205
206 --Error ER_VARIABLE_IS_READONLY
207 SET @@max_allowed_packet = 100000;
208 SELECT @@max_allowed_packet = @@local.max_allowed_packet;
209 SELECT @@local.max_allowed_packet = @@session.max_allowed_packet;
210
211
212 --echo '#---------------------FN_DYNVARS_070_11----------------------#'
213 #############################################################################
214 # Check if max_allowed_packet can be accessed with and without @@ sign #
215 #############################################################################
216
217 --Error ER_VARIABLE_IS_READONLY
218 SET max_allowed_packet = 1024;
219 SELECT @@max_allowed_packet;
220 --Error ER_UNKNOWN_TABLE
221 SELECT local.max_allowed_packet;
222 --Error ER_UNKNOWN_TABLE
223 SELECT session.max_allowed_packet;
224 --Error ER_BAD_FIELD_ERROR
225 SELECT max_allowed_packet = @@session.max_allowed_packet;
226
227
228 ####################################
229 # Restore initial value #
230 ####################################
231
232 connection default;
233 SET @@global.max_allowed_packet = @start_global_value;
234 SELECT @@global.max_allowed_packet;
235 SELECT @@session.max_allowed_packet;
236
237
238 #######################################################
239 # END OF max_allowed_packet TESTS #
240 #######################################################
241