Debian Codegraph @

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

raw
1 # ulong global
2
3 --source include/have_debug.inc
4
5 SET @start_global_value = @@global.debug_binlog_fsync_sleep;
6
7 #
8 # exists as global only
9 #
10 select @@global.debug_binlog_fsync_sleep;
11 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
12 select @@session.debug_binlog_fsync_sleep;
13 show global variables like 'debug_binlog_fsync_sleep';
14 show session variables like 'debug_binlog_fsync_sleep';
15 select * from information_schema.global_variables where variable_name='debug_binlog_fsync_sleep';
16 select * from information_schema.session_variables where variable_name='debug_binlog_fsync_sleep';
17
18 #
19 # show that it's writable
20 #
21 set global debug_binlog_fsync_sleep=20;
22 select @@global.debug_binlog_fsync_sleep;
23 --error ER_GLOBAL_VARIABLE
24 set session debug_binlog_fsync_sleep=1;
25
26 #
27 # incorrect types
28 #
29 --error ER_WRONG_TYPE_FOR_VAR
30 set global debug_binlog_fsync_sleep=1.1;
31 --error ER_WRONG_TYPE_FOR_VAR
32 set global debug_binlog_fsync_sleep=1e1;
33 --error ER_WRONG_TYPE_FOR_VAR
34 set global debug_binlog_fsync_sleep="foo";
35
36 #
37 # min/max values, block size
38 #
39 set global debug_binlog_fsync_sleep=0;
40 select @@global.debug_binlog_fsync_sleep;
41 set global debug_binlog_fsync_sleep=cast(-1 as unsigned int);
42 select @@global.debug_binlog_fsync_sleep;
43
44 SET @@global.debug_binlog_fsync_sleep = @start_global_value;