Debian Codegraph @

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

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