1SET @start_value = @@global.automatic_sp_privileges; 2SELECT @start_value; 3@start_value 41 5'#--------------------FN_DYNVARS_004_01------------------------#' 6SET @@global.automatic_sp_privileges = 0; 7SET @@global.automatic_sp_privileges = DEFAULT; 8SELECT @@global.automatic_sp_privileges; 9@@global.automatic_sp_privileges 101 11'#---------------------FN_DYNVARS_004_02-------------------------#' 12SET @@global.automatic_sp_privileges = @start_value; 13SELECT @@global.automatic_sp_privileges = TRUE; 14@@global.automatic_sp_privileges = TRUE 151 16'#--------------------FN_DYNVARS_004_03------------------------#' 17SET @@global.automatic_sp_privileges = 0; 18SELECT @@global.automatic_sp_privileges; 19@@global.automatic_sp_privileges 200 21SET @@global.automatic_sp_privileges = 1; 22SELECT @@global.automatic_sp_privileges; 23@@global.automatic_sp_privileges 241 25'#--------------------FN_DYNVARS_004_04-------------------------#' 26SET @@global.automatic_sp_privileges = 2; 27ERROR 42000: Variable 'automatic_sp_privileges' can't be set to the value of '2' 28SET @@global.automatic_sp_privileges = -1; 29ERROR 42000: Variable 'automatic_sp_privileges' can't be set to the value of '-1' 30SET @@global.automatic_sp_privileges = TRUEF; 31ERROR 42000: Variable 'automatic_sp_privileges' can't be set to the value of 'TRUEF' 32SET @@global.automatic_sp_privileges = TRUE_F; 33ERROR 42000: Variable 'automatic_sp_privileges' can't be set to the value of 'TRUE_F' 34SET @@global.automatic_sp_privileges = FALSE0; 35ERROR 42000: Variable 'automatic_sp_privileges' can't be set to the value of 'FALSE0' 36SET @@global.automatic_sp_privileges = OON; 37ERROR 42000: Variable 'automatic_sp_privileges' can't be set to the value of 'OON' 38SET @@global.automatic_sp_privileges = ONN; 39ERROR 42000: Variable 'automatic_sp_privileges' can't be set to the value of 'ONN' 40SET @@global.automatic_sp_privileges = OOFF; 41ERROR 42000: Variable 'automatic_sp_privileges' can't be set to the value of 'OOFF' 42SET @@global.automatic_sp_privileges = 0FF; 43ERROR 42000: Variable 'automatic_sp_privileges' can't be set to the value of '0FF' 44SET @@global.automatic_sp_privileges = ' '; 45ERROR 42000: Variable 'automatic_sp_privileges' can't be set to the value of ' ' 46SET @@global.automatic_sp_privileges = " "; 47ERROR 42000: Variable 'automatic_sp_privileges' can't be set to the value of ' ' 48SET @@global.automatic_sp_privileges = ''; 49ERROR 42000: Variable 'automatic_sp_privileges' can't be set to the value of '' 50'#-------------------FN_DYNVARS_004_05----------------------------#' 51SET @@session.automatic_sp_privileges = 1; 52ERROR HY000: Variable 'automatic_sp_privileges' is a GLOBAL variable and should be set with SET GLOBAL 53SELECT @@session.automatic_sp_privileges; 54ERROR HY000: Variable 'automatic_sp_privileges' is a GLOBAL variable 55'#----------------------FN_DYNVARS_004_06------------------------#' 56SELECT IF(@@global.automatic_sp_privileges, "ON", "OFF") = VARIABLE_VALUE 57FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 58WHERE VARIABLE_NAME='automatic_sp_privileges'; 59IF(@@global.automatic_sp_privileges, "ON", "OFF") = VARIABLE_VALUE 601 61'#---------------------FN_DYNVARS_004_07----------------------#' 62SET @@global.automatic_sp_privileges = OFF; 63SELECT @@global.automatic_sp_privileges; 64@@global.automatic_sp_privileges 650 66SET @@global.automatic_sp_privileges = ON; 67SELECT @@global.automatic_sp_privileges; 68@@global.automatic_sp_privileges 691 70'#---------------------FN_DYNVARS_004_08----------------------#' 71SET @@global.automatic_sp_privileges = TRUE; 72SELECT @@global.automatic_sp_privileges; 73@@global.automatic_sp_privileges 741 75SET @@global.automatic_sp_privileges = FALSE; 76SELECT @@global.automatic_sp_privileges; 77@@global.automatic_sp_privileges 780 79'#---------------------FN_DYNVARS_004_09----------------------#' 80SET @@global.automatic_sp_privileges = 1; 81SELECT @@automatic_sp_privileges = @@global.automatic_sp_privileges; 82@@automatic_sp_privileges = @@global.automatic_sp_privileges 831 84'#---------------------FN_DYNVARS_004_10----------------------#' 85SET automatic_sp_privileges = 1; 86ERROR HY000: Variable 'automatic_sp_privileges' is a GLOBAL variable and should be set with SET GLOBAL 87SET local.automatic_sp_privileges = 1; 88ERROR 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 'automatic_sp_privileges = 1' at line 1 89SELECT local.automatic_sp_privileges; 90ERROR 42S02: Unknown table 'local' in field list 91SET global.automatic_sp_privileges = 1; 92ERROR 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 'automatic_sp_privileges = 1' at line 1 93SELECT global.automatic_sp_privileges; 94ERROR 42S02: Unknown table 'global' in field list 95SELECT automatic_sp_privileges = @@session.automatic_sp_privileges; 96ERROR 42S22: Unknown column 'automatic_sp_privileges' in 'field list' 97SET @@global.automatic_sp_privileges = @start_value; 98SELECT @@global.automatic_sp_privileges; 99@@global.automatic_sp_privileges 1001 101