1SET @start_value = @@global.expire_logs_days; 2SELECT @start_value; 3@start_value 40 5'#--------------------FN_DYNVARS_029_01------------------------#' 6SET @@global.expire_logs_days = 99; 7SET @@global.expire_logs_days = DEFAULT; 8SELECT @@global.expire_logs_days; 9@@global.expire_logs_days 100 11'#---------------------FN_DYNVARS_029_02-------------------------#' 12SET @@global.expire_logs_days = @start_value; 13SELECT @@global.expire_logs_days = 0; 14@@global.expire_logs_days = 0 151 16'#--------------------FN_DYNVARS_029_03------------------------#' 17SET @@global.expire_logs_days = 0; 18SELECT @@global.expire_logs_days; 19@@global.expire_logs_days 200 21SET @@global.expire_logs_days = 99; 22SELECT @@global.expire_logs_days; 23@@global.expire_logs_days 2499 25SET @@global.expire_logs_days = 10; 26SELECT @@global.expire_logs_days; 27@@global.expire_logs_days 2810 29SET @@global.expire_logs_days = 21; 30SELECT @@global.expire_logs_days; 31@@global.expire_logs_days 3221 33'#--------------------FN_DYNVARS_029_04-------------------------#' 34SET @@global.expire_logs_days = -1; 35Warnings: 36Warning 1292 Truncated incorrect expire_logs_days value: '-1' 37SELECT @@global.expire_logs_days; 38@@global.expire_logs_days 390 40SET @@global.expire_logs_days = 100; 41Warnings: 42Warning 1292 Truncated incorrect expire_logs_days value: '100' 43SELECT @@global.expire_logs_days; 44@@global.expire_logs_days 4599 46SET @@global.expire_logs_days = 1024; 47Warnings: 48Warning 1292 Truncated incorrect expire_logs_days value: '1024' 49SELECT @@global.expire_logs_days; 50@@global.expire_logs_days 5199 52SET @@global.expire_logs_days = 10000.01; 53ERROR 42000: Incorrect argument type to variable 'expire_logs_days' 54SELECT @@global.expire_logs_days; 55@@global.expire_logs_days 5699 57SET @@global.expire_logs_days = -1024; 58Warnings: 59Warning 1292 Truncated incorrect expire_logs_days value: '-1024' 60SELECT @@global.expire_logs_days; 61@@global.expire_logs_days 620 63SET @@global.expire_logs_days = 42949672950; 64Warnings: 65Warning 1292 Truncated incorrect expire_logs_days value: '42949672950' 66SELECT @@global.expire_logs_days; 67@@global.expire_logs_days 6899 69SET @@global.expire_logs_days = ON; 70ERROR 42000: Incorrect argument type to variable 'expire_logs_days' 71SELECT @@global.expire_logs_days; 72@@global.expire_logs_days 7399 74SET @@global.expire_logs_days = 'test'; 75ERROR 42000: Incorrect argument type to variable 'expire_logs_days' 76SELECT @@global.expire_logs_days; 77@@global.expire_logs_days 7899 79'#-------------------FN_DYNVARS_029_05----------------------------#' 80SET @@session.expire_logs_days = 0; 81ERROR HY000: Variable 'expire_logs_days' is a GLOBAL variable and should be set with SET GLOBAL 82SELECT @@expire_logs_days; 83@@expire_logs_days 8499 85'#----------------------FN_DYNVARS_029_06------------------------#' 86SELECT @@global.expire_logs_days = VARIABLE_VALUE 87FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 88WHERE VARIABLE_NAME='expire_logs_days'; 89@@global.expire_logs_days = VARIABLE_VALUE 901 91SELECT @@expire_logs_days = VARIABLE_VALUE 92FROM INFORMATION_SCHEMA.SESSION_VARIABLES 93WHERE VARIABLE_NAME='expire_logs_days'; 94@@expire_logs_days = VARIABLE_VALUE 951 96'#---------------------FN_DYNVARS_029_07----------------------#' 97SET @@global.expire_logs_days = TRUE; 98SELECT @@global.expire_logs_days; 99@@global.expire_logs_days 1001 101SET @@global.expire_logs_days = FALSE; 102SELECT @@global.expire_logs_days; 103@@global.expire_logs_days 1040 105'#---------------------FN_DYNVARS_029_08----------------------#' 106SET @@global.expire_logs_days = 1; 107SELECT @@expire_logs_days = @@global.expire_logs_days; 108@@expire_logs_days = @@global.expire_logs_days 1091 110'#---------------------FN_DYNVARS_029_09----------------------#' 111SET expire_logs_days = 1; 112ERROR HY000: Variable 'expire_logs_days' is a GLOBAL variable and should be set with SET GLOBAL 113SELECT @@expire_logs_days; 114@@expire_logs_days 1151 116SET local.expire_logs_days = 1; 117ERROR 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.expire_logs_days = 1' at line 1 118SELECT local.expire_logs_days; 119ERROR 42S02: Unknown table 'local' in field list 120SET global.expire_logs_days = 1; 121ERROR 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.expire_logs_days = 1' at line 1 122SELECT global.expire_logs_days; 123ERROR 42S02: Unknown table 'global' in field list 124SELECT expire_logs_days = @@session.expire_logs_days; 125ERROR 42S22: Unknown column 'expire_logs_days' in 'field list' 126SET @@global.expire_logs_days = @start_value; 127SELECT @@global.expire_logs_days; 128@@global.expire_logs_days 1290 130