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