Debian Codegraph @

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

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