1SET @start_value = @@global.max_binlog_stmt_cache_size; 2SELECT @start_value; 3@start_value 418446744073709547520 5'#--------------------FN_DYNVARS_072_01------------------------#' 6SET @@global.max_binlog_stmt_cache_size = 5000; 7Warnings: 8Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '5000' 9SET @@global.max_binlog_stmt_cache_size = DEFAULT; 10SELECT @@global.max_binlog_stmt_cache_size; 11@@global.max_binlog_stmt_cache_size 1218446744073709547520 13'#---------------------FN_DYNVARS_072_02-------------------------#' 14SET @@global.max_binlog_stmt_cache_size = @start_value; 15SELECT @@global.max_binlog_stmt_cache_size = 4294967295; 16@@global.max_binlog_stmt_cache_size = 4294967295 170 18'#--------------------FN_DYNVARS_072_03------------------------#' 19SET @@global.max_binlog_stmt_cache_size = 4096; 20SELECT @@global.max_binlog_stmt_cache_size; 21@@global.max_binlog_stmt_cache_size 224096 23SET @@global.max_binlog_stmt_cache_size = 4294967295; 24Warnings: 25Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '4294967295' 26SELECT @@global.max_binlog_stmt_cache_size; 27@@global.max_binlog_stmt_cache_size 284294963200 29SET @@global.max_binlog_stmt_cache_size = 4294967294; 30Warnings: 31Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '4294967294' 32SELECT @@global.max_binlog_stmt_cache_size; 33@@global.max_binlog_stmt_cache_size 344294963200 35SET @@global.max_binlog_stmt_cache_size = 4097; 36Warnings: 37Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '4097' 38SELECT @@global.max_binlog_stmt_cache_size; 39@@global.max_binlog_stmt_cache_size 404096 41SET @@global.max_binlog_stmt_cache_size = 65535; 42Warnings: 43Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '65535' 44SELECT @@global.max_binlog_stmt_cache_size; 45@@global.max_binlog_stmt_cache_size 4661440 47'#--------------------FN_DYNVARS_072_04-------------------------#' 48SET @@global.max_binlog_stmt_cache_size = -1; 49Warnings: 50Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '-1' 51SELECT @@global.max_binlog_stmt_cache_size; 52@@global.max_binlog_stmt_cache_size 534096 54SET @@global.max_binlog_stmt_cache_size = 100000000000; 55Warnings: 56Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '100000000000' 57SELECT @@global.max_binlog_stmt_cache_size; 58@@global.max_binlog_stmt_cache_size 5999999997952 60SET @@global.max_binlog_stmt_cache_size = 10000.01; 61ERROR 42000: Incorrect argument type to variable 'max_binlog_stmt_cache_size' 62SELECT @@global.max_binlog_stmt_cache_size; 63@@global.max_binlog_stmt_cache_size 6499999997952 65SET @@global.max_binlog_stmt_cache_size = -1024; 66Warnings: 67Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '-1024' 68SELECT @@global.max_binlog_stmt_cache_size; 69@@global.max_binlog_stmt_cache_size 704096 71SET @@global.max_binlog_stmt_cache_size = 1024; 72Warnings: 73Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '1024' 74SELECT @@global.max_binlog_stmt_cache_size; 75@@global.max_binlog_stmt_cache_size 764096 77SET @@global.max_binlog_stmt_cache_size = 4294967296; 78SELECT @@global.max_binlog_stmt_cache_size; 79@@global.max_binlog_stmt_cache_size 804294967296 81SET @@global.max_binlog_stmt_cache_size = 4095; 82Warnings: 83Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '4095' 84SELECT @@global.max_binlog_stmt_cache_size; 85@@global.max_binlog_stmt_cache_size 864096 87SET @@global.max_binlog_stmt_cache_size = ON; 88ERROR 42000: Incorrect argument type to variable 'max_binlog_stmt_cache_size' 89SELECT @@global.max_binlog_stmt_cache_size; 90@@global.max_binlog_stmt_cache_size 914096 92SET @@global.max_binlog_stmt_cache_size = 'test'; 93ERROR 42000: Incorrect argument type to variable 'max_binlog_stmt_cache_size' 94SELECT @@global.max_binlog_stmt_cache_size; 95@@global.max_binlog_stmt_cache_size 964096 97'#-------------------FN_DYNVARS_072_05----------------------------#' 98SET @@session.max_binlog_stmt_cache_size = 4096; 99ERROR HY000: Variable 'max_binlog_stmt_cache_size' is a GLOBAL variable and should be set with SET GLOBAL 100SELECT @@session.max_binlog_stmt_cache_size; 101ERROR HY000: Variable 'max_binlog_stmt_cache_size' is a GLOBAL variable 102'#----------------------FN_DYNVARS_072_06------------------------#' 103SELECT @@global.max_binlog_stmt_cache_size = VARIABLE_VALUE 104FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 105WHERE VARIABLE_NAME='max_binlog_stmt_cache_size'; 106@@global.max_binlog_stmt_cache_size = VARIABLE_VALUE 1071 108SELECT @@max_binlog_stmt_cache_size = VARIABLE_VALUE 109FROM INFORMATION_SCHEMA.SESSION_VARIABLES 110WHERE VARIABLE_NAME='max_binlog_stmt_cache_size'; 111@@max_binlog_stmt_cache_size = VARIABLE_VALUE 1121 113'#---------------------FN_DYNVARS_072_07----------------------#' 114SET @@global.max_binlog_stmt_cache_size = TRUE; 115Warnings: 116Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '1' 117SELECT @@global.max_binlog_stmt_cache_size; 118@@global.max_binlog_stmt_cache_size 1194096 120SET @@global.max_binlog_stmt_cache_size = FALSE; 121Warnings: 122Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '0' 123SELECT @@global.max_binlog_stmt_cache_size; 124@@global.max_binlog_stmt_cache_size 1254096 126'#---------------------FN_DYNVARS_072_08----------------------#' 127SET @@global.max_binlog_stmt_cache_size = 5000; 128Warnings: 129Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '5000' 130SELECT @@max_binlog_stmt_cache_size = @@global.max_binlog_stmt_cache_size; 131@@max_binlog_stmt_cache_size = @@global.max_binlog_stmt_cache_size 1321 133'#---------------------FN_DYNVARS_072_09----------------------#' 134SET max_binlog_stmt_cache_size = 6000; 135ERROR HY000: Variable 'max_binlog_stmt_cache_size' is a GLOBAL variable and should be set with SET GLOBAL 136SELECT @@max_binlog_stmt_cache_size; 137@@max_binlog_stmt_cache_size 1384096 139SET local.max_binlog_stmt_cache_size = 7000; 140ERROR 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 'max_binlog_stmt_cache_size = 7000' at line 1 141SELECT local.max_binlog_stmt_cache_size; 142ERROR 42S02: Unknown table 'local' in field list 143SET global.max_binlog_stmt_cache_size = 8000; 144ERROR 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 'max_binlog_stmt_cache_size = 8000' at line 1 145SELECT global.max_binlog_stmt_cache_size; 146ERROR 42S02: Unknown table 'global' in field list 147SELECT max_binlog_stmt_cache_size = @@session.max_binlog_stmt_cache_size; 148ERROR 42S22: Unknown column 'max_binlog_stmt_cache_size' in 'field list' 149SET @@global.max_binlog_stmt_cache_size = @start_value; 150SELECT @@global.max_binlog_stmt_cache_size; 151@@global.max_binlog_stmt_cache_size 15218446744073709547520 153