diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/r/innodb_cleaner_max_flush_time_basic.result')
-rw-r--r-- | mysql-test/suite/sys_vars/r/innodb_cleaner_max_flush_time_basic.result | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/mysql-test/suite/sys_vars/r/innodb_cleaner_max_flush_time_basic.result b/mysql-test/suite/sys_vars/r/innodb_cleaner_max_flush_time_basic.result new file mode 100644 index 00000000000..e4a3fa26e73 --- /dev/null +++ b/mysql-test/suite/sys_vars/r/innodb_cleaner_max_flush_time_basic.result @@ -0,0 +1,25 @@ +SET @start_value = @@GLOBAL.innodb_cleaner_max_flush_time; +SELECT @@GLOBAL.innodb_cleaner_max_flush_time; +@@GLOBAL.innodb_cleaner_max_flush_time +1000 +SELECT @@SESSION.innodb_cleaner_max_flush_time; +ERROR HY000: Variable 'innodb_cleaner_max_flush_time' is a GLOBAL variable +SET GLOBAL innodb_cleaner_max_flush_time=0; +SELECT @@GLOBAL.innodb_cleaner_max_flush_time; +@@GLOBAL.innodb_cleaner_max_flush_time +0 +SET GLOBAL innodb_cleaner_max_flush_time=1000; +SELECT @@GLOBAL.innodb_cleaner_max_flush_time; +@@GLOBAL.innodb_cleaner_max_flush_time +1000 +SET GLOBAL innodb_cleaner_max_flush_time=4294967295; +SELECT @@GLOBAL.innodb_cleaner_max_flush_time; +@@GLOBAL.innodb_cleaner_max_flush_time +4294967295 +SET GLOBAL innodb_cleaner_max_flush_time=1.1; +ERROR 42000: Incorrect argument type to variable 'innodb_cleaner_max_flush_time' +SET GLOBAL innodb_cleaner_max_flush_time=1e1; +ERROR 42000: Incorrect argument type to variable 'innodb_cleaner_max_flush_time' +SET GLOBAL innodb_cleaner_max_flush_time='foo'; +ERROR 42000: Incorrect argument type to variable 'innodb_cleaner_max_flush_time' +SET GLOBAL innodb_cleaner_max_flush_time = @start_value; |