Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.join_buffer_space_limit;
2 show global variables like 'join_buffer_space_limit';
3 Variable_name Value
4 join_buffer_space_limit #
5 show session variables like 'join_buffer_space_limit';
6 Variable_name Value
7 join_buffer_space_limit #
8 select * from information_schema.global_variables where variable_name='join_buffer_space_limit';
9 VARIABLE_NAME VARIABLE_VALUE
10 JOIN_BUFFER_SPACE_LIMIT #
11 select * from information_schema.session_variables where variable_name='join_buffer_space_limit';
12 VARIABLE_NAME VARIABLE_VALUE
13 JOIN_BUFFER_SPACE_LIMIT #
14 set global join_buffer_space_limit=10;
15 Warnings:
16 Warning 1292 Truncated incorrect join_buffer_space_limit value: '10'
17 select @@global.join_buffer_space_limit;
18 @@global.join_buffer_space_limit
19 2048
20 set session join_buffer_space_limit=10;
21 Warnings:
22 Warning 1292 Truncated incorrect join_buffer_space_limit value: '10'
23 select @@session.join_buffer_space_limit;
24 @@session.join_buffer_space_limit
25 2048
26 set global join_buffer_space_limit=1.1;
27 ERROR 42000: Incorrect argument type to variable 'join_buffer_space_limit'
28 set session join_buffer_space_limit=1e1;
29 ERROR 42000: Incorrect argument type to variable 'join_buffer_space_limit'
30 set global join_buffer_space_limit="foo";
31 ERROR 42000: Incorrect argument type to variable 'join_buffer_space_limit'
32 set global join_buffer_space_limit=0;
33 Warnings:
34 Warning 1292 Truncated incorrect join_buffer_space_limit value: '0'
35 select @@global.join_buffer_space_limit;
36 @@global.join_buffer_space_limit
37 2048
38 set global join_buffer_space_limit=4095;
39 Warnings:
40 Warning 1292 Truncated incorrect join_buffer_space_limit value: '4095'
41 select @@global.join_buffer_space_limit;
42 @@global.join_buffer_space_limit
43 2048
44 set session join_buffer_space_limit=cast(-1 as unsigned int);
45 Warnings:
46 Note 1105 Cast to unsigned converted negative integer to it's positive complement
47 Warning 1292 Truncated incorrect join_buffer_space_limit value: '18446744073709551615'
48 select @@session.join_buffer_space_limit;
49 @@session.join_buffer_space_limit
50 18446744073709549568
51 SET @@global.join_buffer_space_limit = @start_global_value;