Debian Codegraph @

mysql-test/suite/sys_vars/r/max_allowed_packet_basic.result

raw
1 SET @start_global_value = @@global.max_allowed_packet;
2 SELECT @start_global_value;
3 @start_global_value
4 67108864
5 SET @@global.max_allowed_packet = DEFAULT;
6 '#--------------------FN_DYNVARS_070_01-------------------------#'
7 SET @@global.max_allowed_packet = 1000;
8 Warnings:
9 Warning 1292 Truncated incorrect max_allowed_packet value: '1000'
10 Warning 1708 The value of 'max_allowed_packet' should be no less than the value of 'net_buffer_length'
11 SET @@global.max_allowed_packet = DEFAULT;
12 SELECT @@global.max_allowed_packet;
13 @@global.max_allowed_packet
14 67108864
15 SET @@session.max_allowed_packet = 20000;
16 ERROR HY000: SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value
17 SET @@session.max_allowed_packet = DEFAULT;
18 ERROR HY000: SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value
19 SELECT @@session.max_allowed_packet;
20 @@session.max_allowed_packet
21 67108864
22 '#--------------------FN_DYNVARS_070_02-------------------------#'
23 SET @@global.max_allowed_packet = DEFAULT;
24 SELECT @@global.max_allowed_packet = 67108864;
25 @@global.max_allowed_packet = 67108864
26 1
27 '#--------------------FN_DYNVARS_070_03-------------------------#'
28 SET @@global.max_allowed_packet = 1024;
29 Warnings:
30 Warning 1708 The value of 'max_allowed_packet' should be no less than the value of 'net_buffer_length'
31 SELECT @@global.max_allowed_packet;
32 @@global.max_allowed_packet
33 1024
34 SET @@global.max_allowed_packet = 1025;
35 Warnings:
36 Warning 1292 Truncated incorrect max_allowed_packet value: '1025'
37 Warning 1708 The value of 'max_allowed_packet' should be no less than the value of 'net_buffer_length'
38 SELECT @@global.max_allowed_packet;
39 @@global.max_allowed_packet
40 1024
41 SET @@global.max_allowed_packet = 1073741824;
42 SELECT @@global.max_allowed_packet;
43 @@global.max_allowed_packet
44 1073741824
45 SET @@global.max_allowed_packet = 1073741823;
46 Warnings:
47 Warning 1292 Truncated incorrect max_allowed_packet value: '1073741823'
48 SELECT @@global.max_allowed_packet;
49 @@global.max_allowed_packet
50 1073740800
51 '#--------------------FN_DYNVARS_070_04-------------------------#'
52 SET @@session.max_allowed_packet = 1024;
53 ERROR HY000: SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value
54 SELECT @@session.max_allowed_packet;
55 @@session.max_allowed_packet
56 67108864
57 SET @@session.max_allowed_packet = 1025;
58 ERROR HY000: SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value
59 SELECT @@session.max_allowed_packet;
60 @@session.max_allowed_packet
61 67108864
62 SET @@session.max_allowed_packet = 65535;
63 ERROR HY000: SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value
64 SELECT @@session.max_allowed_packet;
65 @@session.max_allowed_packet
66 67108864
67 SET @@session.max_allowed_packet = 1073741824;
68 ERROR HY000: SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value
69 SELECT @@session.max_allowed_packet;
70 @@session.max_allowed_packet
71 67108864
72 SET @@session.max_allowed_packet = 1073741823;
73 ERROR HY000: SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value
74 SELECT @@session.max_allowed_packet;
75 @@session.max_allowed_packet
76 67108864
77 '#------------------FN_DYNVARS_070_05-----------------------#'
78 SET @@global.max_allowed_packet = 0;
79 Warnings:
80 Warning 1292 Truncated incorrect max_allowed_packet value: '0'
81 Warning 1708 The value of 'max_allowed_packet' should be no less than the value of 'net_buffer_length'
82 SELECT @@global.max_allowed_packet;
83 @@global.max_allowed_packet
84 1024
85 SET @@global.max_allowed_packet = -1024;
86 Warnings:
87 Warning 1292 Truncated incorrect max_allowed_packet value: '-1024'
88 Warning 1708 The value of 'max_allowed_packet' should be no less than the value of 'net_buffer_length'
89 SELECT @@global.max_allowed_packet;
90 @@global.max_allowed_packet
91 1024
92 SET @@global.max_allowed_packet = 1023;
93 Warnings:
94 Warning 1292 Truncated incorrect max_allowed_packet value: '1023'
95 Warning 1708 The value of 'max_allowed_packet' should be no less than the value of 'net_buffer_length'
96 SELECT @@global.max_allowed_packet;
97 @@global.max_allowed_packet
98 1024
99 SET @@global.max_allowed_packet = 10737418241;
100 Warnings:
101 Warning 1292 Truncated incorrect max_allowed_packet value: '10737418241'
102 SELECT @@global.max_allowed_packet;
103 @@global.max_allowed_packet
104 1073741824
105 SET @@global.max_allowed_packet = 1073741826;
106 Warnings:
107 Warning 1292 Truncated incorrect max_allowed_packet value: '1073741826'
108 SELECT @@global.max_allowed_packet;
109 @@global.max_allowed_packet
110 1073741824
111 SET @@global.max_allowed_packet = 65530.34;
112 ERROR 42000: Incorrect argument type to variable 'max_allowed_packet'
113 SELECT @@global.max_allowed_packet;
114 @@global.max_allowed_packet
115 1073741824
116 SET @@global.max_allowed_packet = test;
117 ERROR 42000: Incorrect argument type to variable 'max_allowed_packet'
118 SELECT @@global.max_allowed_packet;
119 @@global.max_allowed_packet
120 1073741824
121 SET @@global.max_allowed_packet = ' ';
122 ERROR 42000: Incorrect argument type to variable 'max_allowed_packet'
123 SELECT @@global.max_allowed_packet;
124 @@global.max_allowed_packet
125 1073741824
126 SET @@session.max_allowed_packet = 0;
127 ERROR HY000: SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value
128 SELECT @@session.max_allowed_packet;
129 @@session.max_allowed_packet
130 67108864
131 SET @@session.max_allowed_packet = 1023;
132 ERROR HY000: SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value
133 SELECT @@session.max_allowed_packet;
134 @@session.max_allowed_packet
135 67108864
136 SET @@session.max_allowed_packet = -2;
137 ERROR HY000: SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value
138 SELECT @@session.max_allowed_packet;
139 @@session.max_allowed_packet
140 67108864
141 SET @@session.max_allowed_packet = 65530.34;
142 ERROR 42000: Incorrect argument type to variable 'max_allowed_packet'
143 SET @@session.max_allowed_packet = 10737418241;
144 ERROR HY000: SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value
145 SELECT @@session.max_allowed_packet;
146 @@session.max_allowed_packet
147 67108864
148 SET @@session.max_allowed_packet = test;
149 ERROR 42000: Incorrect argument type to variable 'max_allowed_packet'
150 SELECT @@session.max_allowed_packet;
151 @@session.max_allowed_packet
152 67108864
153 SET @@session.max_allowed_packet = ' ';
154 ERROR 42000: Incorrect argument type to variable 'max_allowed_packet'
155 SELECT @@session.max_allowed_packet;
156 @@session.max_allowed_packet
157 67108864
158 '#------------------FN_DYNVARS_070_06-----------------------#'
159 SELECT @@global.max_allowed_packet = VARIABLE_VALUE
160 FROM performance_schema.global_variables
161 WHERE VARIABLE_NAME='max_allowed_packet';
162 @@global.max_allowed_packet = VARIABLE_VALUE
163 1
164 '#------------------FN_DYNVARS_070_07-----------------------#'
165 SELECT @@session.max_allowed_packet = VARIABLE_VALUE
166 FROM performance_schema.session_variables
167 WHERE VARIABLE_NAME='max_allowed_packet';
168 @@session.max_allowed_packet = VARIABLE_VALUE
169 1
170 '#------------------FN_DYNVARS_070_08-----------------------#'
171 SET @@global.max_allowed_packet = TRUE;
172 Warnings:
173 Warning 1292 Truncated incorrect max_allowed_packet value: '1'
174 Warning 1708 The value of 'max_allowed_packet' should be no less than the value of 'net_buffer_length'
175 SELECT @@global.max_allowed_packet;
176 @@global.max_allowed_packet
177 1024
178 SET @@global.max_allowed_packet = FALSE;
179 Warnings:
180 Warning 1292 Truncated incorrect max_allowed_packet value: '0'
181 Warning 1708 The value of 'max_allowed_packet' should be no less than the value of 'net_buffer_length'
182 SELECT @@global.max_allowed_packet;
183 @@global.max_allowed_packet
184 1024
185 '#---------------------FN_DYNVARS_070_09----------------------#'
186 SET @@global.max_allowed_packet = 2048;
187 Warnings:
188 Warning 1708 The value of 'max_allowed_packet' should be no less than the value of 'net_buffer_length'
189 SELECT @@max_allowed_packet = @@global.max_allowed_packet;
190 @@max_allowed_packet = @@global.max_allowed_packet
191 0
192 '#---------------------FN_DYNVARS_070_10----------------------#'
193 SET @@max_allowed_packet = 100000;
194 ERROR HY000: SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value
195 SELECT @@max_allowed_packet = @@local.max_allowed_packet;
196 @@max_allowed_packet = @@local.max_allowed_packet
197 1
198 SELECT @@local.max_allowed_packet = @@session.max_allowed_packet;
199 @@local.max_allowed_packet = @@session.max_allowed_packet
200 1
201 '#---------------------FN_DYNVARS_070_11----------------------#'
202 SET max_allowed_packet = 1024;
203 ERROR HY000: SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value
204 SELECT @@max_allowed_packet;
205 @@max_allowed_packet
206 67108864
207 SELECT local.max_allowed_packet;
208 ERROR 42S02: Unknown table 'local' in field list
209 SELECT session.max_allowed_packet;
210 ERROR 42S02: Unknown table 'session' in field list
211 SELECT max_allowed_packet = @@session.max_allowed_packet;
212 ERROR 42S22: Unknown column 'max_allowed_packet' in 'field list'
213 SET @@global.max_allowed_packet = @start_global_value;
214 SELECT @@global.max_allowed_packet;
215 @@global.max_allowed_packet
216 67108864
217 SELECT @@session.max_allowed_packet;
218 @@session.max_allowed_packet
219 67108864