1SET @start_value = @@global.binlog_stmt_cache_size; 2SELECT @start_value; 3@start_value 432768 5'#--------------------FN_DYNVARS_006_01------------------------#' 6SET @@global.binlog_stmt_cache_size = 100; 7Warnings: 8Warning 1292 Truncated incorrect binlog_stmt_cache_size value: '100' 9SET @@global.binlog_stmt_cache_size = DEFAULT; 10SELECT @@global.binlog_stmt_cache_size; 11@@global.binlog_stmt_cache_size 1232768 13'#---------------------FN_DYNVARS_006_02-------------------------#' 14SET @@global.binlog_stmt_cache_size = @start_value; 15SELECT @@global.binlog_stmt_cache_size = 32768; 16@@global.binlog_stmt_cache_size = 32768 171 18'#--------------------FN_DYNVARS_006_03------------------------#' 19SET @@global.binlog_stmt_cache_size = 4096; 20SELECT @@global.binlog_stmt_cache_size; 21@@global.binlog_stmt_cache_size 224096 23SET @@global.binlog_stmt_cache_size = 4294967295; 24Warnings: 25Warning 1292 Truncated incorrect binlog_stmt_cache_size value: '4294967295' 26SELECT @@global.binlog_stmt_cache_size; 27@@global.binlog_stmt_cache_size 284294963200 29SET @@global.binlog_stmt_cache_size = 10000; 30Warnings: 31Warning 1292 Truncated incorrect binlog_stmt_cache_size value: '10000' 32SELECT @@global.binlog_stmt_cache_size; 33@@global.binlog_stmt_cache_size 348192 35SET @@global.binlog_stmt_cache_size = 21221204; 36Warnings: 37Warning 1292 Truncated incorrect binlog_stmt_cache_size value: '21221204' 38SELECT @@global.binlog_stmt_cache_size; 39@@global.binlog_stmt_cache_size 4021217280 41'Bug: Invalid values are coming in variable on assigning valid values' 42'#--------------------FN_DYNVARS_006_04-------------------------#' 43SET @@global.binlog_stmt_cache_size = 1024; 44Warnings: 45Warning 1292 Truncated incorrect binlog_stmt_cache_size value: '1024' 46SELECT @@global.binlog_stmt_cache_size; 47@@global.binlog_stmt_cache_size 484096 49SET @@global.binlog_stmt_cache_size = 10000.01; 50ERROR 42000: Incorrect argument type to variable 'binlog_stmt_cache_size' 51SET @@global.binlog_stmt_cache_size = -1024; 52Warnings: 53Warning 1292 Truncated incorrect binlog_stmt_cache_size value: '-1024' 54SELECT @@global.binlog_stmt_cache_size; 55@@global.binlog_stmt_cache_size 564096 57SET @@global.binlog_stmt_cache_size = 42949672950; 58Warnings: 59Warning 1292 Truncated incorrect binlog_stmt_cache_size value: '42949672950' 60SELECT @@global.binlog_stmt_cache_size; 61@@global.binlog_stmt_cache_size 6242949668864 63'Bug: Errors are not coming on assigning invalid values to variable' 64SET @@global.binlog_stmt_cache_size = ON; 65ERROR 42000: Incorrect argument type to variable 'binlog_stmt_cache_size' 66SET @@global.binlog_stmt_cache_size = 'test'; 67ERROR 42000: Incorrect argument type to variable 'binlog_stmt_cache_size' 68'#-------------------FN_DYNVARS_006_05----------------------------#' 69SET @@session.binlog_stmt_cache_size = 0; 70ERROR HY000: Variable 'binlog_stmt_cache_size' is a GLOBAL variable and should be set with SET GLOBAL 71'#----------------------FN_DYNVARS_006_06------------------------#' 72SELECT @@global.binlog_stmt_cache_size = VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='binlog_stmt_cache_size'; 73@@global.binlog_stmt_cache_size = VARIABLE_VALUE 741 75'#---------------------FN_DYNVARS_006_07----------------------#' 76SET @@global.binlog_stmt_cache_size = TRUE; 77Warnings: 78Warning 1292 Truncated incorrect binlog_stmt_cache_size value: '1' 79SELECT @@global.binlog_stmt_cache_size; 80@@global.binlog_stmt_cache_size 814096 82SET @@global.binlog_stmt_cache_size = FALSE; 83Warnings: 84Warning 1292 Truncated incorrect binlog_stmt_cache_size value: '0' 85SELECT @@global.binlog_stmt_cache_size; 86@@global.binlog_stmt_cache_size 874096 88'Bug: Errors are not coming on assigning TRUE/FALSE to variable' 89'#---------------------FN_DYNVARS_006_08----------------------#' 90SET @@global.binlog_stmt_cache_size = 1; 91Warnings: 92Warning 1292 Truncated incorrect binlog_stmt_cache_size value: '1' 93SELECT @@binlog_stmt_cache_size = @@global.binlog_stmt_cache_size; 94@@binlog_stmt_cache_size = @@global.binlog_stmt_cache_size 951 96'#---------------------FN_DYNVARS_006_09----------------------#' 97SET binlog_stmt_cache_size = 1; 98ERROR HY000: Variable 'binlog_stmt_cache_size' is a GLOBAL variable and should be set with SET GLOBAL 99SET global.binlog_stmt_cache_size = 1; 100ERROR 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 'binlog_stmt_cache_size = 1' at line 1 101SELECT global.binlog_stmt_cache_size; 102ERROR 42S02: Unknown table 'global' in field list 103SELECT binlog_stmt_cache_size = @@session.binlog_stmt_cache_size; 104ERROR 42S22: Unknown column 'binlog_stmt_cache_size' in 'field list' 105SET @@global.binlog_stmt_cache_size = @start_value; 106SELECT @@global.binlog_stmt_cache_size; 107@@global.binlog_stmt_cache_size 10832768 109