Debian Codegraph @

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

raw
1 # Default values
2 SELECT @@GLOBAL.binlog_max_flush_queue_time;
3 @@GLOBAL.binlog_max_flush_queue_time
4 0
5 Warnings:
6 Warning 1287 '@@binlog_max_flush_queue_time' is deprecated and will be removed in a future release.
7 SELECT @@SESSION.binlog_max_flush_queue_time;
8 ERROR HY000: Variable 'binlog_max_flush_queue_time' is a GLOBAL variable
9 SET @saved_value = @@global.binlog_max_flush_queue_time;
10 Warnings:
11 Warning 1287 '@@binlog_max_flush_queue_time' is deprecated and will be removed in a future release.
12 # Valid values
13 SET GLOBAL binlog_max_flush_queue_time = 0;
14 Warnings:
15 Warning 1287 '@@binlog_max_flush_queue_time' is deprecated and will be removed in a future release.
16 SET GLOBAL binlog_max_flush_queue_time = 1;
17 Warnings:
18 Warning 1287 '@@binlog_max_flush_queue_time' is deprecated and will be removed in a future release.
19 SET GLOBAL binlog_max_flush_queue_time = 10000;
20 Warnings:
21 Warning 1287 '@@binlog_max_flush_queue_time' is deprecated and will be removed in a future release.
22 SET GLOBAL binlog_max_flush_queue_time = 100000;
23 Warnings:
24 Warning 1287 '@@binlog_max_flush_queue_time' is deprecated and will be removed in a future release.
25 # Invalid values: there shall be warnings about truncation
26 SET GLOBAL binlog_max_flush_queue_time = -1;
27 Warnings:
28 Warning 1287 '@@binlog_max_flush_queue_time' is deprecated and will be removed in a future release.
29 Warning 1292 Truncated incorrect binlog_max_flush_queue_time value: '-1'
30 SET GLOBAL binlog_max_flush_queue_time = -1024;
31 Warnings:
32 Warning 1287 '@@binlog_max_flush_queue_time' is deprecated and will be removed in a future release.
33 Warning 1292 Truncated incorrect binlog_max_flush_queue_time value: '-1024'
34 SET GLOBAL binlog_max_flush_queue_time = 100001;
35 Warnings:
36 Warning 1287 '@@binlog_max_flush_queue_time' is deprecated and will be removed in a future release.
37 Warning 1292 Truncated incorrect binlog_max_flush_queue_time value: '100001'
38 SET GLOBAL binlog_max_flush_queue_time = 200000;
39 Warnings:
40 Warning 1287 '@@binlog_max_flush_queue_time' is deprecated and will be removed in a future release.
41 Warning 1292 Truncated incorrect binlog_max_flush_queue_time value: '200000'
42 SET GLOBAL binlog_max_flush_queue_time = @saved_value;
43 Warnings:
44 Warning 1287 '@@binlog_max_flush_queue_time' is deprecated and will be removed in a future release.