diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/r/innodb_background_scrub_data_check_interval_basic.result')
| -rw-r--r-- | mysql-test/suite/sys_vars/r/innodb_background_scrub_data_check_interval_basic.result | 88 |
1 files changed, 0 insertions, 88 deletions
diff --git a/mysql-test/suite/sys_vars/r/innodb_background_scrub_data_check_interval_basic.result b/mysql-test/suite/sys_vars/r/innodb_background_scrub_data_check_interval_basic.result deleted file mode 100644 index 6020098acb9..00000000000 --- a/mysql-test/suite/sys_vars/r/innodb_background_scrub_data_check_interval_basic.result +++ /dev/null @@ -1,88 +0,0 @@ -SET @start_global_value = @@global.innodb_background_scrub_data_check_interval; -# -# default value -# -select @@global.innodb_background_scrub_data_check_interval; -@@global.innodb_background_scrub_data_check_interval -0 -set global innodb_background_scrub_data_check_interval=10; -Warnings: -Warning 138 The parameter innodb_background_scrub_data_check_interval is deprecated and has no effect. -select @@global.innodb_background_scrub_data_check_interval; -@@global.innodb_background_scrub_data_check_interval -0 -set global innodb_background_scrub_data_check_interval=DEFAULT; -Warnings: -Warning 138 The parameter innodb_background_scrub_data_check_interval is deprecated and has no effect. -select @@global.innodb_background_scrub_data_check_interval; -@@global.innodb_background_scrub_data_check_interval -0 -set global innodb_background_scrub_data_check_interval=20; -Warnings: -Warning 138 The parameter innodb_background_scrub_data_check_interval is deprecated and has no effect. -select @@global.innodb_background_scrub_data_check_interval; -@@global.innodb_background_scrub_data_check_interval -0 -set global innodb_background_scrub_data_check_interval=DEFAULT; -Warnings: -Warning 138 The parameter innodb_background_scrub_data_check_interval is deprecated and has no effect. -select @@global.innodb_background_scrub_data_check_interval; -@@global.innodb_background_scrub_data_check_interval -0 -# -# exists as global only -# -select @@global.innodb_background_scrub_data_check_interval; -@@global.innodb_background_scrub_data_check_interval -0 -select @@session.innodb_background_scrub_data_check_interval; -ERROR HY000: Variable 'innodb_background_scrub_data_check_interval' is a GLOBAL variable -show global variables like 'innodb_background_scrub_data_check_interval'; -Variable_name Value -innodb_background_scrub_data_check_interval 0 -show session variables like 'innodb_background_scrub_data_check_interval'; -Variable_name Value -innodb_background_scrub_data_check_interval 0 -select * from information_schema.global_variables -where variable_name='innodb_background_scrub_data_check_interval'; -VARIABLE_NAME VARIABLE_VALUE -INNODB_BACKGROUND_SCRUB_DATA_CHECK_INTERVAL 0 -select * from information_schema.session_variables -where variable_name='innodb_background_scrub_data_check_interval'; -VARIABLE_NAME VARIABLE_VALUE -INNODB_BACKGROUND_SCRUB_DATA_CHECK_INTERVAL 0 -# -# show that it's writable -# -set global innodb_background_scrub_data_check_interval=10; -Warnings: -Warning 138 The parameter innodb_background_scrub_data_check_interval is deprecated and has no effect. -select @@global.innodb_background_scrub_data_check_interval; -@@global.innodb_background_scrub_data_check_interval -0 -set global innodb_background_scrub_data_check_interval=20; -Warnings: -Warning 138 The parameter innodb_background_scrub_data_check_interval is deprecated and has no effect. -select @@global.innodb_background_scrub_data_check_interval; -@@global.innodb_background_scrub_data_check_interval -0 -set global innodb_background_scrub_data_check_interval=1; -Warnings: -Warning 138 The parameter innodb_background_scrub_data_check_interval is deprecated and has no effect. -select @@global.innodb_background_scrub_data_check_interval; -@@global.innodb_background_scrub_data_check_interval -0 -set session innodb_background_scrub_data_check_interval=1; -ERROR HY000: Variable 'innodb_background_scrub_data_check_interval' is a GLOBAL variable and should be set with SET GLOBAL -# -# incorrect types -# -set global innodb_background_scrub_data_check_interval=1.1; -ERROR 42000: Incorrect argument type to variable 'innodb_background_scrub_data_check_interval' -set global innodb_background_scrub_data_check_interval=1e1; -ERROR 42000: Incorrect argument type to variable 'innodb_background_scrub_data_check_interval' -set global innodb_background_scrub_data_check_interval="foo"; -ERROR 42000: Incorrect argument type to variable 'innodb_background_scrub_data_check_interval' -SET @@global.innodb_background_scrub_data_check_interval = @start_global_value; -Warnings: -Warning 138 The parameter innodb_background_scrub_data_check_interval is deprecated and has no effect. |