1 2--echo # 3--echo # MDEV-4774: Strangeness with max_binlog_stmt_cache_size Settings 4--echo # 5 6CALL mtr.add_suppression("unsigned value 18446744073709547520 adjusted to 4294963200"); 7 8--replace_result 18446744073709547520 MAX_BINLOG_STMT_CACHE_SIZE 4294963200 MAX_BINLOG_STMT_CACHE_SIZE 9SELECT @@global.max_binlog_stmt_cache_size; 10 11# Save the initial value of @@global.max_binlog_stmt_cache_size. 12--replace_result 18446744073709547520 MAX_BINLOG_STMT_CACHE_SIZE 4294963200 MAX_BINLOG_STMT_CACHE_SIZE 13SET @cache_size= @@max_binlog_stmt_cache_size; 14 15--disable_warnings 16SET @@global.max_binlog_stmt_cache_size= @cache_size+1; 17--enable_warnings 18--replace_result 18446744073709547520 MAX_BINLOG_STMT_CACHE_SIZE 4294963200 MAX_BINLOG_STMT_CACHE_SIZE 19SELECT @@global.max_binlog_stmt_cache_size; 20 21--disable_warnings 22SET @@global.max_binlog_stmt_cache_size = @cache_size+4095; 23--enable_warnings 24--replace_result 4294963200 MAX_BINLOG_STMT_CACHE_SIZE 18446744073709547520 MAX_BINLOG_STMT_CACHE_SIZE 25SELECT @@global.max_binlog_stmt_cache_size; 26 27--disable_warnings 28SET @@global.max_binlog_stmt_cache_size= @cache_size-1; 29--enable_warnings 30SELECT @@global.max_binlog_stmt_cache_size = @cache_size-4096; 31 32# Restore @@global.max_binlog_stmt_cache_size to its initial value. 33SET @@global.max_binlog_stmt_cache_size= @cache_size; 34 35--echo # End of test 36 37