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