1#
2# MDEV-4774: Strangeness with max_binlog_stmt_cache_size Settings
3#
4CALL mtr.add_suppression("unsigned value 18446744073709547520 adjusted to 4294963200");
5SELECT @@global.max_binlog_stmt_cache_size;
6@@global.max_binlog_stmt_cache_size
7MAX_BINLOG_STMT_CACHE_SIZE
8SET @cache_size= @@max_binlog_stmt_cache_size;
9SET @@global.max_binlog_stmt_cache_size= @cache_size+1;
10SELECT @@global.max_binlog_stmt_cache_size;
11@@global.max_binlog_stmt_cache_size
12MAX_BINLOG_STMT_CACHE_SIZE
13SET @@global.max_binlog_stmt_cache_size = @cache_size+4095;
14SELECT @@global.max_binlog_stmt_cache_size;
15@@global.max_binlog_stmt_cache_size
16MAX_BINLOG_STMT_CACHE_SIZE
17SET @@global.max_binlog_stmt_cache_size= @cache_size-1;
18SELECT @@global.max_binlog_stmt_cache_size = @cache_size-4096;
19@@global.max_binlog_stmt_cache_size = @cache_size-4096
201
21SET @@global.max_binlog_stmt_cache_size= @cache_size;
22# End of test
23