Debian Codegraph @

mysql-test/suite/sys_vars/r/join_buffer_size_basic_64.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 SET @@global.join_buffer_size = 18446744073709547520;
40 SELECT @@global.join_buffer_size;
41 @@global.join_buffer_size
42 18446744073709547520
43 '#--------------------FN_DYNVARS_053_04-------------------------#'
44 SET @@session.join_buffer_size = 128;
45 SELECT @@session.join_buffer_size;
46 @@session.join_buffer_size
47 128
48 SET @@session.join_buffer_size = 8200;
49 Warnings:
50 Warning 1292 Truncated incorrect join_buffer_size value: '8200'
51 SELECT @@session.join_buffer_size;
52 @@session.join_buffer_size
53 8192
54 SET @@session.join_buffer_size = 65536;
55 SELECT @@session.join_buffer_size;
56 @@session.join_buffer_size
57 65536
58 SET @@session.join_buffer_size = 4294967295;
59 Warnings:
60 Warning 1292 Truncated incorrect join_buffer_size value: '4294967295'
61 SELECT @@session.join_buffer_size;
62 @@session.join_buffer_size
63 4294967168
64 SET @@session.join_buffer_size = 18446744073709547520;
65 SELECT @@session.join_buffer_size;
66 @@session.join_buffer_size
67 18446744073709547520
68 '#------------------FN_DYNVARS_053_05-----------------------#'
69 SET @@global.join_buffer_size = 0;
70 Warnings:
71 Warning 1292 Truncated incorrect join_buffer_size value: '0'
72 SELECT @@global.join_buffer_size;
73 @@global.join_buffer_size
74 128
75 SET @@global.join_buffer_size = -1024;
76 Warnings:
77 Warning 1292 Truncated incorrect join_buffer_size value: '-1024'
78 SELECT @@global.join_buffer_size;
79 @@global.join_buffer_size
80 128
81 SET @@global.join_buffer_size = 127;
82 Warnings:
83 Warning 1292 Truncated incorrect join_buffer_size value: '127'
84 SELECT @@global.join_buffer_size;
85 @@global.join_buffer_size
86 128
87 SET @@global.join_buffer_size = 65530.34;
88 ERROR 42000: Incorrect argument type to variable 'join_buffer_size'
89 SELECT @@global.join_buffer_size;
90 @@global.join_buffer_size
91 128
92 SET @@global.join_buffer_size = test;
93 ERROR 42000: Incorrect argument type to variable 'join_buffer_size'
94 SELECT @@global.join_buffer_size;
95 @@global.join_buffer_size
96 128
97 SET @@global.join_buffer_size = 18446744073709547521;
98 Warnings:
99 Warning 1292 Truncated incorrect join_buffer_size value: '18446744073709547521'
100 SELECT @@global.join_buffer_size;
101 @@global.join_buffer_size
102 18446744073709547520
103 SET @@session.join_buffer_size = 0;
104 Warnings:
105 Warning 1292 Truncated incorrect join_buffer_size value: '0'
106 SELECT @@session.join_buffer_size;
107 @@session.join_buffer_size
108 128
109 SET @@session.join_buffer_size = -1024;
110 Warnings:
111 Warning 1292 Truncated incorrect join_buffer_size value: '-1024'
112 SELECT @@session.join_buffer_size;
113 @@session.join_buffer_size
114 128
115 SET @@session.join_buffer_size = 127;
116 Warnings:
117 Warning 1292 Truncated incorrect join_buffer_size value: '127'
118 SELECT @@session.join_buffer_size;
119 @@session.join_buffer_size
120 128
121 SET @@session.join_buffer_size = 65530.34;
122 ERROR 42000: Incorrect argument type to variable 'join_buffer_size'
123 SELECT @@session.join_buffer_size;
124 @@session.join_buffer_size
125 128
126 SET @@session.join_buffer_size = test;
127 ERROR 42000: Incorrect argument type to variable 'join_buffer_size'
128 SELECT @@session.join_buffer_size;
129 @@session.join_buffer_size
130 128
131 SET @@session.join_buffer_size = 18446744073709547521;
132 Warnings:
133 Warning 1292 Truncated incorrect join_buffer_size value: '18446744073709547521'
134 SELECT @@session.join_buffer_size;
135 @@session.join_buffer_size
136 18446744073709547520
137 '#------------------FN_DYNVARS_053_06-----------------------#'
138 SET @@global.join_buffer_size = 4294967295;
139 Warnings:
140 Warning 1292 Truncated incorrect join_buffer_size value: '4294967295'
141 SELECT @@global.join_buffer_size = VARIABLE_VALUE
142 FROM performance_schema.global_variables
143 WHERE VARIABLE_NAME='join_buffer_size';
144 @@global.join_buffer_size = VARIABLE_VALUE
145 1
146 '#------------------FN_DYNVARS_053_07-----------------------#'
147 SET @@session.join_buffer_size = 4294967295;
148 Warnings:
149 Warning 1292 Truncated incorrect join_buffer_size value: '4294967295'
150 SELECT @@session.join_buffer_size = VARIABLE_VALUE
151 FROM performance_schema.session_variables
152 WHERE VARIABLE_NAME='join_buffer_size';
153 @@session.join_buffer_size = VARIABLE_VALUE
154 1
155 '#------------------FN_DYNVARS_053_08-----------------------#'
156 SET @@global.join_buffer_size = TRUE;
157 Warnings:
158 Warning 1292 Truncated incorrect join_buffer_size value: '1'
159 SET @@global.join_buffer_size = FALSE;
160 Warnings:
161 Warning 1292 Truncated incorrect join_buffer_size value: '0'
162 '#---------------------FN_DYNVARS_001_09----------------------#'
163 SET @@global.join_buffer_size = 10;
164 Warnings:
165 Warning 1292 Truncated incorrect join_buffer_size value: '10'
166 SELECT @@join_buffer_size = @@global.join_buffer_size;
167 @@join_buffer_size = @@global.join_buffer_size
168 0
169 '#---------------------FN_DYNVARS_001_10----------------------#'
170 SET @@join_buffer_size = 100;
171 Warnings:
172 Warning 1292 Truncated incorrect join_buffer_size value: '100'
173 SELECT @@join_buffer_size = @@local.join_buffer_size;
174 @@join_buffer_size = @@local.join_buffer_size
175 1
176 SELECT @@local.join_buffer_size = @@session.join_buffer_size;
177 @@local.join_buffer_size = @@session.join_buffer_size
178 1
179 '#---------------------FN_DYNVARS_001_11----------------------#'
180 SET join_buffer_size = 1;
181 Warnings:
182 Warning 1292 Truncated incorrect join_buffer_size value: '1'
183 SELECT @@join_buffer_size;
184 @@join_buffer_size
185 128
186 SELECT local.join_buffer_size;
187 ERROR 42S02: Unknown table 'local' in field list
188 SELECT session.join_buffer_size;
189 ERROR 42S02: Unknown table 'session' in field list
190 SELECT join_buffer_size = @@session.join_buffer_size;
191 ERROR 42S22: Unknown column 'join_buffer_size' in 'field list'
192 SET @@global.join_buffer_size = @start_global_value;
193 SELECT @@global.join_buffer_size;
194 @@global.join_buffer_size
195 262144
196 SET @@session.join_buffer_size = @start_session_value;
197 SELECT @@session.join_buffer_size;
198 @@session.join_buffer_size
199 262144