1
SET @start_global_value = @@global.max_allowed_packet;
2
SELECT @start_global_value;
5
SET @@global.max_allowed_packet = DEFAULT;
6
'#--------------------FN_DYNVARS_070_01-------------------------#'
7
SET @@global.max_allowed_packet = 1000;
9
Warning 1292 Truncated incorrect max_allowed_packet value: '1000'
10
SET @@global.max_allowed_packet = DEFAULT;
11
SELECT @@global.max_allowed_packet;
12
@@global.max_allowed_packet
14
SET @@session.max_allowed_packet = 20000;
15
ERROR HY000: SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value
16
SET @@session.max_allowed_packet = DEFAULT;
17
ERROR 42000: Variable 'max_allowed_packet' doesn't have a default value
18
SELECT @@session.max_allowed_packet;
19
@@session.max_allowed_packet
21
'#--------------------FN_DYNVARS_070_02-------------------------#'
22
SET @@global.max_allowed_packet = DEFAULT;
23
SELECT @@global.max_allowed_packet = 1048576;
24
@@global.max_allowed_packet = 1048576
26
'#--------------------FN_DYNVARS_070_03-------------------------#'
27
SET @@global.max_allowed_packet = 1024;
28
SELECT @@global.max_allowed_packet;
29
@@global.max_allowed_packet
31
SET @@global.max_allowed_packet = 1025;
32
SELECT @@global.max_allowed_packet;
33
@@global.max_allowed_packet
35
: 'Bug# 34841: "Invalid values are coming in variable on assigning valid value';
36
SET @@global.max_allowed_packet = 1073741824;
37
SELECT @@global.max_allowed_packet;
38
@@global.max_allowed_packet
40
SET @@global.max_allowed_packet = 1073741823;
41
SELECT @@global.max_allowed_packet;
42
@@global.max_allowed_packet
44
'#--------------------FN_DYNVARS_070_04-------------------------#'
45
SET @@session.max_allowed_packet = 1024;
46
ERROR HY000: SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value
47
SELECT @@session.max_allowed_packet;
48
@@session.max_allowed_packet
50
SET @@session.max_allowed_packet = 1025;
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
55
SET @@session.max_allowed_packet = 65535;
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
60
SET @@session.max_allowed_packet = 1073741824;
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
65
SET @@session.max_allowed_packet = 1073741823;
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
70
'#------------------FN_DYNVARS_070_05-----------------------#'
71
SET @@global.max_allowed_packet = 0;
73
Warning 1292 Truncated incorrect max_allowed_packet value: '0'
74
SELECT @@global.max_allowed_packet;
75
@@global.max_allowed_packet
77
SET @@global.max_allowed_packet = -1024;
79
Warning 1292 Truncated incorrect max_allowed_packet value: '0'
80
SELECT @@global.max_allowed_packet;
81
@@global.max_allowed_packet
83
SET @@global.max_allowed_packet = 1023;
85
Warning 1292 Truncated incorrect max_allowed_packet value: '1023'
86
SELECT @@global.max_allowed_packet;
87
@@global.max_allowed_packet
89
SET @@global.max_allowed_packet = 10737418241;
91
Warning 1292 Truncated incorrect max_allowed_packet value: '10737418241'
92
SELECT @@global.max_allowed_packet;
93
@@global.max_allowed_packet
95
SET @@global.max_allowed_packet = 65530.34.;
96
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.' at line 1
97
SELECT @@global.max_allowed_packet;
98
@@global.max_allowed_packet
100
SET @@global.max_allowed_packet = test;
101
ERROR 42000: Incorrect argument type to variable 'max_allowed_packet'
102
SELECT @@global.max_allowed_packet;
103
@@global.max_allowed_packet
105
SET @@session.max_allowed_packet = 0;
106
ERROR HY000: SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value
107
SELECT @@session.max_allowed_packet;
108
@@session.max_allowed_packet
110
SET @@session.max_allowed_packet = 1023;
111
ERROR HY000: SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value
112
SELECT @@session.max_allowed_packet;
113
@@session.max_allowed_packet
115
SET @@session.max_allowed_packet = -2;
116
ERROR HY000: SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value
117
SELECT @@session.max_allowed_packet;
118
@@session.max_allowed_packet
120
SET @@session.max_allowed_packet = 65530.34.;
121
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.' at line 1
122
SET @@session.max_allowed_packet = 10737418241;
123
ERROR HY000: SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value
124
SELECT @@session.max_allowed_packet;
125
@@session.max_allowed_packet
127
'Bug # 34837: Errors are not coming on assigning invalid values to variable';
128
SET @@session.max_allowed_packet = test;
129
ERROR 42000: Incorrect argument type to variable 'max_allowed_packet'
130
SELECT @@session.max_allowed_packet;
131
@@session.max_allowed_packet
133
'#------------------FN_DYNVARS_070_06-----------------------#'
134
SELECT @@global.max_allowed_packet = VARIABLE_VALUE
135
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
136
WHERE VARIABLE_NAME='max_allowed_packet';
137
@@global.max_allowed_packet = VARIABLE_VALUE
139
'#------------------FN_DYNVARS_070_07-----------------------#'
140
SELECT @@session.max_allowed_packet = VARIABLE_VALUE
141
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
142
WHERE VARIABLE_NAME='max_allowed_packet';
143
@@session.max_allowed_packet = VARIABLE_VALUE
145
'#------------------FN_DYNVARS_070_08-----------------------#'
146
SET @@global.max_allowed_packet = TRUE;
148
Warning 1292 Truncated incorrect max_allowed_packet value: '1'
149
SELECT @@global.max_allowed_packet;
150
@@global.max_allowed_packet
152
SET @@global.max_allowed_packet = FALSE;
154
Warning 1292 Truncated incorrect max_allowed_packet value: '0'
155
SELECT @@global.max_allowed_packet;
156
@@global.max_allowed_packet
158
'#---------------------FN_DYNVARS_070_09----------------------#'
159
SET @@global.max_allowed_packet = 2048;
160
SELECT @@max_allowed_packet = @@global.max_allowed_packet;
161
@@max_allowed_packet = @@global.max_allowed_packet
163
'#---------------------FN_DYNVARS_070_10----------------------#'
164
SET @@max_allowed_packet = 100000;
165
ERROR HY000: SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value
166
SELECT @@max_allowed_packet = @@local.max_allowed_packet;
167
@@max_allowed_packet = @@local.max_allowed_packet
169
SELECT @@local.max_allowed_packet = @@session.max_allowed_packet;
170
@@local.max_allowed_packet = @@session.max_allowed_packet
172
'#---------------------FN_DYNVARS_070_11----------------------#'
173
SET max_allowed_packet = 1024;
174
ERROR HY000: SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value
175
SELECT @@max_allowed_packet;
178
SELECT local.max_allowed_packet;
179
ERROR 42S02: Unknown table 'local' in field list
180
SELECT session.max_allowed_packet;
181
ERROR 42S02: Unknown table 'session' in field list
182
SELECT max_allowed_packet = @@session.max_allowed_packet;
183
ERROR 42S22: Unknown column 'max_allowed_packet' in 'field list'
184
SET @@global.max_allowed_packet = @start_global_value;
185
SELECT @@global.max_allowed_packet;
186
@@global.max_allowed_packet
188
SELECT @@session.max_allowed_packet;
189
@@session.max_allowed_packet