Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.max_heap_table_size;
2 SELECT @start_global_value;
3 @start_global_value
4 16777216
5 SET @start_session_value = @@session.max_heap_table_size;
6 SELECT @start_session_value;
7 @start_session_value
8 16777216
9 '#--------------------FN_DYNVARS_077_01-------------------------#'
10 SET @@global.max_heap_table_size = 1677721610;
11 Warnings:
12 Warning 1292 Truncated incorrect max_heap_table_size value: '1677721610'
13 SET @@global.max_heap_table_size = DEFAULT;
14 SELECT @@global.max_heap_table_size;
15 @@global.max_heap_table_size
16 16777216
17 SET @@session.max_heap_table_size = 1677721610;
18 Warnings:
19 Warning 1292 Truncated incorrect max_heap_table_size value: '1677721610'
20 SET @@session.max_heap_table_size = DEFAULT;
21 SELECT @@session.max_heap_table_size;
22 @@session.max_heap_table_size
23 16777216
24 '#--------------------FN_DYNVARS_077_02-------------------------#'
25 SET @@global.max_heap_table_size = DEFAULT;
26 SELECT @@global.max_heap_table_size = 16777216;
27 @@global.max_heap_table_size = 16777216
28 1
29 SET @@session.max_heap_table_size = DEFAULT;
30 SELECT @@session.max_heap_table_size = 16777216;
31 @@session.max_heap_table_size = 16777216
32 1
33 '#--------------------FN_DYNVARS_077_03-------------------------#'
34 SET @@global.max_heap_table_size = 16384;
35 SELECT @@global.max_heap_table_size;
36 @@global.max_heap_table_size
37 16384
38 SET @@global.max_heap_table_size = 16385;
39 Warnings:
40 Warning 1292 Truncated incorrect max_heap_table_size value: '16385'
41 SELECT @@global.max_heap_table_size;
42 @@global.max_heap_table_size
43 16384
44 SET @@global.max_heap_table_size = 65535;
45 Warnings:
46 Warning 1292 Truncated incorrect max_heap_table_size value: '65535'
47 SELECT @@global.max_heap_table_size;
48 @@global.max_heap_table_size
49 64512
50 SET @@global.max_heap_table_size = 4294967294;
51 Warnings:
52 Warning 1292 Truncated incorrect max_heap_table_size value: '4294967294'
53 SELECT @@global.max_heap_table_size;
54 @@global.max_heap_table_size
55 4294966272
56 SET @@global.max_heap_table_size = 4294967295;
57 Warnings:
58 Warning 1292 Truncated incorrect max_heap_table_size value: '4294967295'
59 SELECT @@global.max_heap_table_size;
60 @@global.max_heap_table_size
61 4294966272
62 '#--------------------FN_DYNVARS_077_04-------------------------#'
63 SET @@session.max_heap_table_size = 16384;
64 SELECT @@session.max_heap_table_size;
65 @@session.max_heap_table_size
66 16384
67 SET @@session.max_heap_table_size = 16385;
68 Warnings:
69 Warning 1292 Truncated incorrect max_heap_table_size value: '16385'
70 SELECT @@session.max_heap_table_size;
71 @@session.max_heap_table_size
72 16384
73 SET @@session.max_heap_table_size = 65535;
74 Warnings:
75 Warning 1292 Truncated incorrect max_heap_table_size value: '65535'
76 SELECT @@session.max_heap_table_size;
77 @@session.max_heap_table_size
78 64512
79 SET @@session.max_heap_table_size = 4294967294;
80 Warnings:
81 Warning 1292 Truncated incorrect max_heap_table_size value: '4294967294'
82 SELECT @@session.max_heap_table_size;
83 @@session.max_heap_table_size
84 4294966272
85 SET @@session.max_heap_table_size = 4294967295;
86 Warnings:
87 Warning 1292 Truncated incorrect max_heap_table_size value: '4294967295'
88 SELECT @@session.max_heap_table_size;
89 @@session.max_heap_table_size
90 4294966272
91 '#------------------FN_DYNVARS_077_05-----------------------#'
92 SET @@global.max_heap_table_size = -1;
93 Warnings:
94 Warning 1292 Truncated incorrect max_heap_table_size value: '-1'
95 SELECT @@global.max_heap_table_size;
96 @@global.max_heap_table_size
97 16384
98 SET @@global.max_heap_table_size = -1024;
99 Warnings:
100 Warning 1292 Truncated incorrect max_heap_table_size value: '-1024'
101 SELECT @@global.max_heap_table_size;
102 @@global.max_heap_table_size
103 16384
104 SET @@global.max_heap_table_size = 1024;
105 Warnings:
106 Warning 1292 Truncated incorrect max_heap_table_size value: '1024'
107 SELECT @@global.max_heap_table_size;
108 @@global.max_heap_table_size
109 16384
110 SET @@global.max_heap_table_size = 16383;
111 Warnings:
112 Warning 1292 Truncated incorrect max_heap_table_size value: '16383'
113 SELECT @@global.max_heap_table_size;
114 @@global.max_heap_table_size
115 16384
116 SET @@global.max_heap_table_size = 4294967296;
117 SELECT @@global.max_heap_table_size;
118 @@global.max_heap_table_size
119 4294967296
120 SET @@global.max_heap_table_size = 65530.34;
121 ERROR 42000: Incorrect argument type to variable 'max_heap_table_size'
122 SELECT @@global.max_heap_table_size;
123 @@global.max_heap_table_size
124 4294967296
125 SET @@global.max_heap_table_size = test;
126 ERROR 42000: Incorrect argument type to variable 'max_heap_table_size'
127 SELECT @@global.max_heap_table_size;
128 @@global.max_heap_table_size
129 4294967296
130 SET @@global.max_heap_table_size = ' ';
131 ERROR 42000: Incorrect argument type to variable 'max_heap_table_size'
132 SELECT @@global.max_heap_table_size;
133 @@global.max_heap_table_size
134 4294967296
135 SET @@session.max_heap_table_size = -1;
136 Warnings:
137 Warning 1292 Truncated incorrect max_heap_table_size value: '-1'
138 SELECT @@session.max_heap_table_size;
139 @@session.max_heap_table_size
140 16384
141 SET @@session.max_heap_table_size = 16383;
142 Warnings:
143 Warning 1292 Truncated incorrect max_heap_table_size value: '16383'
144 SELECT @@session.max_heap_table_size;
145 @@session.max_heap_table_size
146 16384
147 SET @@session.max_heap_table_size = 4294967296;
148 SELECT @@session.max_heap_table_size;
149 @@session.max_heap_table_size
150 4294967296
151 SET @@session.max_heap_table_size = 65530.34;
152 ERROR 42000: Incorrect argument type to variable 'max_heap_table_size'
153 SET @@session.max_heap_table_size = 10737418241;
154 Warnings:
155 Warning 1292 Truncated incorrect max_heap_table_size value: '10737418241'
156 SELECT @@session.max_heap_table_size;
157 @@session.max_heap_table_size
158 10737418240
159 SET @@session.max_heap_table_size = test;
160 ERROR 42000: Incorrect argument type to variable 'max_heap_table_size'
161 SELECT @@session.max_heap_table_size;
162 @@session.max_heap_table_size
163 10737418240
164 SET @@session.max_heap_table_size = ' ';
165 ERROR 42000: Incorrect argument type to variable 'max_heap_table_size'
166 SELECT @@session.max_heap_table_size;
167 @@session.max_heap_table_size
168 10737418240
169 '#------------------FN_DYNVARS_077_06-----------------------#'
170 SELECT @@global.max_heap_table_size = VARIABLE_VALUE
171 FROM performance_schema.global_variables
172 WHERE VARIABLE_NAME='max_heap_table_size';
173 @@global.max_heap_table_size = VARIABLE_VALUE
174 1
175 '#------------------FN_DYNVARS_077_07-----------------------#'
176 SELECT @@session.max_heap_table_size = VARIABLE_VALUE
177 FROM performance_schema.session_variables
178 WHERE VARIABLE_NAME='max_heap_table_size';
179 @@session.max_heap_table_size = VARIABLE_VALUE
180 1
181 '#------------------FN_DYNVARS_077_08-----------------------#'
182 SET @@global.max_heap_table_size = TRUE;
183 Warnings:
184 Warning 1292 Truncated incorrect max_heap_table_size value: '1'
185 SELECT @@global.max_heap_table_size;
186 @@global.max_heap_table_size
187 16384
188 SET @@global.max_heap_table_size = FALSE;
189 Warnings:
190 Warning 1292 Truncated incorrect max_heap_table_size value: '0'
191 SELECT @@global.max_heap_table_size;
192 @@global.max_heap_table_size
193 16384
194 '#---------------------FN_DYNVARS_077_09----------------------#'
195 SET @@global.max_heap_table_size = 163845;
196 Warnings:
197 Warning 1292 Truncated incorrect max_heap_table_size value: '163845'
198 SELECT @@max_heap_table_size = @@global.max_heap_table_size;
199 @@max_heap_table_size = @@global.max_heap_table_size
200 0
201 '#---------------------FN_DYNVARS_077_10----------------------#'
202 SET @@max_heap_table_size = 16777216;
203 SELECT @@max_heap_table_size = @@local.max_heap_table_size;
204 @@max_heap_table_size = @@local.max_heap_table_size
205 1
206 SELECT @@local.max_heap_table_size = @@session.max_heap_table_size;
207 @@local.max_heap_table_size = @@session.max_heap_table_size
208 1
209 '#---------------------FN_DYNVARS_077_11----------------------#'
210 SET max_heap_table_size = 316777216;
211 Warnings:
212 Warning 1292 Truncated incorrect max_heap_table_size value: '316777216'
213 SELECT @@max_heap_table_size;
214 @@max_heap_table_size
215 316776448
216 SELECT local.max_heap_table_size;
217 ERROR 42S02: Unknown table 'local' in field list
218 SELECT session.max_heap_table_size;
219 ERROR 42S02: Unknown table 'session' in field list
220 SELECT max_heap_table_size = @@session.max_heap_table_size;
221 ERROR 42S22: Unknown column 'max_heap_table_size' in 'field list'
222 SET @@global.max_heap_table_size = @start_global_value;
223 SELECT @@global.max_heap_table_size;
224 @@global.max_heap_table_size
225 16777216
226 SET @@session.max_heap_table_size = @start_session_value;
227 SELECT @@session.max_heap_table_size;
228 @@session.max_heap_table_size
229 16777216