Debian Codegraph @

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

raw
1 ###############################################################################
2 # WL#7742 : testing the new variable binlog_group_commit_sync_delay #
3 ###############################################################################
4
5 --let $min_allowed=0
6 --let $max_allowed=1000000
7 --let $valid_val=`SELECT CAST(RAND() * $max_allowed AS SIGNED INTEGER)`
8
9 --let $min_invalid=`SELECT $min_allowed - 1`
10 --let $max_invalid=`SELECT $max_allowed + 1`
11
12 --echo # Default values
13 SELECT @@GLOBAL.binlog_group_commit_sync_delay;
14 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
15 SELECT @@SESSION.binlog_group_commit_sync_delay;
16
17 --disable_query_log
18 SET @saved_value = @@global.binlog_group_commit_sync_delay;
19
20 --echo # Valid values
21 --eval SET GLOBAL binlog_group_commit_sync_delay = $min_allowed
22 --eval SET GLOBAL binlog_group_commit_sync_delay = $valid_val
23 --eval SET GLOBAL binlog_group_commit_sync_delay = $max_allowed
24
25 --echo # Invalid values: there shall be warnings about truncation
26 --eval SET GLOBAL binlog_group_commit_sync_delay = $min_invalid
27 --let $val=`SELECT @@GLOBAL.binlog_group_commit_sync_delay`
28 --let $assert_text="Assert that binlog_group_commit_sync_delay was truncated to MIN allowed value"
29 --let $assert_cond= $val=$min_allowed
30 --source include/assert.inc
31
32 --eval SET GLOBAL binlog_group_commit_sync_delay = $max_invalid
33 --let $val=`SELECT @@GLOBAL.binlog_group_commit_sync_delay`
34 --let $assert_text="Assert that binlog_group_commit_sync_delay was truncated to MAX allowed value"
35 --let $assert_cond= $val=$max_allowed
36 --source include/assert.inc
37
38 SET GLOBAL binlog_group_commit_sync_delay = @saved_value;
39 --enable_query_log