Debian Codegraph @

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

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