1SET @start_value = @@global.max_relay_log_size; 2SELECT @start_value; 3@start_value 40 5'#--------------------FN_DYNVARS_082_01------------------------#' 6SET @@global.max_relay_log_size = 5000; 7Warnings: 8Warning 1292 Truncated incorrect max_relay_log_size value: '5000' 9SET @@global.max_relay_log_size = DEFAULT; 10SELECT @@global.max_relay_log_size; 11@@global.max_relay_log_size 120 13'#---------------------FN_DYNVARS_082_02-------------------------#' 14SET @@global.max_relay_log_size = @start_value; 15SELECT @@global.max_relay_log_size = 1024; 16@@global.max_relay_log_size = 1024 170 18'#--------------------FN_DYNVARS_082_03------------------------#' 19SET @@global.max_relay_log_size = 0; 20SELECT @@global.max_relay_log_size; 21@@global.max_relay_log_size 220 23SET @@global.max_relay_log_size = 1; 24Warnings: 25Warning 1292 Truncated incorrect max_relay_log_size value: '1' 26SELECT @@global.max_relay_log_size; 27@@global.max_relay_log_size 280 29SET @@global.max_relay_log_size = 1073741824; 30SELECT @@global.max_relay_log_size; 31@@global.max_relay_log_size 321073741824 33SET @@global.max_relay_log_size = 1073741823; 34Warnings: 35Warning 1292 Truncated incorrect max_relay_log_size value: '1073741823' 36SELECT @@global.max_relay_log_size; 37@@global.max_relay_log_size 381073737728 39SET @@global.max_relay_log_size = 65535; 40Warnings: 41Warning 1292 Truncated incorrect max_relay_log_size value: '65535' 42SELECT @@global.max_relay_log_size; 43@@global.max_relay_log_size 4461440 45'#--------------------FN_DYNVARS_082_04-------------------------#' 46SET @@global.max_relay_log_size = -1; 47Warnings: 48Warning 1292 Truncated incorrect max_relay_log_size value: '-1' 49SELECT @@global.max_relay_log_size; 50@@global.max_relay_log_size 510 52SET @@global.max_relay_log_size = 100000000000; 53Warnings: 54Warning 1292 Truncated incorrect max_relay_log_size value: '100000000000' 55SELECT @@global.max_relay_log_size; 56@@global.max_relay_log_size 571073741824 58SET @@global.max_relay_log_size = 10000.01; 59ERROR 42000: Incorrect argument type to variable 'max_relay_log_size' 60SELECT @@global.max_relay_log_size; 61@@global.max_relay_log_size 621073741824 63SET @@global.max_relay_log_size = -1024; 64Warnings: 65Warning 1292 Truncated incorrect max_relay_log_size value: '-1024' 66SELECT @@global.max_relay_log_size; 67@@global.max_relay_log_size 680 69SET @@global.max_relay_log_size = 1073741825; 70Warnings: 71Warning 1292 Truncated incorrect max_relay_log_size value: '1073741825' 72SELECT @@global.max_relay_log_size; 73@@global.max_relay_log_size 741073741824 75SET @@global.max_relay_log_size = 10737418241; 76Warnings: 77Warning 1292 Truncated incorrect max_relay_log_size value: '10737418241' 78SELECT @@global.max_relay_log_size; 79@@global.max_relay_log_size 801073741824 81SET @@global.max_relay_log_size = ON; 82ERROR 42000: Incorrect argument type to variable 'max_relay_log_size' 83SELECT @@global.max_relay_log_size; 84@@global.max_relay_log_size 851073741824 86SET @@global.max_relay_log_size = 'test'; 87ERROR 42000: Incorrect argument type to variable 'max_relay_log_size' 88SELECT @@global.max_relay_log_size; 89@@global.max_relay_log_size 901073741824 91SET @@global.max_relay_log_size = ' '; 92ERROR 42000: Incorrect argument type to variable 'max_relay_log_size' 93SELECT @@global.max_relay_log_size; 94@@global.max_relay_log_size 951073741824 96'#-------------------FN_DYNVARS_082_05----------------------------#' 97SET @@session.max_relay_log_size = 4096; 98ERROR HY000: Variable 'max_relay_log_size' is a GLOBAL variable and should be set with SET GLOBAL 99SELECT @@session.max_relay_log_size; 100ERROR HY000: Variable 'max_relay_log_size' is a GLOBAL variable 101'#----------------------FN_DYNVARS_082_06------------------------#' 102SELECT @@global.max_relay_log_size = VARIABLE_VALUE 103FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 104WHERE VARIABLE_NAME='max_relay_log_size'; 105@@global.max_relay_log_size = VARIABLE_VALUE 1061 107SELECT @@max_relay_log_size = VARIABLE_VALUE 108FROM INFORMATION_SCHEMA.SESSION_VARIABLES 109WHERE VARIABLE_NAME='max_relay_log_size'; 110@@max_relay_log_size = VARIABLE_VALUE 1111 112'#---------------------FN_DYNVARS_082_07----------------------#' 113SET @@global.max_relay_log_size = TRUE; 114Warnings: 115Warning 1292 Truncated incorrect max_relay_log_size value: '1' 116SELECT @@global.max_relay_log_size; 117@@global.max_relay_log_size 1180 119SET @@global.max_relay_log_size = FALSE; 120SELECT @@global.max_relay_log_size; 121@@global.max_relay_log_size 1220 123'#---------------------FN_DYNVARS_082_08----------------------#' 124SET @@global.max_relay_log_size = 5000; 125Warnings: 126Warning 1292 Truncated incorrect max_relay_log_size value: '5000' 127SELECT @@max_relay_log_size = @@global.max_relay_log_size; 128@@max_relay_log_size = @@global.max_relay_log_size 1291 130'#---------------------FN_DYNVARS_082_09----------------------#' 131SET max_relay_log_size = 6000; 132ERROR HY000: Variable 'max_relay_log_size' is a GLOBAL variable and should be set with SET GLOBAL 133SELECT @@max_relay_log_size; 134@@max_relay_log_size 1354096 136SET local.max_relay_log_size = 7000; 137ERROR 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.max_relay_log_size = 7000' at line 1 138SELECT local.max_relay_log_size; 139ERROR 42S02: Unknown table 'local' in field list 140SET global.max_relay_log_size = 8000; 141ERROR 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.max_relay_log_size = 8000' at line 1 142SELECT global.max_relay_log_size; 143ERROR 42S02: Unknown table 'global' in field list 144SELECT max_relay_log_size = @@session.max_relay_log_size; 145ERROR 42S22: Unknown column 'max_relay_log_size' in 'field list' 146SET @@global.max_relay_log_size = @start_value; 147SELECT @@global.max_relay_log_size; 148@@global.max_relay_log_size 1490 150