1
SET @start_global_value = @@global.max_heap_table_size;
2
SELECT @start_global_value;
5
SET @start_session_value = @@session.max_heap_table_size;
6
SELECT @start_session_value;
9
'#--------------------FN_DYNVARS_077_01-------------------------#'
10
SET @@global.max_heap_table_size = 1677721610;
11
SET @@global.max_heap_table_size = DEFAULT;
12
SELECT @@global.max_heap_table_size;
13
@@global.max_heap_table_size
15
SET @@session.max_heap_table_size = 1677721610;
16
SET @@session.max_heap_table_size = DEFAULT;
17
SELECT @@session.max_heap_table_size;
18
@@session.max_heap_table_size
20
'#--------------------FN_DYNVARS_077_02-------------------------#'
21
SET @@global.max_heap_table_size = DEFAULT;
22
SELECT @@global.max_heap_table_size = 16777216;
23
@@global.max_heap_table_size = 16777216
25
SET @@session.max_heap_table_size = DEFAULT;
26
SELECT @@session.max_heap_table_size = 16777216;
27
@@session.max_heap_table_size = 16777216
29
'#--------------------FN_DYNVARS_077_03-------------------------#'
30
SET @@global.max_heap_table_size = 16384;
31
SELECT @@global.max_heap_table_size;
32
@@global.max_heap_table_size
34
SET @@global.max_heap_table_size = 16385;
35
SELECT @@global.max_heap_table_size;
36
@@global.max_heap_table_size
38
SET @@global.max_heap_table_size = 65535;
39
SELECT @@global.max_heap_table_size;
40
@@global.max_heap_table_size
42
SET @@global.max_heap_table_size = 4294967294;
43
SELECT @@global.max_heap_table_size;
44
@@global.max_heap_table_size
46
SET @@global.max_heap_table_size = 4294967295;
47
SELECT @@global.max_heap_table_size;
48
@@global.max_heap_table_size
50
'Bug# 34877: Invalid Values are coming in variable on assigning valid values';
51
'#--------------------FN_DYNVARS_077_04-------------------------#'
52
SET @@session.max_heap_table_size = 16384;
53
SELECT @@session.max_heap_table_size;
54
@@session.max_heap_table_size
56
SET @@session.max_heap_table_size = 16385;
57
SELECT @@session.max_heap_table_size;
58
@@session.max_heap_table_size
60
SET @@session.max_heap_table_size = 65535;
61
SELECT @@session.max_heap_table_size;
62
@@session.max_heap_table_size
64
SET @@session.max_heap_table_size = 4294967294;
65
SELECT @@session.max_heap_table_size;
66
@@session.max_heap_table_size
68
SET @@session.max_heap_table_size = 4294967295;
69
SELECT @@session.max_heap_table_size;
70
@@session.max_heap_table_size
72
'Bug# 34877: Invalid Values are coming in variable on assigning valid values';
73
'#------------------FN_DYNVARS_077_05-----------------------#'
74
SET @@global.max_heap_table_size = -1;
76
Warning 1292 Truncated incorrect max_heap_table_size value: '0'
77
SELECT @@global.max_heap_table_size;
78
@@global.max_heap_table_size
80
SET @@global.max_heap_table_size = -1024;
82
Warning 1292 Truncated incorrect max_heap_table_size value: '0'
83
SELECT @@global.max_heap_table_size;
84
@@global.max_heap_table_size
86
SET @@global.max_heap_table_size = 1024;
88
Warning 1292 Truncated incorrect max_heap_table_size value: '1024'
89
SELECT @@global.max_heap_table_size;
90
@@global.max_heap_table_size
92
SET @@global.max_heap_table_size = 16383;
94
Warning 1292 Truncated incorrect max_heap_table_size value: '16383'
95
SELECT @@global.max_heap_table_size;
96
@@global.max_heap_table_size
98
SET @@global.max_heap_table_size = 4294967296;
99
SELECT @@global.max_heap_table_size;
100
@@global.max_heap_table_size
102
SET @@global.max_heap_table_size = 65530.34.;
103
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
104
SELECT @@global.max_heap_table_size;
105
@@global.max_heap_table_size
107
SET @@global.max_heap_table_size = test;
108
ERROR 42000: Incorrect argument type to variable 'max_heap_table_size'
109
SELECT @@global.max_heap_table_size;
110
@@global.max_heap_table_size
112
SET @@session.max_heap_table_size = -1;
114
Warning 1292 Truncated incorrect max_heap_table_size value: '0'
115
SELECT @@session.max_heap_table_size;
116
@@session.max_heap_table_size
118
SET @@session.max_heap_table_size = 16383;
120
Warning 1292 Truncated incorrect max_heap_table_size value: '16383'
121
SELECT @@session.max_heap_table_size;
122
@@session.max_heap_table_size
124
SET @@session.max_heap_table_size = 4294967296;
125
SELECT @@session.max_heap_table_size;
126
@@session.max_heap_table_size
128
SET @@session.max_heap_table_size = 65530.34.;
129
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
130
SET @@session.max_heap_table_size = 10737418241;
131
SELECT @@session.max_heap_table_size;
132
@@session.max_heap_table_size
134
'Bug # 34837: Errors are not coming on assigning invalid values to variable';
135
SET @@session.max_heap_table_size = test;
136
ERROR 42000: Incorrect argument type to variable 'max_heap_table_size'
137
SELECT @@session.max_heap_table_size;
138
@@session.max_heap_table_size
140
'#------------------FN_DYNVARS_077_06-----------------------#'
141
SELECT @@global.max_heap_table_size = VARIABLE_VALUE
142
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
143
WHERE VARIABLE_NAME='max_heap_table_size';
144
@@global.max_heap_table_size = VARIABLE_VALUE
146
'#------------------FN_DYNVARS_077_07-----------------------#'
147
SELECT @@session.max_heap_table_size = VARIABLE_VALUE
148
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
149
WHERE VARIABLE_NAME='max_heap_table_size';
150
@@session.max_heap_table_size = VARIABLE_VALUE
152
'#------------------FN_DYNVARS_077_08-----------------------#'
153
SET @@global.max_heap_table_size = TRUE;
155
Warning 1292 Truncated incorrect max_heap_table_size value: '1'
156
SELECT @@global.max_heap_table_size;
157
@@global.max_heap_table_size
159
SET @@global.max_heap_table_size = FALSE;
161
Warning 1292 Truncated incorrect max_heap_table_size value: '0'
162
SELECT @@global.max_heap_table_size;
163
@@global.max_heap_table_size
165
'#---------------------FN_DYNVARS_077_09----------------------#'
166
SET @@global.max_heap_table_size = 163845;
167
SELECT @@max_heap_table_size = @@global.max_heap_table_size;
168
@@max_heap_table_size = @@global.max_heap_table_size
170
'#---------------------FN_DYNVARS_077_10----------------------#'
171
SET @@max_heap_table_size = 16777216;
172
SELECT @@max_heap_table_size = @@local.max_heap_table_size;
173
@@max_heap_table_size = @@local.max_heap_table_size
175
SELECT @@local.max_heap_table_size = @@session.max_heap_table_size;
176
@@local.max_heap_table_size = @@session.max_heap_table_size
178
'#---------------------FN_DYNVARS_077_11----------------------#'
179
SET max_heap_table_size = 316777216;
180
SELECT @@max_heap_table_size;
181
@@max_heap_table_size
183
SELECT local.max_heap_table_size;
184
ERROR 42S02: Unknown table 'local' in field list
185
SELECT session.max_heap_table_size;
186
ERROR 42S02: Unknown table 'session' in field list
187
SELECT max_heap_table_size = @@session.max_heap_table_size;
188
ERROR 42S22: Unknown column 'max_heap_table_size' in 'field list'
189
SET @@global.max_heap_table_size = @start_global_value;
190
SELECT @@global.max_heap_table_size;
191
@@global.max_heap_table_size
193
SET @@session.max_heap_table_size = @start_session_value;
194
SELECT @@session.max_heap_table_size;
195
@@session.max_heap_table_size