Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.mrr_buffer_size;
2 select @@global.mrr_buffer_size;
3 @@global.mrr_buffer_size
4 262144
5 select @@session.mrr_buffer_size;
6 @@session.mrr_buffer_size
7 262144
8 show global variables like 'mrr_buffer_size';
9 Variable_name Value
10 mrr_buffer_size 262144
11 show session variables like 'mrr_buffer_size';
12 Variable_name Value
13 mrr_buffer_size 262144
14 select * from information_schema.global_variables where variable_name='mrr_buffer_size';
15 VARIABLE_NAME VARIABLE_VALUE
16 MRR_BUFFER_SIZE 262144
17 select * from information_schema.session_variables where variable_name='mrr_buffer_size';
18 VARIABLE_NAME VARIABLE_VALUE
19 MRR_BUFFER_SIZE 262144
20 set global mrr_buffer_size=10;
21 Warnings:
22 Warning 1292 Truncated incorrect mrr_buffer_size value: '10'
23 select @@global.mrr_buffer_size;
24 @@global.mrr_buffer_size
25 8192
26 set session mrr_buffer_size=10;
27 Warnings:
28 Warning 1292 Truncated incorrect mrr_buffer_size value: '10'
29 select @@session.mrr_buffer_size;
30 @@session.mrr_buffer_size
31 8192
32 set global mrr_buffer_size=1.1;
33 ERROR 42000: Incorrect argument type to variable 'mrr_buffer_size'
34 set session mrr_buffer_size=1e1;
35 ERROR 42000: Incorrect argument type to variable 'mrr_buffer_size'
36 set global mrr_buffer_size="foo";
37 ERROR 42000: Incorrect argument type to variable 'mrr_buffer_size'
38 set global mrr_buffer_size=0;
39 Warnings:
40 Warning 1292 Truncated incorrect mrr_buffer_size value: '0'
41 select @@global.mrr_buffer_size;
42 @@global.mrr_buffer_size
43 8192
44 set session mrr_buffer_size=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 mrr_buffer_size value: '18446744073709551615'
48 select @@session.mrr_buffer_size;
49 @@session.mrr_buffer_size
50 2147483647
51 SET @@global.mrr_buffer_size = @start_global_value;