1SET @start_value = @@global.max_binlog_stmt_cache_size; 2SELECT @start_value; 3@start_value 4max_binlog_stmt_cache_size 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 12max_binlog_stmt_cache_size 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 59max_binlog_stmt_cache_size 60SET @@global.max_binlog_stmt_cache_size = 1024*1024; 61SET @@global.max_binlog_stmt_cache_size = 10000.01; 62ERROR 42000: Incorrect argument type to variable 'max_binlog_stmt_cache_size' 63SELECT @@global.max_binlog_stmt_cache_size; 64@@global.max_binlog_stmt_cache_size 651048576 66SET @@global.max_binlog_stmt_cache_size = -1024; 67Warnings: 68Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '-1024' 69SELECT @@global.max_binlog_stmt_cache_size; 70@@global.max_binlog_stmt_cache_size 714096 72SET @@global.max_binlog_stmt_cache_size = 1024; 73Warnings: 74Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '1024' 75SELECT @@global.max_binlog_stmt_cache_size; 76@@global.max_binlog_stmt_cache_size 774096 78SET @@global.max_binlog_stmt_cache_size = 4294967296; 79SELECT @@global.max_binlog_stmt_cache_size; 80@@global.max_binlog_stmt_cache_size 81max_binlog_stmt_cache_size 82SET @@global.max_binlog_stmt_cache_size = 4095; 83Warnings: 84Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '4095' 85SELECT @@global.max_binlog_stmt_cache_size; 86@@global.max_binlog_stmt_cache_size 874096 88SET @@global.max_binlog_stmt_cache_size = ON; 89ERROR 42000: Incorrect argument type to variable 'max_binlog_stmt_cache_size' 90SELECT @@global.max_binlog_stmt_cache_size; 91@@global.max_binlog_stmt_cache_size 924096 93SET @@global.max_binlog_stmt_cache_size = 'test'; 94ERROR 42000: Incorrect argument type to variable 'max_binlog_stmt_cache_size' 95SELECT @@global.max_binlog_stmt_cache_size; 96@@global.max_binlog_stmt_cache_size 974096 98'#-------------------FN_DYNVARS_072_05----------------------------#' 99SET @@session.max_binlog_stmt_cache_size = 4096; 100ERROR HY000: Variable 'max_binlog_stmt_cache_size' is a GLOBAL variable and should be set with SET GLOBAL 101SELECT @@session.max_binlog_stmt_cache_size; 102ERROR HY000: Variable 'max_binlog_stmt_cache_size' is a GLOBAL variable 103'#----------------------FN_DYNVARS_072_06------------------------#' 104SELECT @@global.max_binlog_stmt_cache_size = VARIABLE_VALUE 105FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 106WHERE VARIABLE_NAME='max_binlog_stmt_cache_size'; 107@@global.max_binlog_stmt_cache_size = VARIABLE_VALUE 1081 109SELECT @@max_binlog_stmt_cache_size = VARIABLE_VALUE 110FROM INFORMATION_SCHEMA.SESSION_VARIABLES 111WHERE VARIABLE_NAME='max_binlog_stmt_cache_size'; 112@@max_binlog_stmt_cache_size = VARIABLE_VALUE 1131 114'#---------------------FN_DYNVARS_072_07----------------------#' 115SET @@global.max_binlog_stmt_cache_size = TRUE; 116Warnings: 117Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '1' 118SELECT @@global.max_binlog_stmt_cache_size; 119@@global.max_binlog_stmt_cache_size 1204096 121SET @@global.max_binlog_stmt_cache_size = FALSE; 122Warnings: 123Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '0' 124SELECT @@global.max_binlog_stmt_cache_size; 125@@global.max_binlog_stmt_cache_size 1264096 127'#---------------------FN_DYNVARS_072_08----------------------#' 128SET @@global.max_binlog_stmt_cache_size = 5000; 129Warnings: 130Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '5000' 131SELECT @@max_binlog_stmt_cache_size = @@global.max_binlog_stmt_cache_size; 132@@max_binlog_stmt_cache_size = @@global.max_binlog_stmt_cache_size 1331 134'#---------------------FN_DYNVARS_072_09----------------------#' 135SET max_binlog_stmt_cache_size = 6000; 136ERROR HY000: Variable 'max_binlog_stmt_cache_size' is a GLOBAL variable and should be set with SET GLOBAL 137SELECT @@max_binlog_stmt_cache_size; 138@@max_binlog_stmt_cache_size 1394096 140SELECT local.max_binlog_stmt_cache_size; 141ERROR 42S02: Unknown table 'local' in field list 142SELECT global.max_binlog_stmt_cache_size; 143ERROR 42S02: Unknown table 'global' in field list 144SELECT max_binlog_stmt_cache_size = @@session.max_binlog_stmt_cache_size; 145ERROR 42S22: Unknown column 'max_binlog_stmt_cache_size' in 'field list' 146SET @@global.max_binlog_stmt_cache_size = @start_value; 147SELECT @@global.max_binlog_stmt_cache_size; 148@@global.max_binlog_stmt_cache_size 149max_binlog_stmt_cache_size 150