1SET @global_start_value = @@global.innodb_compression_pad_pct_max; 2SELECT @global_start_value; 3@global_start_value 450 5'#--------------------FN_DYNVARS_046_01------------------------#' 6SET @@global.innodb_compression_pad_pct_max = DEFAULT; 7SELECT @@global.innodb_compression_pad_pct_max; 8@@global.innodb_compression_pad_pct_max 950 10'#---------------------FN_DYNVARS_046_02-------------------------#' 11SET innodb_compression_pad_pct_max = 1; 12ERROR HY000: Variable 'innodb_compression_pad_pct_max' is a GLOBAL variable and should be set with SET GLOBAL 13SELECT @@innodb_compression_pad_pct_max; 14@@innodb_compression_pad_pct_max 1550 16SELECT local.innodb_compression_pad_pct_max; 17ERROR 42S02: Unknown table 'local' in field list 18SET global innodb_compression_pad_pct_max = 0; 19SELECT @@global.innodb_compression_pad_pct_max; 20@@global.innodb_compression_pad_pct_max 210 22'#--------------------FN_DYNVARS_046_03------------------------#' 23SET @@global.innodb_compression_pad_pct_max = 0; 24SELECT @@global.innodb_compression_pad_pct_max; 25@@global.innodb_compression_pad_pct_max 260 27SET @@global.innodb_compression_pad_pct_max = 75; 28SELECT @@global.innodb_compression_pad_pct_max; 29@@global.innodb_compression_pad_pct_max 3075 31'#--------------------FN_DYNVARS_046_04-------------------------#' 32SET @@global.innodb_compression_pad_pct_max = -1; 33Warnings: 34Warning 1292 Truncated incorrect innodb_compression_pad_pct_max value: '-1' 35SELECT @@global.innodb_compression_pad_pct_max; 36@@global.innodb_compression_pad_pct_max 370 38SET @@global.innodb_compression_pad_pct_max = "T"; 39ERROR 42000: Incorrect argument type to variable 'innodb_compression_pad_pct_max' 40SELECT @@global.innodb_compression_pad_pct_max; 41@@global.innodb_compression_pad_pct_max 420 43SET @@global.innodb_compression_pad_pct_max = 1.1; 44ERROR 42000: Incorrect argument type to variable 'innodb_compression_pad_pct_max' 45SELECT @@global.innodb_compression_pad_pct_max; 46@@global.innodb_compression_pad_pct_max 470 48SET @@global.innodb_compression_pad_pct_max = 76; 49Warnings: 50Warning 1292 Truncated incorrect innodb_compression_pad_pct_max value: '76' 51SELECT @@global.innodb_compression_pad_pct_max; 52@@global.innodb_compression_pad_pct_max 5375 54SET @@global.innodb_compression_pad_pct_max = " "; 55ERROR 42000: Incorrect argument type to variable 'innodb_compression_pad_pct_max' 56SELECT @@global.innodb_compression_pad_pct_max; 57@@global.innodb_compression_pad_pct_max 5875 59SET @@global.innodb_compression_pad_pct_max = ' '; 60ERROR 42000: Incorrect argument type to variable 'innodb_compression_pad_pct_max' 61SELECT @@global.innodb_compression_pad_pct_max; 62@@global.innodb_compression_pad_pct_max 6375 64'#----------------------FN_DYNVARS_046_05------------------------#' 65SELECT @@global.innodb_compression_pad_pct_max = 66VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 67WHERE VARIABLE_NAME='innodb_compression_pad_pct_max'; 68@@global.innodb_compression_pad_pct_max = 69VARIABLE_VALUE 701 71SELECT @@global.innodb_compression_pad_pct_max; 72@@global.innodb_compression_pad_pct_max 7375 74SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 75WHERE VARIABLE_NAME='innodb_compression_pad_pct_max'; 76VARIABLE_VALUE 7775 78'#---------------------FN_DYNVARS_046_06-------------------------#' 79SET @@global.innodb_compression_pad_pct_max = OFF; 80ERROR 42000: Incorrect argument type to variable 'innodb_compression_pad_pct_max' 81SELECT @@global.innodb_compression_pad_pct_max; 82@@global.innodb_compression_pad_pct_max 8375 84SET @@global.innodb_compression_pad_pct_max = ON; 85ERROR 42000: Incorrect argument type to variable 'innodb_compression_pad_pct_max' 86SELECT @@global.innodb_compression_pad_pct_max; 87@@global.innodb_compression_pad_pct_max 8875 89'#---------------------FN_DYNVARS_046_07----------------------#' 90SET @@global.innodb_compression_pad_pct_max = TRUE; 91SELECT @@global.innodb_compression_pad_pct_max; 92@@global.innodb_compression_pad_pct_max 931 94SET @@global.innodb_compression_pad_pct_max = FALSE; 95SELECT @@global.innodb_compression_pad_pct_max; 96@@global.innodb_compression_pad_pct_max 970 98SET @@global.innodb_compression_pad_pct_max = @global_start_value; 99SELECT @@global.innodb_compression_pad_pct_max; 100@@global.innodb_compression_pad_pct_max 10150 102