Debian Codegraph @

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

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