1SET @start_value = @@global.expire_logs_days; 2'#--------------------FN_DYNVARS_029_01------------------------#' 3SET @@global.expire_logs_days = 99; 4SET @@global.expire_logs_days = DEFAULT; 5SELECT @@global.expire_logs_days = 0; 6@@global.expire_logs_days = 0 71 8'#---------------------FN_DYNVARS_029_02-------------------------#' 9SET @@global.expire_logs_days = @start_value; 10SELECT @@global.expire_logs_days = @start_value; 11@@global.expire_logs_days = @start_value 121 13'#--------------------FN_DYNVARS_029_03------------------------#' 14SET @@global.expire_logs_days = 0; 15SELECT @@global.expire_logs_days; 16@@global.expire_logs_days 170 18SET @@global.expire_logs_days = 99; 19SELECT @@global.expire_logs_days; 20@@global.expire_logs_days 2199 22SET @@global.expire_logs_days = 10; 23SELECT @@global.expire_logs_days; 24@@global.expire_logs_days 2510 26SET @@global.expire_logs_days = 21; 27SELECT @@global.expire_logs_days; 28@@global.expire_logs_days 2921 30'#--------------------FN_DYNVARS_029_04-------------------------#' 31SET @@global.expire_logs_days = -1; 32Warnings: 33Warning 1292 Truncated incorrect expire_logs_days value: '-1' 34SELECT @@global.expire_logs_days; 35@@global.expire_logs_days 360 37SET @@global.expire_logs_days = 100; 38Warnings: 39Warning 1292 Truncated incorrect expire_logs_days value: '100' 40SELECT @@global.expire_logs_days; 41@@global.expire_logs_days 4299 43SET @@global.expire_logs_days = 1024; 44Warnings: 45Warning 1292 Truncated incorrect expire_logs_days value: '1024' 46SELECT @@global.expire_logs_days; 47@@global.expire_logs_days 4899 49SET @@global.expire_logs_days = 10000.01; 50ERROR 42000: Incorrect argument type to variable 'expire_logs_days' 51SELECT @@global.expire_logs_days; 52@@global.expire_logs_days 5399 54SET @@global.expire_logs_days = -1024; 55Warnings: 56Warning 1292 Truncated incorrect expire_logs_days value: '-1024' 57SELECT @@global.expire_logs_days; 58@@global.expire_logs_days 590 60SET @@global.expire_logs_days = 42949672950; 61Warnings: 62Warning 1292 Truncated incorrect expire_logs_days value: '42949672950' 63SELECT @@global.expire_logs_days; 64@@global.expire_logs_days 6599 66SET @@global.expire_logs_days = ON; 67ERROR 42000: Incorrect argument type to variable 'expire_logs_days' 68SELECT @@global.expire_logs_days; 69@@global.expire_logs_days 7099 71SET @@global.expire_logs_days = 'test'; 72ERROR 42000: Incorrect argument type to variable 'expire_logs_days' 73SELECT @@global.expire_logs_days; 74@@global.expire_logs_days 7599 76'#-------------------FN_DYNVARS_029_05----------------------------#' 77SET @@session.expire_logs_days = 0; 78ERROR HY000: Variable 'expire_logs_days' is a GLOBAL variable and should be set with SET GLOBAL 79SELECT @@expire_logs_days; 80@@expire_logs_days 8199 82'#----------------------FN_DYNVARS_029_06------------------------#' 83SELECT @@global.expire_logs_days = VARIABLE_VALUE 84FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 85WHERE VARIABLE_NAME='expire_logs_days'; 86@@global.expire_logs_days = VARIABLE_VALUE 871 88SELECT @@expire_logs_days = VARIABLE_VALUE 89FROM INFORMATION_SCHEMA.SESSION_VARIABLES 90WHERE VARIABLE_NAME='expire_logs_days'; 91@@expire_logs_days = VARIABLE_VALUE 921 93'#---------------------FN_DYNVARS_029_07----------------------#' 94SET @@global.expire_logs_days = TRUE; 95SELECT @@global.expire_logs_days; 96@@global.expire_logs_days 971 98SET @@global.expire_logs_days = FALSE; 99SELECT @@global.expire_logs_days; 100@@global.expire_logs_days 1010 102'#---------------------FN_DYNVARS_029_08----------------------#' 103SET @@global.expire_logs_days = 1; 104SELECT @@expire_logs_days = @@global.expire_logs_days; 105@@expire_logs_days = @@global.expire_logs_days 1061 107'#---------------------FN_DYNVARS_029_09----------------------#' 108SET expire_logs_days = 1; 109ERROR HY000: Variable 'expire_logs_days' is a GLOBAL variable and should be set with SET GLOBAL 110SELECT @@expire_logs_days; 111@@expire_logs_days 1121 113SELECT local.expire_logs_days; 114ERROR 42S02: Unknown table 'local' in field list 115SELECT global.expire_logs_days; 116ERROR 42S02: Unknown table 'global' in field list 117SELECT expire_logs_days = @@session.expire_logs_days; 118ERROR 42S22: Unknown column 'expire_logs_days' in 'field list' 119SET @@global.expire_logs_days = @start_value; 120