Debian Codegraph @

mysql-test/suite/sys_vars/t/join_buffer_space_limit_basic.test

raw
1 # ulonglong session
2
3 SET @start_global_value = @@global.join_buffer_space_limit;
4
5 #
6 # exists as global and session
7 #
8 --replace_column 2 #
9 show global variables like 'join_buffer_space_limit';
10 --replace_column 2 #
11 show session variables like 'join_buffer_space_limit';
12 --replace_column 2 #
13 select * from information_schema.global_variables where variable_name='join_buffer_space_limit';
14 --replace_column 2 #
15 select * from information_schema.session_variables where variable_name='join_buffer_space_limit';
16
17 #
18 # show that it's writable
19 #
20 set global join_buffer_space_limit=10;
21 select @@global.join_buffer_space_limit;
22 set session join_buffer_space_limit=10;
23 select @@session.join_buffer_space_limit;
24
25 #
26 # incorrect types
27 #
28 --error ER_WRONG_TYPE_FOR_VAR
29 set global join_buffer_space_limit=1.1;
30 --error ER_WRONG_TYPE_FOR_VAR
31 set session join_buffer_space_limit=1e1;
32 --error ER_WRONG_TYPE_FOR_VAR
33 set global join_buffer_space_limit="foo";
34
35 #
36 # min/max values, block size
37 #
38 set global join_buffer_space_limit=0;
39 select @@global.join_buffer_space_limit;
40 set global join_buffer_space_limit=4095;
41 select @@global.join_buffer_space_limit;
42 set session join_buffer_space_limit=cast(-1 as unsigned int);
43 select @@session.join_buffer_space_limit;
44
45 SET @@global.join_buffer_space_limit = @start_global_value;