Debian Codegraph @

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

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