1SET @global_start_value = @@global.innodb_fast_shutdown; 2SELECT @@global.innodb_fast_shutdown; 3@@global.innodb_fast_shutdown 41 5'#--------------------FN_DYNVARS_042_01------------------------#' 6SET @@global.innodb_fast_shutdown = 0; 7SET @@global.innodb_fast_shutdown = DEFAULT; 8SELECT @@global.innodb_fast_shutdown; 9@@global.innodb_fast_shutdown 101 11'#---------------------FN_DYNVARS_042_02-------------------------#' 12SET innodb_fast_shutdown = 1; 13ERROR HY000: Variable 'innodb_fast_shutdown' is a GLOBAL variable and should be set with SET GLOBAL 14SELECT @@innodb_fast_shutdown; 15@@innodb_fast_shutdown 161 17SELECT global.innodb_fast_shutdown; 18ERROR 42S02: Unknown table 'global' in field list 19SET global innodb_fast_shutdown = 1; 20SELECT @@global.innodb_fast_shutdown; 21@@global.innodb_fast_shutdown 221 23'#--------------------FN_DYNVARS_042_03------------------------#' 24SET @@global.innodb_fast_shutdown = 0; 25SELECT @@global.innodb_fast_shutdown; 26@@global.innodb_fast_shutdown 270 28SET @@global.innodb_fast_shutdown = 1; 29SELECT @@global.innodb_fast_shutdown; 30@@global.innodb_fast_shutdown 311 32SET @@global.innodb_fast_shutdown = 2; 33SELECT @@global.innodb_fast_shutdown; 34@@global.innodb_fast_shutdown 352 36'#--------------------FN_DYNVARS_042_04-------------------------#' 37SET @@global.innodb_fast_shutdown = -1; 38Warnings: 39Warning 1292 Truncated incorrect innodb_fast_shutdown value: '-1' 40SELECT @@global.innodb_fast_shutdown; 41@@global.innodb_fast_shutdown 420 43SET @@global.innodb_fast_shutdown = TRU; 44ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown' 45SELECT @@global.innodb_fast_shutdown; 46@@global.innodb_fast_shutdown 470 48SET @@global.innodb_fast_shutdown = TRUE_F; 49ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown' 50SELECT @@global.innodb_fast_shutdown; 51@@global.innodb_fast_shutdown 520 53SET @@global.innodb_fast_shutdown = FALS; 54ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown' 55SELECT @@global.innodb_fast_shutdown; 56@@global.innodb_fast_shutdown 570 58SET @@global.innodb_fast_shutdown = OON; 59ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown' 60SELECT @@global.innodb_fast_shutdown; 61@@global.innodb_fast_shutdown 620 63SET @@global.innodb_fast_shutdown = ONN; 64ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown' 65SELECT @@global.innodb_fast_shutdown; 66@@global.innodb_fast_shutdown 670 68SET @@global.innodb_fast_shutdown = OOFF; 69ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown' 70SELECT @@global.innodb_fast_shutdown; 71@@global.innodb_fast_shutdown 720 73SET @@global.innodb_fast_shutdown = 0FF; 74ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown' 75SELECT @@global.innodb_fast_shutdown; 76@@global.innodb_fast_shutdown 770 78SET @@global.innodb_fast_shutdown = '1'; 79ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown' 80SELECT @@global.innodb_fast_shutdown; 81@@global.innodb_fast_shutdown 820 83SET @@global.innodb_fast_shutdown = "0"; 84ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown' 85SELECT @@global.innodb_fast_shutdown; 86@@global.innodb_fast_shutdown 870 88SET @@global.innodb_fast_shutdown = 1.1; 89ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown' 90SELECT @@global.innodb_fast_shutdown; 91@@global.innodb_fast_shutdown 920 93SET @@global.innodb_fast_shutdown = ' '; 94ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown' 95SELECT @@global.innodb_fast_shutdown; 96@@global.innodb_fast_shutdown 970 98SET @@global.innodb_fast_shutdown = " "; 99ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown' 100SELECT @@global.innodb_fast_shutdown; 101@@global.innodb_fast_shutdown 1020 103'#-------------------FN_DYNVARS_042_05----------------------------#' 104SET @@session.innodb_fast_shutdown = 0; 105ERROR HY000: Variable 'innodb_fast_shutdown' is a GLOBAL variable and should be set with SET GLOBAL 106SET @@innodb_fast_shutdown = 0; 107ERROR HY000: Variable 'innodb_fast_shutdown' is a GLOBAL variable and should be set with SET GLOBAL 108SET @@local.innodb_fast_shutdown = 0; 109ERROR HY000: Variable 'innodb_fast_shutdown' is a GLOBAL variable and should be set with SET GLOBAL 110'#----------------------FN_DYNVARS_042_06------------------------#' 111SELECT count(VARIABLE_VALUE) AS res_is_0 112FROM INFORMATION_SCHEMA.SESSION_VARIABLES 113WHERE VARIABLE_NAME='innodb_fast_shutdown'; 114res_is_0 1151 116'#----------------------FN_DYNVARS_042_07------------------------#' 117SELECT @@global.innodb_fast_shutdown = 118VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 119WHERE VARIABLE_NAME='innodb_fast_shutdown'; 120@@global.innodb_fast_shutdown = 121VARIABLE_VALUE 1221 123'#---------------------FN_DYNVARS_042_08-------------------------#' 124SET @@global.innodb_fast_shutdown = OFF; 125ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown' 126SELECT @@global.innodb_fast_shutdown; 127@@global.innodb_fast_shutdown 1280 129SET @@global.innodb_fast_shutdown = ON; 130ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown' 131SELECT @@global.innodb_fast_shutdown; 132@@global.innodb_fast_shutdown 1330 134'#---------------------FN_DYNVARS_042_09----------------------#' 135SET @@global.innodb_fast_shutdown = TRUE; 136SELECT @@global.innodb_fast_shutdown; 137@@global.innodb_fast_shutdown 1381 139SET @@global.innodb_fast_shutdown = FALSE; 140SELECT @@global.innodb_fast_shutdown; 141@@global.innodb_fast_shutdown 1420 143SET @@global.innodb_fast_shutdown = @global_start_value; 144SELECT @@global.innodb_fast_shutdown; 145@@global.innodb_fast_shutdown 1461 147