Debian Codegraph @

mysql-test/suite/sys_vars/r/debug_binlog_fsync_sleep_basic.result

raw
1 SET @start_global_value = @@global.debug_binlog_fsync_sleep;
2 select @@global.debug_binlog_fsync_sleep;
3 @@global.debug_binlog_fsync_sleep
4 0
5 select @@session.debug_binlog_fsync_sleep;
6 ERROR HY000: Variable 'debug_binlog_fsync_sleep' is a GLOBAL variable
7 show global variables like 'debug_binlog_fsync_sleep';
8 Variable_name Value
9 debug_binlog_fsync_sleep 0
10 show session variables like 'debug_binlog_fsync_sleep';
11 Variable_name Value
12 debug_binlog_fsync_sleep 0
13 select * from information_schema.global_variables where variable_name='debug_binlog_fsync_sleep';
14 VARIABLE_NAME VARIABLE_VALUE
15 DEBUG_BINLOG_FSYNC_SLEEP 0
16 select * from information_schema.session_variables where variable_name='debug_binlog_fsync_sleep';
17 VARIABLE_NAME VARIABLE_VALUE
18 DEBUG_BINLOG_FSYNC_SLEEP 0
19 set global debug_binlog_fsync_sleep=20;
20 select @@global.debug_binlog_fsync_sleep;
21 @@global.debug_binlog_fsync_sleep
22 20
23 set session debug_binlog_fsync_sleep=1;
24 ERROR HY000: Variable 'debug_binlog_fsync_sleep' is a GLOBAL variable and should be set with SET GLOBAL
25 set global debug_binlog_fsync_sleep=1.1;
26 ERROR 42000: Incorrect argument type to variable 'debug_binlog_fsync_sleep'
27 set global debug_binlog_fsync_sleep=1e1;
28 ERROR 42000: Incorrect argument type to variable 'debug_binlog_fsync_sleep'
29 set global debug_binlog_fsync_sleep="foo";
30 ERROR 42000: Incorrect argument type to variable 'debug_binlog_fsync_sleep'
31 set global debug_binlog_fsync_sleep=0;
32 select @@global.debug_binlog_fsync_sleep;
33 @@global.debug_binlog_fsync_sleep
34 0
35 set global debug_binlog_fsync_sleep=cast(-1 as unsigned int);
36 Warnings:
37 Note 1105 Cast to unsigned converted negative integer to it's positive complement
38 Warning 1292 Truncated incorrect debug_binlog_fsync_sleep value: '18446744073709551615'
39 select @@global.debug_binlog_fsync_sleep;
40 @@global.debug_binlog_fsync_sleep
41 4294967295
42 SET @@global.debug_binlog_fsync_sleep = @start_global_value;