1SET @start_value = @@global.read_only; 2SELECT @start_value; 3@start_value 40 5'#--------------------FN_DYNVARS_139_01------------------------#' 6SET @@global.read_only = 1; 7SET @@global.read_only = DEFAULT; 8SELECT @@global.read_only; 9@@global.read_only 100 11'#---------------------FN_DYNVARS_139_02-------------------------#' 12SET @@global.read_only = @start_value; 13SELECT @@global.read_only = 0; 14@@global.read_only = 0 151 16'#--------------------FN_DYNVARS_139_03------------------------#' 17SET @@global.read_only = 0; 18SELECT @@global.read_only; 19@@global.read_only 200 21SET @@global.read_only = 1; 22SELECT @@global.read_only; 23@@global.read_only 241 25SET @@global.read_only = TRUE; 26SELECT @@global.read_only; 27@@global.read_only 281 29SET @@global.read_only = FALSE; 30SELECT @@global.read_only; 31@@global.read_only 320 33SET @@global.read_only = ON; 34SELECT @@global.read_only; 35@@global.read_only 361 37SET @@global.read_only = OFF; 38SELECT @@global.read_only; 39@@global.read_only 400 41'#--------------------FN_DYNVARS_139_04-------------------------#' 42SET @@global.read_only = -1; 43ERROR 42000: Variable 'read_only' can't be set to the value of '-1' 44SELECT @@global.read_only; 45@@global.read_only 460 47SET @@global.read_only = 4294967296; 48ERROR 42000: Variable 'read_only' can't be set to the value of '4294967296' 49SELECT @@global.read_only; 50@@global.read_only 510 52SET @@global.read_only = 10240022115; 53ERROR 42000: Variable 'read_only' can't be set to the value of '10240022115' 54SELECT @@global.read_only; 55@@global.read_only 560 57SET @@global.read_only = 10000.01; 58ERROR 42000: Incorrect argument type to variable 'read_only' 59SELECT @@global.read_only; 60@@global.read_only 610 62SET @@global.read_only = -1024; 63ERROR 42000: Variable 'read_only' can't be set to the value of '-1024' 64SELECT @@global.read_only; 65@@global.read_only 660 67SET @@global.read_only = 42949672950; 68ERROR 42000: Variable 'read_only' can't be set to the value of '42949672950' 69SELECT @@global.read_only; 70@@global.read_only 710 72SET @@global.read_only = 'test'; 73ERROR 42000: Variable 'read_only' can't be set to the value of 'test' 74SELECT @@global.read_only; 75@@global.read_only 760 77'#-------------------FN_DYNVARS_139_05----------------------------#' 78SET @@session.read_only = 0; 79ERROR HY000: Variable 'read_only' is a GLOBAL variable and should be set with SET GLOBAL 80SELECT @@read_only; 81@@read_only 820 83'#----------------------FN_DYNVARS_139_06------------------------#' 84SELECT IF(@@global.read_only, "ON", "OFF") = VARIABLE_VALUE 85FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 86WHERE VARIABLE_NAME='read_only'; 87IF(@@global.read_only, "ON", "OFF") = VARIABLE_VALUE 881 89SELECT IF(@@read_only, "ON", "OFF") = VARIABLE_VALUE 90FROM INFORMATION_SCHEMA.SESSION_VARIABLES 91WHERE VARIABLE_NAME='read_only'; 92IF(@@read_only, "ON", "OFF") = VARIABLE_VALUE 931 94'#---------------------FN_DYNVARS_139_07----------------------#' 95SET @@global.read_only = 1; 96SELECT @@read_only = @@global.read_only; 97@@read_only = @@global.read_only 981 99'#---------------------FN_DYNVARS_139_08----------------------#' 100SET read_only = 1; 101ERROR HY000: Variable 'read_only' is a GLOBAL variable and should be set with SET GLOBAL 102SELECT @@read_only; 103@@read_only 1041 105SELECT local.read_only; 106ERROR 42S02: Unknown table 'local' in field list 107SELECT global.read_only; 108ERROR 42S02: Unknown table 'global' in field list 109SELECT read_only = @@session.read_only; 110ERROR 42S22: Unknown column 'read_only' in 'field list' 111SET @@global.read_only = @start_value; 112SELECT @@global.read_only; 113@@global.read_only 1140 115