1SET @start_value = @@global.event_scheduler; 2SELECT @start_value; 3@start_value 4OFF 5'#---------------------FN_DYNVARS_004_01-------------------------#' 6SET @@global.event_scheduler = DEFAULT; 7SELECT @@global.event_scheduler; 8@@global.event_scheduler 9OFF 10'#--------------------FN_DYNVARS_004_02------------------------#' 11SET @@global.event_scheduler = ON; 12SELECT @@global.event_scheduler; 13@@global.event_scheduler 14ON 15SET @@global.event_scheduler = OFF; 16SELECT @@global.event_scheduler; 17@@global.event_scheduler 18OFF 19SET @@global.event_scheduler = DISABLED; 20ERROR 42000: Variable 'event_scheduler' can't be set to the value of 'DISABLED' 21SELECT @@global.event_scheduler; 22@@global.event_scheduler 23OFF 24'#--------------------FN_DYNVARS_004_03-------------------------#' 25SET @@global.event_scheduler = 2; 26ERROR 42000: Variable 'event_scheduler' can't be set to the value of '2' 27SET @@global.event_scheduler = -1; 28ERROR 42000: Variable 'event_scheduler' can't be set to the value of '-1' 29SET @@global.event_scheduler = TRUEF; 30ERROR 42000: Variable 'event_scheduler' can't be set to the value of 'TRUEF' 31SET @@global.event_scheduler = TRUE_F; 32ERROR 42000: Variable 'event_scheduler' can't be set to the value of 'TRUE_F' 33SET @@global.event_scheduler = FALSE0; 34ERROR 42000: Variable 'event_scheduler' can't be set to the value of 'FALSE0' 35SET @@global.event_scheduler = OON; 36ERROR 42000: Variable 'event_scheduler' can't be set to the value of 'OON' 37SET @@global.event_scheduler = ONN; 38ERROR 42000: Variable 'event_scheduler' can't be set to the value of 'ONN' 39SET @@global.event_scheduler = OOFF; 40ERROR 42000: Variable 'event_scheduler' can't be set to the value of 'OOFF' 41SET @@global.event_scheduler = 0FF; 42ERROR 42000: Variable 'event_scheduler' can't be set to the value of '0FF' 43SET @@global.event_scheduler = ' '; 44ERROR 42000: Variable 'event_scheduler' can't be set to the value of ' ' 45SET @@global.event_scheduler = " "; 46ERROR 42000: Variable 'event_scheduler' can't be set to the value of ' ' 47SET @@global.event_scheduler = ''; 48ERROR 42000: Variable 'event_scheduler' can't be set to the value of '' 49'#-------------------FN_DYNVARS_004_04----------------------------#' 50SET @@session.event_scheduler = OFF; 51ERROR HY000: Variable 'event_scheduler' is a GLOBAL variable and should be set with SET GLOBAL 52SELECT @@session.event_scheduler; 53ERROR HY000: Variable 'event_scheduler' is a GLOBAL variable 54'#----------------------FN_DYNVARS_004_05------------------------#' 55SELECT @@global.event_scheduler = VARIABLE_VALUE 56FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 57WHERE VARIABLE_NAME='event_scheduler'; 58@@global.event_scheduler = VARIABLE_VALUE 591 60'#---------------------FN_DYNVARS_004_06----------------------#' 61SET @@global.event_scheduler = 0; 62SELECT @@global.event_scheduler; 63@@global.event_scheduler 64OFF 65SET @@global.event_scheduler = 1; 66SELECT @@global.event_scheduler; 67@@global.event_scheduler 68ON 69'#---------------------FN_DYNVARS_004_07----------------------#' 70SET @@global.event_scheduler = TRUE; 71SELECT @@global.event_scheduler; 72@@global.event_scheduler 73ON 74SET @@global.event_scheduler = FALSE; 75SELECT @@global.event_scheduler; 76@@global.event_scheduler 77OFF 78'#---------------------FN_DYNVARS_004_08----------------------#' 79SET @@global.event_scheduler = ON; 80SELECT @@event_scheduler = @@global.event_scheduler; 81@@event_scheduler = @@global.event_scheduler 821 83'#---------------------FN_DYNVARS_004_09----------------------#' 84SET event_scheduler = ON; 85ERROR HY000: Variable 'event_scheduler' is a GLOBAL variable and should be set with SET GLOBAL 86SELECT local.event_scheduler; 87ERROR 42S02: Unknown table 'local' in field list 88SELECT global.event_scheduler; 89ERROR 42S02: Unknown table 'global' in field list 90SELECT event_scheduler = @@session.event_scheduler; 91ERROR 42S22: Unknown column 'event_scheduler' in 'field list' 92SET @@global.event_scheduler = @start_value; 93SELECT @@global.event_scheduler; 94@@global.event_scheduler 95OFF 96