Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.transaction_prealloc_size;
2 Warnings:
3 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
4 SELECT @start_global_value;
5 @start_global_value
6 4096
7 SET @start_session_value = @@session.transaction_prealloc_size;
8 Warnings:
9 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
10 SELECT @start_session_value;
11 @start_session_value
12 4096
13 '#--------------------FN_DYNVARS_005_01-------------------------#'
14 SET @@global.transaction_prealloc_size = 100;
15 Warnings:
16 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
17 Warning 1292 Truncated incorrect transaction_prealloc_size value: '100'
18 SET @@global.transaction_prealloc_size = DEFAULT;
19 Warnings:
20 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
21 SELECT @@global.transaction_prealloc_size;
22 @@global.transaction_prealloc_size
23 4096
24 Warnings:
25 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
26 SET @@session.transaction_prealloc_size = 200;
27 Warnings:
28 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
29 Warning 1292 Truncated incorrect transaction_prealloc_size value: '200'
30 SET @@session.transaction_prealloc_size = DEFAULT;
31 Warnings:
32 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
33 SELECT @@session.transaction_prealloc_size;
34 @@session.transaction_prealloc_size
35 4096
36 Warnings:
37 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
38 '#--------------------FN_DYNVARS_005_02-------------------------#'
39 SET @@global.transaction_prealloc_size = DEFAULT;
40 Warnings:
41 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
42 SELECT @@global.transaction_prealloc_size = 4096;
43 @@global.transaction_prealloc_size = 4096
44 1
45 Warnings:
46 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
47 SET @@session.transaction_prealloc_size = DEFAULT;
48 Warnings:
49 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
50 SELECT @@session.transaction_prealloc_size = 4096;
51 @@session.transaction_prealloc_size = 4096
52 1
53 Warnings:
54 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
55 '#--------------------FN_DYNVARS_005_03-------------------------#'
56 SET @@global.transaction_prealloc_size = 1024;
57 Warnings:
58 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
59 SELECT @@global.transaction_prealloc_size;
60 @@global.transaction_prealloc_size
61 1024
62 Warnings:
63 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
64 SET @@global.transaction_prealloc_size = 60020;
65 Warnings:
66 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
67 Warning 1292 Truncated incorrect transaction_prealloc_size value: '60020'
68 SELECT @@global.transaction_prealloc_size;
69 @@global.transaction_prealloc_size
70 59392
71 Warnings:
72 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
73 '#--------------------FN_DYNVARS_005_04-------------------------#'
74 SET @@session.transaction_prealloc_size = 1024;
75 Warnings:
76 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
77 SELECT @@session.transaction_prealloc_size;
78 @@session.transaction_prealloc_size
79 1024
80 Warnings:
81 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
82 SET @@session.transaction_prealloc_size = 65535;
83 Warnings:
84 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
85 Warning 1292 Truncated incorrect transaction_prealloc_size value: '65535'
86 SELECT @@session.transaction_prealloc_size;
87 @@session.transaction_prealloc_size
88 64512
89 Warnings:
90 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
91 '#------------------FN_DYNVARS_005_05-----------------------#'
92 SET @@global.transaction_prealloc_size = 0;
93 Warnings:
94 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
95 Warning 1292 Truncated incorrect transaction_prealloc_size value: '0'
96 SELECT @@global.transaction_prealloc_size;
97 @@global.transaction_prealloc_size
98 1024
99 Warnings:
100 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
101 SET @@global.transaction_prealloc_size = -1024;
102 Warnings:
103 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
104 Warning 1292 Truncated incorrect transaction_prealloc_size value: '-1024'
105 SELECT @@global.transaction_prealloc_size;
106 @@global.transaction_prealloc_size
107 1024
108 Warnings:
109 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
110 SET @@global.transaction_prealloc_size = ON;
111 ERROR 42000: Incorrect argument type to variable 'transaction_prealloc_size'
112 SET @@global.transaction_prealloc_size = OFF;
113 ERROR 42000: Incorrect argument type to variable 'transaction_prealloc_size'
114 SET @@global.transaction_prealloc_size = True;
115 Warnings:
116 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
117 Warning 1292 Truncated incorrect transaction_prealloc_size value: '1'
118 SELECT @@global.transaction_prealloc_size;
119 @@global.transaction_prealloc_size
120 1024
121 Warnings:
122 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
123 SET @@global.transaction_prealloc_size = False;
124 Warnings:
125 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
126 Warning 1292 Truncated incorrect transaction_prealloc_size value: '0'
127 SELECT @@global.transaction_prealloc_size;
128 @@global.transaction_prealloc_size
129 1024
130 Warnings:
131 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
132 SET @@global.transaction_prealloc_size = 65530.34;
133 ERROR 42000: Incorrect argument type to variable 'transaction_prealloc_size'
134 SET @@global.transaction_prealloc_size ="Test";
135 ERROR 42000: Incorrect argument type to variable 'transaction_prealloc_size'
136 SET @@global.transaction_prealloc_size = 1000;
137 Warnings:
138 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
139 Warning 1292 Truncated incorrect transaction_prealloc_size value: '1000'
140 SELECT @@global.transaction_prealloc_size;
141 @@global.transaction_prealloc_size
142 1024
143 Warnings:
144 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
145 SET @@session.transaction_prealloc_size = ON;
146 ERROR 42000: Incorrect argument type to variable 'transaction_prealloc_size'
147 SET @@session.transaction_prealloc_size = OFF;
148 ERROR 42000: Incorrect argument type to variable 'transaction_prealloc_size'
149 SET @@session.transaction_prealloc_size = True;
150 Warnings:
151 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
152 Warning 1292 Truncated incorrect transaction_prealloc_size value: '1'
153 SELECT @@session.transaction_prealloc_size;
154 @@session.transaction_prealloc_size
155 1024
156 Warnings:
157 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
158 SET @@session.transaction_prealloc_size = False;
159 Warnings:
160 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
161 Warning 1292 Truncated incorrect transaction_prealloc_size value: '0'
162 SELECT @@session.transaction_prealloc_size;
163 @@session.transaction_prealloc_size
164 1024
165 Warnings:
166 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
167 SET @@session.transaction_prealloc_size = "Test";
168 ERROR 42000: Incorrect argument type to variable 'transaction_prealloc_size'
169 SET @@session.transaction_prealloc_size = 135217728;
170 Warnings:
171 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
172 Warning 1292 Truncated incorrect transaction_prealloc_size value: '135217728'
173 SELECT @@session.transaction_prealloc_size;
174 @@session.transaction_prealloc_size
175 131072
176 Warnings:
177 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
178 '#------------------FN_DYNVARS_005_06-----------------------#'
179 SELECT @@global.transaction_prealloc_size = VARIABLE_VALUE
180 FROM performance_schema.global_variables
181 WHERE VARIABLE_NAME='transaction_prealloc_size';
182 @@global.transaction_prealloc_size = VARIABLE_VALUE
183 1
184 '#------------------FN_DYNVARS_005_07-----------------------#'
185 SELECT @@session.transaction_prealloc_size = VARIABLE_VALUE
186 FROM performance_schema.session_variables
187 WHERE VARIABLE_NAME='transaction_prealloc_size';
188 @@session.transaction_prealloc_size = VARIABLE_VALUE
189 1
190 '#---------------------FN_DYNVARS_001_09----------------------#'
191 SET @@global.transaction_prealloc_size = 1024;
192 Warnings:
193 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
194 SET @@global.transaction_prealloc_size = 10;
195 Warnings:
196 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
197 Warning 1292 Truncated incorrect transaction_prealloc_size value: '10'
198 SELECT @@transaction_prealloc_size = @@global.transaction_prealloc_size;
199 @@transaction_prealloc_size = @@global.transaction_prealloc_size
200 0
201 Warnings:
202 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
203 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
204 '#---------------------FN_DYNVARS_001_10----------------------#'
205 SET @@transaction_prealloc_size = 100;
206 Warnings:
207 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
208 Warning 1292 Truncated incorrect transaction_prealloc_size value: '100'
209 SELECT @@transaction_prealloc_size = @@local.transaction_prealloc_size;
210 @@transaction_prealloc_size = @@local.transaction_prealloc_size
211 1
212 Warnings:
213 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
214 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
215 SELECT @@local.transaction_prealloc_size = @@session.transaction_prealloc_size;
216 @@local.transaction_prealloc_size = @@session.transaction_prealloc_size
217 1
218 Warnings:
219 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
220 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
221 '#---------------------FN_DYNVARS_001_11----------------------#'
222 SET transaction_prealloc_size = 1027;
223 Warnings:
224 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
225 Warning 1292 Truncated incorrect transaction_prealloc_size value: '1027'
226 SELECT @@transaction_prealloc_size;
227 @@transaction_prealloc_size
228 1024
229 Warnings:
230 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
231 SELECT local.transaction_prealloc_size;
232 ERROR 42S02: Unknown table 'local' in field list
233 SELECT session.transaction_prealloc_size;
234 ERROR 42S02: Unknown table 'session' in field list
235 SELECT transaction_prealloc_size = @@session.transaction_prealloc_size;
236 ERROR 42S22: Unknown column 'transaction_prealloc_size' in 'field list'
237 SET @@global.transaction_prealloc_size = @start_global_value;
238 Warnings:
239 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
240 SELECT @@global.transaction_prealloc_size;
241 @@global.transaction_prealloc_size
242 4096
243 Warnings:
244 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
245 SET @@session.transaction_prealloc_size = @start_session_value;
246 Warnings:
247 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.
248 SELECT @@session.transaction_prealloc_size;
249 @@session.transaction_prealloc_size
250 4096
251 Warnings:
252 Warning 1287 '@@transaction_prealloc_size' is deprecated and will be removed in a future release.