Debian Codegraph @

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

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