Debian Codegraph @

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

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