← Back to branch summary

~jlukas79/+junk/mysql-server

« back to all changes in this revision

Viewing changes to mysql-test/r/max_allowed_packet_basic.result

manual merge 6.0-main --> 6.0-bka-review

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/max_allowed_packet_basic.result
 
1
SET @start_global_value = @@global.max_allowed_packet;
 
2
SELECT @start_global_value;
 
3
@start_global_value
 
4
1048576
 
5
SET @start_session_value = @@session.max_allowed_packet;
 
6
SELECT @start_session_value;
 
7
@start_session_value
 
8
1048576
 
9
'#--------------------FN_DYNVARS_070_01-------------------------#'
 
10
SET @@global.max_allowed_packet = 1000;
 
11
Warnings:
 
12
Warning 1292    Truncated incorrect max_allowed_packet value: '1000'
 
13
SET @@global.max_allowed_packet = DEFAULT;
 
14
SELECT @@global.max_allowed_packet;
 
15
@@global.max_allowed_packet
 
16
1048576
 
17
SET @@session.max_allowed_packet = 20000;
 
18
SET @@session.max_allowed_packet = DEFAULT;
 
19
SELECT @@session.max_allowed_packet;
 
20
@@session.max_allowed_packet
 
21
1048576
 
22
'#--------------------FN_DYNVARS_070_02-------------------------#'
 
23
SET @@global.max_allowed_packet = DEFAULT;
 
24
SELECT @@global.max_allowed_packet = 1048576;
 
25
@@global.max_allowed_packet = 1048576
 
26
1
 
27
SET @@session.max_allowed_packet = DEFAULT;
 
28
SELECT @@session.max_allowed_packet = 1048576;
 
29
@@session.max_allowed_packet = 1048576
 
30
1
 
31
'#--------------------FN_DYNVARS_070_03-------------------------#'
 
32
SET @@global.max_allowed_packet = 1024;
 
33
SELECT @@global.max_allowed_packet;
 
34
@@global.max_allowed_packet
 
35
1024
 
36
SET @@global.max_allowed_packet = 1025;
 
37
SELECT @@global.max_allowed_packet;
 
38
@@global.max_allowed_packet
 
39
1024
 
40
: 'Bug# 34841:  "Invalid values are coming in variable on assigning valid value';
 
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
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
SELECT @@session.max_allowed_packet;
 
52
@@session.max_allowed_packet
 
53
1024
 
54
SET @@session.max_allowed_packet = 1025;
 
55
SELECT @@session.max_allowed_packet;
 
56
@@session.max_allowed_packet
 
57
1024
 
58
SET @@session.max_allowed_packet = 65535;
 
59
SELECT @@session.max_allowed_packet;
 
60
@@session.max_allowed_packet
 
61
64512
 
62
SET @@session.max_allowed_packet = 1073741824;
 
63
SELECT @@session.max_allowed_packet;
 
64
@@session.max_allowed_packet
 
65
1073741824
 
66
SET @@session.max_allowed_packet = 1073741823;
 
67
SELECT @@session.max_allowed_packet;
 
68
@@session.max_allowed_packet
 
69
1073740800
 
70
'#------------------FN_DYNVARS_070_05-----------------------#'
 
71
SET @@global.max_allowed_packet = 0;
 
72
Warnings:
 
73
Warning 1292    Truncated incorrect max_allowed_packet value: '0'
 
74
SELECT @@global.max_allowed_packet;
 
75
@@global.max_allowed_packet
 
76
1024
 
77
SET @@global.max_allowed_packet = -1024;
 
78
Warnings:
 
79
Warning 1292    Truncated incorrect max_allowed_packet value: '0'
 
80
SELECT @@global.max_allowed_packet;
 
81
@@global.max_allowed_packet
 
82
1024
 
83
SET @@global.max_allowed_packet = 1023;
 
84
Warnings:
 
85
Warning 1292    Truncated incorrect max_allowed_packet value: '1023'
 
86
SELECT @@global.max_allowed_packet;
 
87
@@global.max_allowed_packet
 
88
1024
 
89
SET @@global.max_allowed_packet = 10737418241;
 
90
Warnings:
 
91
Warning 1292    Truncated incorrect max_allowed_packet value: '10737418241'
 
92
SELECT @@global.max_allowed_packet;
 
93
@@global.max_allowed_packet
 
94
1073741824
 
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
 
99
1073741824
 
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
 
104
1073741824
 
105
SET @@session.max_allowed_packet = 0;
 
106
Warnings:
 
107
Warning 1292    Truncated incorrect max_allowed_packet value: '0'
 
108
SELECT @@session.max_allowed_packet;
 
109
@@session.max_allowed_packet
 
110
1024
 
111
SET @@session.max_allowed_packet = 1023;
 
112
Warnings:
 
113
Warning 1292    Truncated incorrect max_allowed_packet value: '1023'
 
114
SELECT @@session.max_allowed_packet;
 
115
@@session.max_allowed_packet
 
116
1024
 
117
SET @@session.max_allowed_packet = -2;
 
118
Warnings:
 
119
Warning 1292    Truncated incorrect max_allowed_packet value: '0'
 
120
SELECT @@session.max_allowed_packet;
 
121
@@session.max_allowed_packet
 
122
1024
 
123
SET @@session.max_allowed_packet = 65530.34.;
 
124
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
 
125
SET @@session.max_allowed_packet = 10737418241;
 
126
Warnings:
 
127
Warning 1292    Truncated incorrect max_allowed_packet value: '10737418241'
 
128
SELECT @@session.max_allowed_packet;
 
129
@@session.max_allowed_packet
 
130
1073741824
 
131
'Bug # 34837: Errors are not coming on assigning invalid values to variable';
 
132
SET @@session.max_allowed_packet = test;
 
133
ERROR 42000: Incorrect argument type to variable 'max_allowed_packet'
 
134
SELECT @@session.max_allowed_packet;
 
135
@@session.max_allowed_packet
 
136
1073741824
 
137
'#------------------FN_DYNVARS_070_06-----------------------#'
 
138
SELECT @@global.max_allowed_packet = VARIABLE_VALUE 
 
139
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 
 
140
WHERE VARIABLE_NAME='max_allowed_packet';
 
141
@@global.max_allowed_packet = VARIABLE_VALUE
 
142
1
 
143
'#------------------FN_DYNVARS_070_07-----------------------#'
 
144
SELECT @@session.max_allowed_packet = VARIABLE_VALUE 
 
145
FROM INFORMATION_SCHEMA.SESSION_VARIABLES 
 
146
WHERE VARIABLE_NAME='max_allowed_packet';
 
147
@@session.max_allowed_packet = VARIABLE_VALUE
 
148
1
 
149
'#------------------FN_DYNVARS_070_08-----------------------#'
 
150
SET @@global.max_allowed_packet = TRUE;
 
151
Warnings:
 
152
Warning 1292    Truncated incorrect max_allowed_packet value: '1'
 
153
SELECT @@global.max_allowed_packet;
 
154
@@global.max_allowed_packet
 
155
1024
 
156
SET @@global.max_allowed_packet = FALSE;
 
157
Warnings:
 
158
Warning 1292    Truncated incorrect max_allowed_packet value: '0'
 
159
SELECT @@global.max_allowed_packet;
 
160
@@global.max_allowed_packet
 
161
1024
 
162
'#---------------------FN_DYNVARS_070_09----------------------#'
 
163
SET @@global.max_allowed_packet = 2048;
 
164
SELECT @@max_allowed_packet = @@global.max_allowed_packet;
 
165
@@max_allowed_packet = @@global.max_allowed_packet
 
166
0
 
167
'#---------------------FN_DYNVARS_070_10----------------------#'
 
168
SET @@max_allowed_packet = 100000;
 
169
SELECT @@max_allowed_packet = @@local.max_allowed_packet;
 
170
@@max_allowed_packet = @@local.max_allowed_packet
 
171
1
 
172
SELECT @@local.max_allowed_packet = @@session.max_allowed_packet;
 
173
@@local.max_allowed_packet = @@session.max_allowed_packet
 
174
1
 
175
'#---------------------FN_DYNVARS_070_11----------------------#'
 
176
SET max_allowed_packet = 1024;
 
177
SELECT @@max_allowed_packet;
 
178
@@max_allowed_packet
 
179
1024
 
180
SELECT local.max_allowed_packet;
 
181
ERROR 42S02: Unknown table 'local' in field list
 
182
SELECT session.max_allowed_packet;
 
183
ERROR 42S02: Unknown table 'session' in field list
 
184
SELECT max_allowed_packet = @@session.max_allowed_packet;
 
185
ERROR 42S22: Unknown column 'max_allowed_packet' in 'field list'
 
186
SET @@global.max_allowed_packet = @start_global_value;
 
187
SELECT @@global.max_allowed_packet;
 
188
@@global.max_allowed_packet
 
189
1048576
 
190
SET @@session.max_allowed_packet = @start_session_value;
 
191
SELECT @@session.max_allowed_packet;
 
192
@@session.max_allowed_packet
 
193
1048576