Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.preload_buffer_size;
2 SELECT @start_global_value;
3 @start_global_value
4 32768
5 SET @start_session_value = @@session.preload_buffer_size;
6 SELECT @start_session_value;
7 @start_session_value
8 32768
9 '#--------------------FN_DYNVARS_129_01-------------------------#'
10 SET @@global.preload_buffer_size = 10000;
11 SET @@global.preload_buffer_size = DEFAULT;
12 SELECT @@global.preload_buffer_size;
13 @@global.preload_buffer_size
14 32768
15 SET @@session.preload_buffer_size = 20000;
16 SET @@session.preload_buffer_size = DEFAULT;
17 SELECT @@session.preload_buffer_size;
18 @@session.preload_buffer_size
19 32768
20 '#--------------------FN_DYNVARS_129_02-------------------------#'
21 SET @@global.preload_buffer_size = DEFAULT;
22 SELECT @@global.preload_buffer_size = 32768;
23 @@global.preload_buffer_size = 32768
24 1
25 SET @@session.preload_buffer_size = DEFAULT;
26 SELECT @@session.preload_buffer_size = 32768;
27 @@session.preload_buffer_size = 32768
28 1
29 '#--------------------FN_DYNVARS_129_03-------------------------#'
30 SET @@global.preload_buffer_size = 1024;
31 SELECT @@global.preload_buffer_size;
32 @@global.preload_buffer_size
33 1024
34 SET @@global.preload_buffer_size = 1025;
35 SELECT @@global.preload_buffer_size;
36 @@global.preload_buffer_size
37 1025
38 SET @@global.preload_buffer_size = 1073741824;
39 SELECT @@global.preload_buffer_size;
40 @@global.preload_buffer_size
41 1073741824
42 SET @@global.preload_buffer_size = 1073741823;
43 SELECT @@global.preload_buffer_size;
44 @@global.preload_buffer_size
45 1073741823
46 SET @@global.preload_buffer_size = 65536;
47 SELECT @@global.preload_buffer_size;
48 @@global.preload_buffer_size
49 65536
50 '#--------------------FN_DYNVARS_129_04-------------------------#'
51 SET @@session.preload_buffer_size = 1024;
52 SELECT @@session.preload_buffer_size;
53 @@session.preload_buffer_size
54 1024
55 SET @@session.preload_buffer_size = 1025;
56 SELECT @@session.preload_buffer_size;
57 @@session.preload_buffer_size
58 1025
59 SET @@session.preload_buffer_size = 1073741824;
60 SELECT @@session.preload_buffer_size;
61 @@session.preload_buffer_size
62 1073741824
63 SET @@session.preload_buffer_size = 1073741823;
64 SELECT @@session.preload_buffer_size;
65 @@session.preload_buffer_size
66 1073741823
67 SET @@session.preload_buffer_size = 655536;
68 SELECT @@session.preload_buffer_size;
69 @@session.preload_buffer_size
70 655536
71 '#------------------FN_DYNVARS_129_05-----------------------#'
72 SET @@global.preload_buffer_size = 64;
73 Warnings:
74 Warning 1292 Truncated incorrect preload_buffer_size value: '64'
75 SELECT @@global.preload_buffer_size;
76 @@global.preload_buffer_size
77 1024
78 SET @@global.preload_buffer_size = -1;
79 Warnings:
80 Warning 1292 Truncated incorrect preload_buffer_size value: '-1'
81 SELECT @@global.preload_buffer_size;
82 @@global.preload_buffer_size
83 1024
84 SET @@global.preload_buffer_size = 1023;
85 Warnings:
86 Warning 1292 Truncated incorrect preload_buffer_size value: '1023'
87 SELECT @@global.preload_buffer_size;
88 @@global.preload_buffer_size
89 1024
90 SET @@global.preload_buffer_size = 1073741825;
91 Warnings:
92 Warning 1292 Truncated incorrect preload_buffer_size value: '1073741825'
93 SELECT @@global.preload_buffer_size;
94 @@global.preload_buffer_size
95 1073741824
96 SET @@global.preload_buffer_size = 65530.34;
97 ERROR 42000: Incorrect argument type to variable 'preload_buffer_size'
98 SELECT @@global.preload_buffer_size;
99 @@global.preload_buffer_size
100 1073741824
101 SET @@global.preload_buffer_size = test;
102 ERROR 42000: Incorrect argument type to variable 'preload_buffer_size'
103 SELECT @@global.preload_buffer_size;
104 @@global.preload_buffer_size
105 1073741824
106 SET @@session.preload_buffer_size = 64;
107 Warnings:
108 Warning 1292 Truncated incorrect preload_buffer_size value: '64'
109 SELECT @@session.preload_buffer_size;
110 @@session.preload_buffer_size
111 1024
112 SET @@session.preload_buffer_size = -2;
113 Warnings:
114 Warning 1292 Truncated incorrect preload_buffer_size value: '-2'
115 SELECT @@session.preload_buffer_size;
116 @@session.preload_buffer_size
117 1024
118 SET @@session.preload_buffer_size = 65530.34;
119 ERROR 42000: Incorrect argument type to variable 'preload_buffer_size'
120 SET @@session.preload_buffer_size = 1023;
121 Warnings:
122 Warning 1292 Truncated incorrect preload_buffer_size value: '1023'
123 SELECT @@session.preload_buffer_size;
124 @@session.preload_buffer_size
125 1024
126 SET @@session.preload_buffer_size = 1073741825;
127 Warnings:
128 Warning 1292 Truncated incorrect preload_buffer_size value: '1073741825'
129 SELECT @@session.preload_buffer_size;
130 @@session.preload_buffer_size
131 1073741824
132 SET @@session.preload_buffer_size = test;
133 ERROR 42000: Incorrect argument type to variable 'preload_buffer_size'
134 SELECT @@session.preload_buffer_size;
135 @@session.preload_buffer_size
136 1073741824
137 '#------------------FN_DYNVARS_129_06-----------------------#'
138 SELECT @@global.preload_buffer_size = VARIABLE_VALUE
139 FROM performance_schema.global_variables
140 WHERE VARIABLE_NAME='preload_buffer_size';
141 @@global.preload_buffer_size = VARIABLE_VALUE
142 1
143 '#------------------FN_DYNVARS_129_07-----------------------#'
144 SELECT @@session.preload_buffer_size = VARIABLE_VALUE
145 FROM performance_schema.session_variables
146 WHERE VARIABLE_NAME='preload_buffer_size';
147 @@session.preload_buffer_size = VARIABLE_VALUE
148 1
149 '#------------------FN_DYNVARS_129_08-----------------------#'
150 SET @@global.preload_buffer_size = TRUE;
151 Warnings:
152 Warning 1292 Truncated incorrect preload_buffer_size value: '1'
153 SELECT @@global.preload_buffer_size;
154 @@global.preload_buffer_size
155 1024
156 SET @@global.preload_buffer_size = FALSE;
157 Warnings:
158 Warning 1292 Truncated incorrect preload_buffer_size value: '0'
159 SELECT @@global.preload_buffer_size;
160 @@global.preload_buffer_size
161 1024
162 '#---------------------FN_DYNVARS_129_09----------------------#'
163 SET @@global.preload_buffer_size = 2048;
164 SELECT @@preload_buffer_size = @@global.preload_buffer_size;
165 @@preload_buffer_size = @@global.preload_buffer_size
166 0
167 '#---------------------FN_DYNVARS_129_10----------------------#'
168 SET @@preload_buffer_size = 5000;
169 SELECT @@preload_buffer_size = @@local.preload_buffer_size;
170 @@preload_buffer_size = @@local.preload_buffer_size
171 1
172 SELECT @@local.preload_buffer_size = @@session.preload_buffer_size;
173 @@local.preload_buffer_size = @@session.preload_buffer_size
174 1
175 '#---------------------FN_DYNVARS_129_11----------------------#'
176 SET preload_buffer_size = 1024;
177 SELECT @@preload_buffer_size;
178 @@preload_buffer_size
179 1024
180 SELECT local.preload_buffer_size;
181 ERROR 42S02: Unknown table 'local' in field list
182 SELECT session.preload_buffer_size;
183 ERROR 42S02: Unknown table 'session' in field list
184 SELECT preload_buffer_size = @@session.preload_buffer_size;
185 ERROR 42S22: Unknown column 'preload_buffer_size' in 'field list'
186 '#---------------------FN_DYNVARS_129_12----------------------#'
187 CREATE USER foo, bar;
188 GRANT SESSION_VARIABLES_ADMIN ON *.* TO bar;
189 SELECT @@session.preload_buffer_size;
190 @@session.preload_buffer_size
191 2048
192 SET @@session.preload_buffer_size = 2048;
193 ERROR 42000: Access denied; you need (at least one of) the SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation
194 SELECT @@session.preload_buffer_size;
195 @@session.preload_buffer_size
196 2048
197 SET @@session.preload_buffer_size = 2048;
198 SELECT @@session.preload_buffer_size;
199 @@session.preload_buffer_size
200 2048
201 SET @@global.preload_buffer_size = 2048;
202 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
203 DROP USER foo, bar;
204 SET @@global.preload_buffer_size = @start_global_value;
205 SELECT @@global.preload_buffer_size;
206 @@global.preload_buffer_size
207 32768
208 SET @@session.preload_buffer_size = @start_session_value;
209 SELECT @@session.preload_buffer_size;
210 @@session.preload_buffer_size
211 32768