1SET @start_max_binlog_stmt_cache_size = @@global.max_binlog_stmt_cache_size; 2SELECT @start_max_binlog_stmt_cache_size; 3@start_max_binlog_stmt_cache_size 418446744073709547520 5SET @start_binlog_stmt_cache_size = @@global.binlog_stmt_cache_size; 6SELECT @start_binlog_stmt_cache_size; 7@start_binlog_stmt_cache_size 832768 9'#--------------------FN_DYNVARS_072_01------------------------#' 10SET @@global.max_binlog_stmt_cache_size = 5000; 11Warnings: 12Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '5000' 13Warning 1745 Option binlog_stmt_cache_size (32768) is greater than max_binlog_stmt_cache_size (4096); setting binlog_stmt_cache_size equal to max_binlog_stmt_cache_size. 14SET @@global.max_binlog_stmt_cache_size = DEFAULT; 15SELECT @@global.max_binlog_stmt_cache_size; 16@@global.max_binlog_stmt_cache_size 1718446744073709547520 18'#---------------------FN_DYNVARS_072_02-------------------------#' 19SET @@global.max_binlog_stmt_cache_size = @start_max_binlog_stmt_cache_size; 20SELECT @@global.max_binlog_stmt_cache_size = 4294967295; 21@@global.max_binlog_stmt_cache_size = 4294967295 220 23'#--------------------FN_DYNVARS_072_03------------------------#' 24SET @@global.max_binlog_stmt_cache_size = 4096; 25SELECT @@global.max_binlog_stmt_cache_size; 26@@global.max_binlog_stmt_cache_size 274096 28SET @@global.max_binlog_stmt_cache_size = 4294967295; 29Warnings: 30Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '4294967295' 31SELECT @@global.max_binlog_stmt_cache_size; 32@@global.max_binlog_stmt_cache_size 334294963200 34SET @@global.max_binlog_stmt_cache_size = 4294967294; 35Warnings: 36Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '4294967294' 37SELECT @@global.max_binlog_stmt_cache_size; 38@@global.max_binlog_stmt_cache_size 394294963200 40SET @@global.max_binlog_stmt_cache_size = 4097; 41Warnings: 42Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '4097' 43SELECT @@global.max_binlog_stmt_cache_size; 44@@global.max_binlog_stmt_cache_size 454096 46SET @@global.max_binlog_stmt_cache_size = 65535; 47Warnings: 48Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '65535' 49SELECT @@global.max_binlog_stmt_cache_size; 50@@global.max_binlog_stmt_cache_size 5161440 52'#--------------------FN_DYNVARS_072_04-------------------------#' 53SET @@global.max_binlog_stmt_cache_size = -1; 54Warnings: 55Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '-1' 56SELECT @@global.max_binlog_stmt_cache_size; 57@@global.max_binlog_stmt_cache_size 584096 59SET @@global.max_binlog_stmt_cache_size = 100000000000; 60Warnings: 61Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '100000000000' 62SELECT @@global.max_binlog_stmt_cache_size; 63@@global.max_binlog_stmt_cache_size 6499999997952 65SET @@global.max_binlog_stmt_cache_size = 10000.01; 66ERROR 42000: Incorrect argument type to variable 'max_binlog_stmt_cache_size' 67SELECT @@global.max_binlog_stmt_cache_size; 68@@global.max_binlog_stmt_cache_size 6999999997952 70SET @@global.max_binlog_stmt_cache_size = -1024; 71Warnings: 72Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '-1024' 73SELECT @@global.max_binlog_stmt_cache_size; 74@@global.max_binlog_stmt_cache_size 754096 76SET @@global.max_binlog_stmt_cache_size = 1024; 77Warnings: 78Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '1024' 79SELECT @@global.max_binlog_stmt_cache_size; 80@@global.max_binlog_stmt_cache_size 814096 82SET @@global.max_binlog_stmt_cache_size = 4294967296; 83SELECT @@global.max_binlog_stmt_cache_size; 84@@global.max_binlog_stmt_cache_size 854294967296 86SET @@global.max_binlog_stmt_cache_size = 4095; 87Warnings: 88Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '4095' 89SELECT @@global.max_binlog_stmt_cache_size; 90@@global.max_binlog_stmt_cache_size 914096 92SET @@global.max_binlog_stmt_cache_size = ON; 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 97SET @@global.max_binlog_stmt_cache_size = 'test'; 98ERROR 42000: Incorrect argument type to variable 'max_binlog_stmt_cache_size' 99SELECT @@global.max_binlog_stmt_cache_size; 100@@global.max_binlog_stmt_cache_size 1014096 102'#-------------------FN_DYNVARS_072_05----------------------------#' 103SET @@session.max_binlog_stmt_cache_size = 4096; 104ERROR HY000: Variable 'max_binlog_stmt_cache_size' is a GLOBAL variable and should be set with SET GLOBAL 105SELECT @@session.max_binlog_stmt_cache_size; 106ERROR HY000: Variable 'max_binlog_stmt_cache_size' is a GLOBAL variable 107'#----------------------FN_DYNVARS_072_06------------------------#' 108SELECT @@global.max_binlog_stmt_cache_size = VARIABLE_VALUE 109FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 110WHERE VARIABLE_NAME='max_binlog_stmt_cache_size'; 111@@global.max_binlog_stmt_cache_size = VARIABLE_VALUE 1121 113SELECT @@max_binlog_stmt_cache_size = VARIABLE_VALUE 114FROM INFORMATION_SCHEMA.SESSION_VARIABLES 115WHERE VARIABLE_NAME='max_binlog_stmt_cache_size'; 116@@max_binlog_stmt_cache_size = VARIABLE_VALUE 1171 118'#---------------------FN_DYNVARS_072_07----------------------#' 119SET @@global.max_binlog_stmt_cache_size = TRUE; 120Warnings: 121Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '1' 122SELECT @@global.max_binlog_stmt_cache_size; 123@@global.max_binlog_stmt_cache_size 1244096 125SET @@global.max_binlog_stmt_cache_size = FALSE; 126Warnings: 127Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '0' 128SELECT @@global.max_binlog_stmt_cache_size; 129@@global.max_binlog_stmt_cache_size 1304096 131'#---------------------FN_DYNVARS_072_08----------------------#' 132SET @@global.max_binlog_stmt_cache_size = 5000; 133Warnings: 134Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '5000' 135SELECT @@max_binlog_stmt_cache_size = @@global.max_binlog_stmt_cache_size; 136@@max_binlog_stmt_cache_size = @@global.max_binlog_stmt_cache_size 1371 138'#---------------------FN_DYNVARS_072_09----------------------#' 139SET max_binlog_stmt_cache_size = 6000; 140ERROR HY000: Variable 'max_binlog_stmt_cache_size' is a GLOBAL variable and should be set with SET GLOBAL 141SELECT @@max_binlog_stmt_cache_size; 142@@max_binlog_stmt_cache_size 1434096 144SET local.max_binlog_stmt_cache_size = 7000; 145ERROR 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_binlog_stmt_cache_size = 7000' at line 1 146SELECT local.max_binlog_stmt_cache_size; 147ERROR 42S02: Unknown table 'local' in field list 148SET global.max_binlog_stmt_cache_size = 8000; 149ERROR 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_binlog_stmt_cache_size = 8000' at line 1 150SELECT global.max_binlog_stmt_cache_size; 151ERROR 42S02: Unknown table 'global' in field list 152SELECT max_binlog_stmt_cache_size = @@session.max_binlog_stmt_cache_size; 153ERROR 42S22: Unknown column 'max_binlog_stmt_cache_size' in 'field list' 154SET @@global.max_binlog_stmt_cache_size = @start_max_binlog_stmt_cache_size; 155SELECT @@global.max_binlog_stmt_cache_size; 156@@global.max_binlog_stmt_cache_size 15718446744073709547520 158SET @@global.binlog_stmt_cache_size= @start_binlog_stmt_cache_size; 159SELECT @@global.binlog_stmt_cache_size; 160@@global.binlog_stmt_cache_size 16132768 162