diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/r/maria_pagecache_age_threshold_basic.result')
-rw-r--r-- | mysql-test/suite/sys_vars/r/maria_pagecache_age_threshold_basic.result | 57 |
1 files changed, 0 insertions, 57 deletions
diff --git a/mysql-test/suite/sys_vars/r/maria_pagecache_age_threshold_basic.result b/mysql-test/suite/sys_vars/r/maria_pagecache_age_threshold_basic.result deleted file mode 100644 index c00bbfb1adf..00000000000 --- a/mysql-test/suite/sys_vars/r/maria_pagecache_age_threshold_basic.result +++ /dev/null @@ -1,57 +0,0 @@ -SET @start_global_value = @@global.maria_pagecache_age_threshold; -select @@global.maria_pagecache_age_threshold, @@global.aria_pagecache_age_threshold; -@@global.maria_pagecache_age_threshold @@global.aria_pagecache_age_threshold -300 300 -select @@session.maria_pagecache_age_threshold, @@session.aria_pagecache_age_threshold; -ERROR HY000: Variable 'maria_pagecache_age_threshold' is a GLOBAL variable -show global variables like '%aria_pagecache_age_threshold'; -Variable_name Value -aria_pagecache_age_threshold 300 -maria_pagecache_age_threshold 300 -show session variables like '%aria_pagecache_age_threshold'; -Variable_name Value -aria_pagecache_age_threshold 300 -maria_pagecache_age_threshold 300 -select * from information_schema.global_variables where variable_name like '%aria_pagecache_age_threshold'; -VARIABLE_NAME VARIABLE_VALUE -ARIA_PAGECACHE_AGE_THRESHOLD 300 -MARIA_PAGECACHE_AGE_THRESHOLD 300 -select * from information_schema.session_variables where variable_name like '%aria_pagecache_age_threshold'; -VARIABLE_NAME VARIABLE_VALUE -ARIA_PAGECACHE_AGE_THRESHOLD 300 -MARIA_PAGECACHE_AGE_THRESHOLD 300 -set global maria_pagecache_age_threshold=200; -select @@global.maria_pagecache_age_threshold, @@global.aria_pagecache_age_threshold; -@@global.maria_pagecache_age_threshold @@global.aria_pagecache_age_threshold -200 200 -set session maria_pagecache_age_threshold=1; -ERROR HY000: Variable 'maria_pagecache_age_threshold' is a GLOBAL variable and should be set with SET GLOBAL -set global maria_pagecache_age_threshold=1.1; -ERROR 42000: Incorrect argument type to variable 'maria_pagecache_age_threshold' -set global maria_pagecache_age_threshold=1e1; -ERROR 42000: Incorrect argument type to variable 'maria_pagecache_age_threshold' -set global maria_pagecache_age_threshold="foo"; -ERROR 42000: Incorrect argument type to variable 'maria_pagecache_age_threshold' -set global maria_pagecache_age_threshold=1; -Warnings: -Warning 1292 Truncated incorrect aria_pagecache_age_threshold value: '1' -select @@global.maria_pagecache_age_threshold, @@global.aria_pagecache_age_threshold; -@@global.maria_pagecache_age_threshold @@global.aria_pagecache_age_threshold -100 100 -set global maria_pagecache_age_threshold=@@global.maria_pagecache_age_threshold + 100 - 1; -Warnings: -Warning 1292 Truncated incorrect aria_pagecache_age_threshold value: '199' -select @@global.maria_pagecache_age_threshold, @@global.aria_pagecache_age_threshold; -@@global.maria_pagecache_age_threshold @@global.aria_pagecache_age_threshold -100 100 -set global maria_pagecache_age_threshold=@@global.maria_pagecache_age_threshold + 100; -select @@global.maria_pagecache_age_threshold, @@global.aria_pagecache_age_threshold; -@@global.maria_pagecache_age_threshold @@global.aria_pagecache_age_threshold -200 200 -set global maria_pagecache_age_threshold=cast(-1 as unsigned int); -Warnings: -Warning 1292 Truncated incorrect aria_pagecache_age_threshold value: '18446744073709551615' -select @@global.maria_pagecache_age_threshold, @@global.aria_pagecache_age_threshold; -@@global.maria_pagecache_age_threshold @@global.aria_pagecache_age_threshold -18446744073709551600 18446744073709551600 -SET @@global.maria_pagecache_age_threshold = @start_global_value; |