Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.query_alloc_block_size;
2 SELECT @start_global_value;
3 @start_global_value
4 8192
5 SET @start_session_value = @@session.query_alloc_block_size;
6 SELECT @start_session_value;
7 @start_session_value
8 8192
9 '#--------------------FN_DYNVARS_130_01-------------------------#'
10 SET @@global.query_alloc_block_size = 10000;
11 Warnings:
12 Warning 1292 Truncated incorrect query_alloc_block_size value: '10000'
13 SET @@global.query_alloc_block_size = DEFAULT;
14 SELECT @@global.query_alloc_block_size;
15 @@global.query_alloc_block_size
16 8192
17 SET @@session.query_alloc_block_size = 20000;
18 Warnings:
19 Warning 1292 Truncated incorrect query_alloc_block_size value: '20000'
20 SET @@session.query_alloc_block_size = DEFAULT;
21 SELECT @@session.query_alloc_block_size;
22 @@session.query_alloc_block_size
23 8192
24 '#--------------------FN_DYNVARS_130_02-------------------------#'
25 SET @@global.query_alloc_block_size = DEFAULT;
26 SELECT @@global.query_alloc_block_size = 8192;
27 @@global.query_alloc_block_size = 8192
28 1
29 SET @@session.query_alloc_block_size = DEFAULT;
30 SELECT @@session.query_alloc_block_size = 8192;
31 @@session.query_alloc_block_size = 8192
32 1
33 '#--------------------FN_DYNVARS_130_03-------------------------#'
34 SET @@global.query_alloc_block_size = 1024;
35 SELECT @@global.query_alloc_block_size;
36 @@global.query_alloc_block_size
37 1024
38 SET @@global.query_alloc_block_size = 1025;
39 Warnings:
40 Warning 1292 Truncated incorrect query_alloc_block_size value: '1025'
41 SELECT @@global.query_alloc_block_size;
42 @@global.query_alloc_block_size
43 1024
44 SET @@global.query_alloc_block_size = 4294967295;
45 Warnings:
46 Warning 1292 Truncated incorrect query_alloc_block_size value: '4294967295'
47 SELECT @@global.query_alloc_block_size;
48 @@global.query_alloc_block_size
49 4294966272
50 SET @@global.query_alloc_block_size = 4294967294;
51 Warnings:
52 Warning 1292 Truncated incorrect query_alloc_block_size value: '4294967294'
53 SELECT @@global.query_alloc_block_size;
54 @@global.query_alloc_block_size
55 4294966272
56 SET @@global.query_alloc_block_size = 65536;
57 SELECT @@global.query_alloc_block_size;
58 @@global.query_alloc_block_size
59 65536
60 '#--------------------FN_DYNVARS_130_04-------------------------#'
61 SET @@session.query_alloc_block_size = 1024;
62 SELECT @@session.query_alloc_block_size;
63 @@session.query_alloc_block_size
64 1024
65 SET @@session.query_alloc_block_size = 1025;
66 Warnings:
67 Warning 1292 Truncated incorrect query_alloc_block_size value: '1025'
68 SELECT @@session.query_alloc_block_size;
69 @@session.query_alloc_block_size
70 1024
71 SET @@session.query_alloc_block_size = 655536;
72 Warnings:
73 Warning 1292 Truncated incorrect query_alloc_block_size value: '655536'
74 SELECT @@session.query_alloc_block_size;
75 @@session.query_alloc_block_size
76 655360
77 '#------------------FN_DYNVARS_130_05-----------------------#'
78 SET @@global.query_alloc_block_size = 64;
79 Warnings:
80 Warning 1292 Truncated incorrect query_alloc_block_size value: '64'
81 SELECT @@global.query_alloc_block_size;
82 @@global.query_alloc_block_size
83 1024
84 SET @@global.query_alloc_block_size = -1;
85 Warnings:
86 Warning 1292 Truncated incorrect query_alloc_block_size value: '-1'
87 SELECT @@global.query_alloc_block_size;
88 @@global.query_alloc_block_size
89 1024
90 SET @@global.query_alloc_block_size = 1023;
91 Warnings:
92 Warning 1292 Truncated incorrect query_alloc_block_size value: '1023'
93 SELECT @@global.query_alloc_block_size;
94 @@global.query_alloc_block_size
95 1024
96 SET @@global.query_alloc_block_size = 4294967296;
97 Warnings:
98 Warning 1292 Truncated incorrect query_alloc_block_size value: '4294967296'
99 SELECT @@global.query_alloc_block_size;
100 @@global.query_alloc_block_size
101 4294966272
102 SET @@global.query_alloc_block_size = 65530.34;
103 ERROR 42000: Incorrect argument type to variable 'query_alloc_block_size'
104 SELECT @@global.query_alloc_block_size;
105 @@global.query_alloc_block_size
106 4294966272
107 SET @@global.query_alloc_block_size = test;
108 ERROR 42000: Incorrect argument type to variable 'query_alloc_block_size'
109 SELECT @@global.query_alloc_block_size;
110 @@global.query_alloc_block_size
111 4294966272
112 SET @@session.query_alloc_block_size = 64;
113 Warnings:
114 Warning 1292 Truncated incorrect query_alloc_block_size value: '64'
115 SELECT @@session.query_alloc_block_size;
116 @@session.query_alloc_block_size
117 1024
118 SET @@session.query_alloc_block_size = -2;
119 Warnings:
120 Warning 1292 Truncated incorrect query_alloc_block_size value: '-2'
121 SELECT @@session.query_alloc_block_size;
122 @@session.query_alloc_block_size
123 1024
124 SET @@session.query_alloc_block_size = 65530.34;
125 ERROR 42000: Incorrect argument type to variable 'query_alloc_block_size'
126 SET @@session.query_alloc_block_size = 1023;
127 Warnings:
128 Warning 1292 Truncated incorrect query_alloc_block_size value: '1023'
129 SELECT @@session.query_alloc_block_size;
130 @@session.query_alloc_block_size
131 1024
132 SET @@session.query_alloc_block_size = test;
133 ERROR 42000: Incorrect argument type to variable 'query_alloc_block_size'
134 SELECT @@session.query_alloc_block_size;
135 @@session.query_alloc_block_size
136 1024
137 '#------------------FN_DYNVARS_130_06-----------------------#'
138 SET @@global.query_alloc_block_size = 1;
139 Warnings:
140 Warning 1292 Truncated incorrect query_alloc_block_size value: '1'
141 SET @@session.query_alloc_block_size = 12;
142 Warnings:
143 Warning 1292 Truncated incorrect query_alloc_block_size value: '12'
144 SELECT @@global.query_alloc_block_size =
145 VARIABLE_VALUE FROM performance_schema.global_variables
146 WHERE VARIABLE_NAME='query_alloc_block_size';
147 @@global.query_alloc_block_size =
148 VARIABLE_VALUE
149 1
150 '#------------------FN_DYNVARS_130_07-----------------------#'
151 SELECT @@session.query_alloc_block_size = VARIABLE_VALUE
152 FROM performance_schema.session_variables
153 WHERE VARIABLE_NAME='query_alloc_block_size';
154 @@session.query_alloc_block_size = VARIABLE_VALUE
155 1
156 '#------------------FN_DYNVARS_130_08-----------------------#'
157 SET @@global.query_alloc_block_size = TRUE;
158 Warnings:
159 Warning 1292 Truncated incorrect query_alloc_block_size value: '1'
160 SELECT @@global.query_alloc_block_size;
161 @@global.query_alloc_block_size
162 1024
163 SET @@global.query_alloc_block_size = FALSE;
164 Warnings:
165 Warning 1292 Truncated incorrect query_alloc_block_size value: '0'
166 SELECT @@global.query_alloc_block_size;
167 @@global.query_alloc_block_size
168 1024
169 '#---------------------FN_DYNVARS_130_09----------------------#'
170 SET @@global.query_alloc_block_size = 2048;
171 SELECT @@query_alloc_block_size = @@global.query_alloc_block_size;
172 @@query_alloc_block_size = @@global.query_alloc_block_size
173 0
174 '#---------------------FN_DYNVARS_130_10----------------------#'
175 SET @@query_alloc_block_size = 5000;
176 Warnings:
177 Warning 1292 Truncated incorrect query_alloc_block_size value: '5000'
178 SELECT @@query_alloc_block_size = @@local.query_alloc_block_size;
179 @@query_alloc_block_size = @@local.query_alloc_block_size
180 1
181 SELECT @@local.query_alloc_block_size = @@session.query_alloc_block_size;
182 @@local.query_alloc_block_size = @@session.query_alloc_block_size
183 1
184 '#---------------------FN_DYNVARS_130_11----------------------#'
185 SET query_alloc_block_size = 1024;
186 SELECT @@query_alloc_block_size;
187 @@query_alloc_block_size
188 1024
189 SELECT local.query_alloc_block_size;
190 ERROR 42S02: Unknown table 'local' in field list
191 SELECT session.query_alloc_block_size;
192 ERROR 42S02: Unknown table 'session' in field list
193 SELECT query_alloc_block_size = @@session.query_alloc_block_size;
194 ERROR 42S22: Unknown column 'query_alloc_block_size' in 'field list'
195 SET @@global.query_alloc_block_size = @start_global_value;
196 SELECT @@global.query_alloc_block_size;
197 @@global.query_alloc_block_size
198 8192
199 SET @@session.query_alloc_block_size = @start_session_value;
200 SELECT @@session.query_alloc_block_size;
201 @@session.query_alloc_block_size
202 8192