1SET @global_start_value = @@global.innodb_compression_failure_threshold_pct; 2SELECT @global_start_value; 3@global_start_value 45 5'#--------------------FN_DYNVARS_046_01------------------------#' 6SET @@global.innodb_compression_failure_threshold_pct = 0; 7SET @@global.innodb_compression_failure_threshold_pct = DEFAULT; 8SELECT @@global.innodb_compression_failure_threshold_pct; 9@@global.innodb_compression_failure_threshold_pct 105 11'#---------------------FN_DYNVARS_046_02-------------------------#' 12SET innodb_compression_failure_threshold_pct = 1; 13ERROR HY000: Variable 'innodb_compression_failure_threshold_pct' is a GLOBAL variable and should be set with SET GLOBAL 14SELECT @@innodb_compression_failure_threshold_pct; 15@@innodb_compression_failure_threshold_pct 165 17SELECT local.innodb_compression_failure_threshold_pct; 18ERROR 42S02: Unknown table 'local' in field list 19SET global innodb_compression_failure_threshold_pct = 0; 20SELECT @@global.innodb_compression_failure_threshold_pct; 21@@global.innodb_compression_failure_threshold_pct 220 23'#--------------------FN_DYNVARS_046_03------------------------#' 24SET @@global.innodb_compression_failure_threshold_pct = 0; 25SELECT @@global.innodb_compression_failure_threshold_pct; 26@@global.innodb_compression_failure_threshold_pct 270 28SET @@global.innodb_compression_failure_threshold_pct = 1; 29SELECT @@global.innodb_compression_failure_threshold_pct; 30@@global.innodb_compression_failure_threshold_pct 311 32SET @@global.innodb_compression_failure_threshold_pct = 100; 33SELECT @@global.innodb_compression_failure_threshold_pct; 34@@global.innodb_compression_failure_threshold_pct 35100 36'#--------------------FN_DYNVARS_046_04-------------------------#' 37SET @@global.innodb_compression_failure_threshold_pct = -1; 38Warnings: 39Warning 1292 Truncated incorrect innodb_compression_failure_thres value: '-1' 40SELECT @@global.innodb_compression_failure_threshold_pct; 41@@global.innodb_compression_failure_threshold_pct 420 43SET @@global.innodb_compression_failure_threshold_pct = "T"; 44ERROR 42000: Incorrect argument type to variable 'innodb_compression_failure_threshold_pct' 45SELECT @@global.innodb_compression_failure_threshold_pct; 46@@global.innodb_compression_failure_threshold_pct 470 48SET @@global.innodb_compression_failure_threshold_pct = 1.1; 49ERROR 42000: Incorrect argument type to variable 'innodb_compression_failure_threshold_pct' 50SELECT @@global.innodb_compression_failure_threshold_pct; 51@@global.innodb_compression_failure_threshold_pct 520 53SET @@global.innodb_compression_failure_threshold_pct = "Y"; 54ERROR 42000: Incorrect argument type to variable 'innodb_compression_failure_threshold_pct' 55SELECT @@global.innodb_compression_failure_threshold_pct; 56@@global.innodb_compression_failure_threshold_pct 570 58SET @@global.innodb_compression_failure_threshold_pct = 101; 59Warnings: 60Warning 1292 Truncated incorrect innodb_compression_failure_thres value: '101' 61SELECT @@global.innodb_compression_failure_threshold_pct; 62@@global.innodb_compression_failure_threshold_pct 63100 64SET @@global.innodb_compression_failure_threshold_pct = " "; 65ERROR 42000: Incorrect argument type to variable 'innodb_compression_failure_threshold_pct' 66SELECT @@global.innodb_compression_failure_threshold_pct; 67@@global.innodb_compression_failure_threshold_pct 68100 69SET @@global.innodb_compression_failure_threshold_pct = ' '; 70ERROR 42000: Incorrect argument type to variable 'innodb_compression_failure_threshold_pct' 71SELECT @@global.innodb_compression_failure_threshold_pct; 72@@global.innodb_compression_failure_threshold_pct 73100 74'#----------------------FN_DYNVARS_046_05------------------------#' 75SELECT @@global.innodb_compression_failure_threshold_pct = 76VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 77WHERE VARIABLE_NAME='innodb_compression_failure_threshold_pct'; 78@@global.innodb_compression_failure_threshold_pct = 79VARIABLE_VALUE 801 81SELECT @@global.innodb_compression_failure_threshold_pct; 82@@global.innodb_compression_failure_threshold_pct 83100 84SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 85WHERE VARIABLE_NAME='innodb_compression_failure_threshold_pct'; 86VARIABLE_VALUE 87100 88'#---------------------FN_DYNVARS_046_06-------------------------#' 89SET @@global.innodb_compression_failure_threshold_pct = OFF; 90ERROR 42000: Incorrect argument type to variable 'innodb_compression_failure_threshold_pct' 91SELECT @@global.innodb_compression_failure_threshold_pct; 92@@global.innodb_compression_failure_threshold_pct 93100 94SET @@global.innodb_compression_failure_threshold_pct = ON; 95ERROR 42000: Incorrect argument type to variable 'innodb_compression_failure_threshold_pct' 96SELECT @@global.innodb_compression_failure_threshold_pct; 97@@global.innodb_compression_failure_threshold_pct 98100 99'#---------------------FN_DYNVARS_046_07----------------------#' 100SET @@global.innodb_compression_failure_threshold_pct = TRUE; 101SELECT @@global.innodb_compression_failure_threshold_pct; 102@@global.innodb_compression_failure_threshold_pct 1031 104SET @@global.innodb_compression_failure_threshold_pct = FALSE; 105SELECT @@global.innodb_compression_failure_threshold_pct; 106@@global.innodb_compression_failure_threshold_pct 1070 108SET @@global.innodb_compression_failure_threshold_pct = @global_start_value; 109SELECT @@global.innodb_compression_failure_threshold_pct; 110@@global.innodb_compression_failure_threshold_pct 1115 112