Debian Codegraph @

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

raw
1 # ulong readonly
2
3 --source include/have_maria.inc
4 #
5 # show the global and session values;
6 #
7 select @@global.aria_pagecache_buffer_size > 0;
8 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
9 select @@session.aria_pagecache_buffer_size;
10 --replace_column 2 #
11 show global variables like 'aria_pagecache_buffer_size';
12 --replace_column 2 #
13 show session variables like 'aria_pagecache_buffer_size';
14 --replace_column 2 #
15 select * from information_schema.global_variables where variable_name='aria_pagecache_buffer_size';
16 --replace_column 2 #
17 select * from information_schema.session_variables where variable_name='aria_pagecache_buffer_size';
18
19 #
20 # show that it's read-only
21 #
22 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
23 set global aria_pagecache_buffer_size=1;
24 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
25 set session aria_pagecache_buffer_size=1;
26