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