1SET @global_start_value = @@global.slave_compressed_protocol; 2SELECT @global_start_value; 3@global_start_value 40 5'#--------------------FN_DYNVARS_147_01------------------------#' 6SET @@global.slave_compressed_protocol = 1; 7SET @@global.slave_compressed_protocol = DEFAULT; 8SELECT @@global.slave_compressed_protocol; 9@@global.slave_compressed_protocol 100 11'#---------------------FN_DYNVARS_147_02-------------------------#' 12SET slave_compressed_protocol = 1; 13ERROR HY000: Variable 'slave_compressed_protocol' is a GLOBAL variable and should be set with SET GLOBAL 14SELECT @@slave_compressed_protocol; 15@@slave_compressed_protocol 160 17SELECT global.slave_compressed_protocol; 18ERROR 42S02: Unknown table 'global' in field list 19SET global slave_compressed_protocol = 1; 20SELECT @@global.slave_compressed_protocol; 21@@global.slave_compressed_protocol 221 23'#--------------------FN_DYNVARS_147_03------------------------#' 24SET @@global.slave_compressed_protocol = 0; 25SELECT @@global.slave_compressed_protocol; 26@@global.slave_compressed_protocol 270 28SET @@global.slave_compressed_protocol = 1; 29SELECT @@global.slave_compressed_protocol; 30@@global.slave_compressed_protocol 311 32'#--------------------FN_DYNVARS_147_04-------------------------#' 33SET @@global.slave_compressed_protocol = -1; 34ERROR 42000: Variable 'slave_compressed_protocol' can't be set to the value of '-1' 35SET @@global.slave_compressed_protocol = 2; 36ERROR 42000: Variable 'slave_compressed_protocol' can't be set to the value of '2' 37SET @@global.slave_compressed_protocol = "1.00"; 38ERROR 42000: Variable 'slave_compressed_protocol' can't be set to the value of '1.00' 39SET @@global.slave_compressed_protocol = "Y"; 40ERROR 42000: Variable 'slave_compressed_protocol' can't be set to the value of 'Y' 41SET @@global.slave_compressed_protocol = YES; 42ERROR 42000: Variable 'slave_compressed_protocol' can't be set to the value of 'YES' 43SET @@global.slave_compressed_protocol = ONN; 44ERROR 42000: Variable 'slave_compressed_protocol' can't be set to the value of 'ONN' 45SET @@global.slave_compressed_protocol = 0FF; 46ERROR 42000: Variable 'slave_compressed_protocol' can't be set to the value of '0FF' 47SET @@global.slave_compressed_protocol = ' 1'; 48ERROR 42000: Variable 'slave_compressed_protocol' can't be set to the value of ' 1' 49SET @@global.slave_compressed_protocol = NO; 50ERROR 42000: Variable 'slave_compressed_protocol' can't be set to the value of 'NO' 51'#-------------------FN_DYNVARS_147_05----------------------------#' 52SET @@session.slave_compressed_protocol = 0; 53ERROR HY000: Variable 'slave_compressed_protocol' is a GLOBAL variable and should be set with SET GLOBAL 54SET @@slave_compressed_protocol = 0; 55ERROR HY000: Variable 'slave_compressed_protocol' is a GLOBAL variable and should be set with SET GLOBAL 56SET @@local.slave_compressed_protocol = 0; 57ERROR HY000: Variable 'slave_compressed_protocol' is a GLOBAL variable and should be set with SET GLOBAL 58SELECT @@session.slave_compressed_protocol; 59ERROR HY000: Variable 'slave_compressed_protocol' is a GLOBAL variable 60SELECT @@local.slave_compressed_protocol; 61ERROR HY000: Variable 'slave_compressed_protocol' is a GLOBAL variable 62'#----------------------FN_DYNVARS_147_06------------------------#' 63SELECT count(VARIABLE_VALUE) 64FROM INFORMATION_SCHEMA.SESSION_VARIABLES 65WHERE VARIABLE_NAME='slave_compressed_protocol'; 66count(VARIABLE_VALUE) 671 68'#----------------------FN_DYNVARS_147_07------------------------#' 69SELECT IF(@@global.slave_compressed_protocol, "ON", "OFF") = VARIABLE_VALUE 70FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 71WHERE VARIABLE_NAME='slave_compressed_protocol'; 72IF(@@global.slave_compressed_protocol, "ON", "OFF") = VARIABLE_VALUE 731 74SELECT @@global.slave_compressed_protocol; 75@@global.slave_compressed_protocol 761 77SELECT VARIABLE_VALUE 78FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 79WHERE VARIABLE_NAME='slave_compressed_protocol'; 80VARIABLE_VALUE 81ON 82'#---------------------FN_DYNVARS_147_08-------------------------#' 83SET @@global.slave_compressed_protocol = OFF; 84SELECT @@global.slave_compressed_protocol; 85@@global.slave_compressed_protocol 860 87SET @@global.slave_compressed_protocol = ON; 88SELECT @@global.slave_compressed_protocol; 89@@global.slave_compressed_protocol 901 91'#---------------------FN_DYNVARS_147_09----------------------#' 92SET @@global.slave_compressed_protocol = TRUE; 93SELECT @@global.slave_compressed_protocol; 94@@global.slave_compressed_protocol 951 96SET @@global.slave_compressed_protocol = FALSE; 97SELECT @@global.slave_compressed_protocol; 98@@global.slave_compressed_protocol 990 100SET @@global.slave_compressed_protocol = @global_start_value; 101SELECT @@global.slave_compressed_protocol; 102@@global.slave_compressed_protocol 1030 104