1SET @start_value = @@global.check_proxy_users; 2SELECT @start_value; 3@start_value 40 5'#----- 1.2.2.3 Default ---------------------------------------#' 6SET @@global.check_proxy_users = 1; 7SET @@global.check_proxy_users = DEFAULT; 8SELECT @@global.check_proxy_users; 9@@global.check_proxy_users 100 11SET @@global.check_proxy_users = @start_value; 12SELECT @@global.check_proxy_users = 0; 13@@global.check_proxy_users = 0 141 15'#----- 1.2.1 Valid values -------------------------------------#' 16SET @@global.check_proxy_users = 0; 17SELECT @@global.check_proxy_users; 18@@global.check_proxy_users 190 20SET @@global.check_proxy_users = 1; 21SELECT @@global.check_proxy_users; 22@@global.check_proxy_users 231 24SET @@global.check_proxy_users = TRUE; 25SELECT @@global.check_proxy_users; 26@@global.check_proxy_users 271 28SET @@global.check_proxy_users = FALSE; 29SELECT @@global.check_proxy_users; 30@@global.check_proxy_users 310 32SET @@global.check_proxy_users = ON; 33SELECT @@global.check_proxy_users; 34@@global.check_proxy_users 351 36SET @@global.check_proxy_users = OFF; 37SELECT @@global.check_proxy_users; 38@@global.check_proxy_users 390 40'#----- 1.2.1 Invalid values -----------------------------------#' 41SET @@global.check_proxy_users = -1; 42ERROR 42000: Variable 'check_proxy_users' can't be set to the value of '-1' 43SELECT @@global.check_proxy_users; 44@@global.check_proxy_users 450 46SET @@global.check_proxy_users = 4294967296; 47ERROR 42000: Variable 'check_proxy_users' can't be set to the value of '4294967296' 48SELECT @@global.check_proxy_users; 49@@global.check_proxy_users 500 51SET @@global.check_proxy_users = 10240022115; 52ERROR 42000: Variable 'check_proxy_users' can't be set to the value of '10240022115' 53SELECT @@global.check_proxy_users; 54@@global.check_proxy_users 550 56SET @@global.check_proxy_users = 10000.01; 57ERROR 42000: Incorrect argument type to variable 'check_proxy_users' 58SELECT @@global.check_proxy_users; 59@@global.check_proxy_users 600 61SET @@global.check_proxy_users = -1024; 62ERROR 42000: Variable 'check_proxy_users' can't be set to the value of '-1024' 63SELECT @@global.check_proxy_users; 64@@global.check_proxy_users 650 66SET @@global.check_proxy_users = 42949672950; 67ERROR 42000: Variable 'check_proxy_users' can't be set to the value of '42949672950' 68SELECT @@global.check_proxy_users; 69@@global.check_proxy_users 700 71SET @@global.check_proxy_users = 'test'; 72ERROR 42000: Variable 'check_proxy_users' can't be set to the value of 'test' 73SELECT @@global.check_proxy_users; 74@@global.check_proxy_users 750 76'#----- 1.2.5 Global/Session variable ---------------------------#' 77SET @@session.check_proxy_users = 0; 78ERROR HY000: Variable 'check_proxy_users' is a GLOBAL variable and should be set with SET GLOBAL 79SELECT @@check_proxy_users; 80@@check_proxy_users 810 82SELECT IF(@@global.check_proxy_users, "ON", "OFF") = VARIABLE_VALUE 83FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 84WHERE VARIABLE_NAME='check_proxy_users'; 85IF(@@global.check_proxy_users, "ON", "OFF") = VARIABLE_VALUE 861 87SELECT IF(@@check_proxy_users, "ON", "OFF") = VARIABLE_VALUE 88FROM INFORMATION_SCHEMA.SESSION_VARIABLES 89WHERE VARIABLE_NAME='check_proxy_users'; 90IF(@@check_proxy_users, "ON", "OFF") = VARIABLE_VALUE 911 92SET @@global.check_proxy_users = 1; 93SELECT @@check_proxy_users = @@global.check_proxy_users; 94@@check_proxy_users = @@global.check_proxy_users 951 96'#----- 1.2.6 Global/Session variable ---------------------------#' 97SET check_proxy_users = 1; 98ERROR HY000: Variable 'check_proxy_users' is a GLOBAL variable and should be set with SET GLOBAL 99SELECT @@check_proxy_users; 100@@check_proxy_users 1011 102SET local.check_proxy_users = 1; 103ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'local.check_proxy_users = 1' at line 1 104SELECT local.check_proxy_users; 105ERROR 42S02: Unknown table 'local' in field list 106SET global.check_proxy_users = 1; 107ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'global.check_proxy_users = 1' at line 1 108SELECT global.check_proxy_users; 109ERROR 42S02: Unknown table 'global' in field list 110SELECT check_proxy_users = @@session.check_proxy_users; 111ERROR 42S22: Unknown column 'check_proxy_users' in 'field list' 112SET @@global.check_proxy_users = @start_value; 113SELECT @@global.check_proxy_users; 114@@global.check_proxy_users 1150 116