1SET @start_global_value = @@global.innodb_immediate_scrub_data_uncompressed; 2# 3# exists as global only 4# 5select @@global.innodb_immediate_scrub_data_uncompressed; 6@@global.innodb_immediate_scrub_data_uncompressed 70 8select @@session.innodb_immediate_scrub_data_uncompressed; 9ERROR HY000: Variable 'innodb_immediate_scrub_data_uncompressed' is a GLOBAL variable 10show global variables like 'innodb_immediate_scrub_data_uncompressed'; 11Variable_name Value 12innodb_immediate_scrub_data_uncompressed OFF 13show session variables like 'innodb_immediate_scrub_data_uncompressed'; 14Variable_name Value 15innodb_immediate_scrub_data_uncompressed OFF 16select * from information_schema.global_variables 17where variable_name='innodb_immediate_scrub_data_uncompressed'; 18VARIABLE_NAME VARIABLE_VALUE 19INNODB_IMMEDIATE_SCRUB_DATA_UNCOMPRESSED OFF 20Warnings: 21Warning 1287 'INFORMATION_SCHEMA.GLOBAL_VARIABLES' is deprecated and will be removed in a future release. Please use performance_schema.global_variables instead 22select * from information_schema.session_variables 23where variable_name='innodb_immediate_scrub_data_uncompressed'; 24VARIABLE_NAME VARIABLE_VALUE 25INNODB_IMMEDIATE_SCRUB_DATA_UNCOMPRESSED OFF 26Warnings: 27Warning 1287 'INFORMATION_SCHEMA.SESSION_VARIABLES' is deprecated and will be removed in a future release. Please use performance_schema.session_variables instead 28# 29# show that it's writable 30# 31set global innodb_immediate_scrub_data_uncompressed=ON; 32select @@global.innodb_immediate_scrub_data_uncompressed; 33@@global.innodb_immediate_scrub_data_uncompressed 341 35set global innodb_immediate_scrub_data_uncompressed=OFF; 36select @@global.innodb_immediate_scrub_data_uncompressed; 37@@global.innodb_immediate_scrub_data_uncompressed 380 39set global innodb_immediate_scrub_data_uncompressed=1; 40select @@global.innodb_immediate_scrub_data_uncompressed; 41@@global.innodb_immediate_scrub_data_uncompressed 421 43set session innodb_immediate_scrub_data_uncompressed=1; 44ERROR HY000: Variable 'innodb_immediate_scrub_data_uncompressed' is a GLOBAL variable and should be set with SET GLOBAL 45# 46# incorrect types 47# 48set global innodb_immediate_scrub_data_uncompressed=1.1; 49ERROR 42000: Incorrect argument type to variable 'innodb_immediate_scrub_data_uncompressed' 50set global innodb_immediate_scrub_data_uncompressed=1e1; 51ERROR 42000: Incorrect argument type to variable 'innodb_immediate_scrub_data_uncompressed' 52set global innodb_immediate_scrub_data_uncompressed="foo"; 53ERROR 42000: Variable 'innodb_immediate_scrub_data_uncompressed' can't be set to the value of 'foo' 54SET @@global.innodb_immediate_scrub_data_uncompressed = @start_global_value; 55