Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.aria_pagecache_age_threshold;
2 select @@global.aria_pagecache_age_threshold;
3 @@global.aria_pagecache_age_threshold
4 300
5 select @@session.aria_pagecache_age_threshold;
6 ERROR HY000: Variable 'aria_pagecache_age_threshold' is a GLOBAL variable
7 show global variables like 'aria_pagecache_age_threshold';
8 Variable_name Value
9 aria_pagecache_age_threshold 300
10 show session variables like 'aria_pagecache_age_threshold';
11 Variable_name Value
12 aria_pagecache_age_threshold 300
13 select * from information_schema.global_variables where variable_name='aria_pagecache_age_threshold';
14 VARIABLE_NAME VARIABLE_VALUE
15 ARIA_PAGECACHE_AGE_THRESHOLD 300
16 select * from information_schema.session_variables where variable_name='aria_pagecache_age_threshold';
17 VARIABLE_NAME VARIABLE_VALUE
18 ARIA_PAGECACHE_AGE_THRESHOLD 300
19 set global aria_pagecache_age_threshold=200;
20 select @@global.aria_pagecache_age_threshold;
21 @@global.aria_pagecache_age_threshold
22 200
23 set session aria_pagecache_age_threshold=1;
24 ERROR HY000: Variable 'aria_pagecache_age_threshold' is a GLOBAL variable and should be set with SET GLOBAL
25 set global aria_pagecache_age_threshold=1.1;
26 ERROR 42000: Incorrect argument type to variable 'aria_pagecache_age_threshold'
27 set global aria_pagecache_age_threshold=1e1;
28 ERROR 42000: Incorrect argument type to variable 'aria_pagecache_age_threshold'
29 set global aria_pagecache_age_threshold="foo";
30 ERROR 42000: Incorrect argument type to variable 'aria_pagecache_age_threshold'
31 set global aria_pagecache_age_threshold=1;
32 Warnings:
33 Warning 1292 Truncated incorrect aria_pagecache_age_threshold value: '1'
34 select @@global.aria_pagecache_age_threshold;
35 @@global.aria_pagecache_age_threshold
36 100
37 set global aria_pagecache_age_threshold=@@global.aria_pagecache_age_threshold + 100 - 1;
38 Warnings:
39 Warning 1292 Truncated incorrect aria_pagecache_age_threshold value: '199'
40 select @@global.aria_pagecache_age_threshold;
41 @@global.aria_pagecache_age_threshold
42 100
43 set global aria_pagecache_age_threshold=@@global.aria_pagecache_age_threshold + 100;
44 select @@global.aria_pagecache_age_threshold;
45 @@global.aria_pagecache_age_threshold
46 200
47 set global aria_pagecache_age_threshold=cast(-1 as unsigned int);
48 Warnings:
49 Note 1105 Cast to unsigned converted negative integer to it's positive complement
50 Note 1105 Cast to unsigned converted negative integer to it's positive complement
51 Warning 1292 Truncated incorrect aria_pagecache_age_threshold value: '18446744073709551615'
52 select @@global.aria_pagecache_age_threshold;
53 @@global.aria_pagecache_age_threshold
54 18446744073709551600
55 SET @@global.aria_pagecache_age_threshold = @start_global_value;