Debian Codegraph @

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

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