1SET @start_value = @@global.binlog_stmt_cache_size; 2set @@global.binlog_stmt_cache_size=default; 3SELECT @@global.binlog_stmt_cache_size; 4@@global.binlog_stmt_cache_size 532768 6'#--------------------FN_DYNVARS_006_01------------------------#' 7SET @@global.binlog_stmt_cache_size = 100; 8Warnings: 9Warning 1292 Truncated incorrect binlog_stmt_cache_size value: '100' 10SET @@global.binlog_stmt_cache_size = DEFAULT; 11SELECT @@global.binlog_stmt_cache_size; 12@@global.binlog_stmt_cache_size 1332768 14'#---------------------FN_DYNVARS_006_02-------------------------#' 15SET @@global.binlog_stmt_cache_size = default; 16SELECT @@global.binlog_stmt_cache_size = 32768; 17@@global.binlog_stmt_cache_size = 32768 181 19'#--------------------FN_DYNVARS_006_03------------------------#' 20SET @@global.binlog_stmt_cache_size = 4096; 21SELECT @@global.binlog_stmt_cache_size; 22@@global.binlog_stmt_cache_size 234096 24SET @@global.binlog_stmt_cache_size = 4294967295; 25Warnings: 26Warning 1292 Truncated incorrect binlog_stmt_cache_size value: '4294967295' 27SELECT @@global.binlog_stmt_cache_size; 28@@global.binlog_stmt_cache_size 294294963200 30SET @@global.binlog_stmt_cache_size = 10000; 31Warnings: 32Warning 1292 Truncated incorrect binlog_stmt_cache_size value: '10000' 33SELECT @@global.binlog_stmt_cache_size; 34@@global.binlog_stmt_cache_size 358192 36SET @@global.binlog_stmt_cache_size = 21221204; 37Warnings: 38Warning 1292 Truncated incorrect binlog_stmt_cache_size value: '21221204' 39SELECT @@global.binlog_stmt_cache_size; 40@@global.binlog_stmt_cache_size 4121217280 42'Bug: Invalid values are coming in variable on assigning valid values' 43'#--------------------FN_DYNVARS_006_04-------------------------#' 44SET @@global.binlog_stmt_cache_size = 1024; 45Warnings: 46Warning 1292 Truncated incorrect binlog_stmt_cache_size value: '1024' 47SELECT @@global.binlog_stmt_cache_size; 48@@global.binlog_stmt_cache_size 494096 50SET @@global.binlog_stmt_cache_size = 10000.01; 51ERROR 42000: Incorrect argument type to variable 'binlog_stmt_cache_size' 52SET @@global.binlog_stmt_cache_size = -1024; 53Warnings: 54Warning 1292 Truncated incorrect binlog_stmt_cache_size value: '-1024' 55SELECT @@global.binlog_stmt_cache_size; 56@@global.binlog_stmt_cache_size 574096 58SET @@global.binlog_stmt_cache_size = 42949672950; 59Warnings: 60Warning 1292 Truncated incorrect binlog_stmt_cache_size value: '42949672950' 61SELECT @@global.binlog_stmt_cache_size; 62@@global.binlog_stmt_cache_size 63max_binlog_cache_size 64'Bug: Errors are not coming on assigning invalid values to variable' 65SET @@global.binlog_stmt_cache_size = ON; 66ERROR 42000: Incorrect argument type to variable 'binlog_stmt_cache_size' 67SET @@global.binlog_stmt_cache_size = 'test'; 68ERROR 42000: Incorrect argument type to variable 'binlog_stmt_cache_size' 69'#-------------------FN_DYNVARS_006_05----------------------------#' 70SET @@session.binlog_stmt_cache_size = 0; 71ERROR HY000: Variable 'binlog_stmt_cache_size' is a GLOBAL variable and should be set with SET GLOBAL 72'#----------------------FN_DYNVARS_006_06------------------------#' 73SELECT @@global.binlog_stmt_cache_size = VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='binlog_stmt_cache_size'; 74@@global.binlog_stmt_cache_size = VARIABLE_VALUE 751 76'#---------------------FN_DYNVARS_006_07----------------------#' 77SET @@global.binlog_stmt_cache_size = TRUE; 78Warnings: 79Warning 1292 Truncated incorrect binlog_stmt_cache_size value: '1' 80SELECT @@global.binlog_stmt_cache_size; 81@@global.binlog_stmt_cache_size 824096 83SET @@global.binlog_stmt_cache_size = FALSE; 84Warnings: 85Warning 1292 Truncated incorrect binlog_stmt_cache_size value: '0' 86SELECT @@global.binlog_stmt_cache_size; 87@@global.binlog_stmt_cache_size 884096 89'Bug: Errors are not coming on assigning TRUE/FALSE to variable' 90'#---------------------FN_DYNVARS_006_08----------------------#' 91SET @@global.binlog_stmt_cache_size = 1; 92Warnings: 93Warning 1292 Truncated incorrect binlog_stmt_cache_size value: '1' 94SELECT @@binlog_stmt_cache_size = @@global.binlog_stmt_cache_size; 95@@binlog_stmt_cache_size = @@global.binlog_stmt_cache_size 961 97'#---------------------FN_DYNVARS_006_09----------------------#' 98SET binlog_stmt_cache_size = 1; 99ERROR HY000: Variable 'binlog_stmt_cache_size' is a GLOBAL variable and should be set with SET GLOBAL 100SELECT global.binlog_stmt_cache_size; 101ERROR 42S02: Unknown table 'global' in field list 102SELECT binlog_stmt_cache_size = @@session.binlog_stmt_cache_size; 103ERROR 42S22: Unknown column 'binlog_stmt_cache_size' in 'field list' 104SET @@global.binlog_stmt_cache_size = @start_value; 105