Debian Codegraph @

mysql-test/suite/sys_vars/t/binlog_max_flush_queue_time_basic.test

raw
1 ###############################################################################
2 # #
3 # File containing assorted tests for binary log variables. #
4 # #
5 ###############################################################################
6
7 --echo # Default values
8 SELECT @@GLOBAL.binlog_max_flush_queue_time;
9 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
10 SELECT @@SESSION.binlog_max_flush_queue_time;
11
12 SET @saved_value = @@global.binlog_max_flush_queue_time;
13
14 --echo # Valid values
15 SET GLOBAL binlog_max_flush_queue_time = 0;
16 SET GLOBAL binlog_max_flush_queue_time = 1;
17 SET GLOBAL binlog_max_flush_queue_time = 10000;
18 SET GLOBAL binlog_max_flush_queue_time = 100000;
19
20 --echo # Invalid values: there shall be warnings about truncation
21 SET GLOBAL binlog_max_flush_queue_time = -1;
22 SET GLOBAL binlog_max_flush_queue_time = -1024;
23 SET GLOBAL binlog_max_flush_queue_time = 100001;
24 SET GLOBAL binlog_max_flush_queue_time = 200000;
25
26 SET GLOBAL binlog_max_flush_queue_time = @saved_value;
27