Debian Codegraph @

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

raw
1 SET @start_value = @@global.sync_binlog;
2 '#--------------------FN_DYNVARS_168_03------------------------#'
3 SET @@global.sync_binlog = 0;
4 SELECT @@global.sync_binlog;
5 @@global.sync_binlog
6 0
7 SET @@global.sync_binlog = 1;
8 SELECT @@global.sync_binlog;
9 @@global.sync_binlog
10 1
11 SET @@global.sync_binlog = 4294967295;
12 SELECT @@global.sync_binlog;
13 @@global.sync_binlog
14 4294967295
15 SET @@global.sync_binlog = 4294967294;
16 SELECT @@global.sync_binlog;
17 @@global.sync_binlog
18 4294967294
19 SET @@global.sync_binlog = 65536;
20 SELECT @@global.sync_binlog;
21 @@global.sync_binlog
22 65536
23 '#--------------------FN_DYNVARS_168_04-------------------------#'
24 SET @@global.sync_binlog = -1;
25 Warnings:
26 Warning 1292 Truncated incorrect sync_binlog value: '-1'
27 SELECT @@global.sync_binlog;
28 @@global.sync_binlog
29 0
30 SET @@global.sync_binlog = 4294967296;
31 Warnings:
32 Warning 1292 Truncated incorrect sync_binlog value: '4294967296'
33 SELECT @@global.sync_binlog;
34 @@global.sync_binlog
35 4294967295
36 SET @@global.sync_binlog = 10240022115;
37 Warnings:
38 Warning 1292 Truncated incorrect sync_binlog value: '10240022115'
39 SELECT @@global.sync_binlog;
40 @@global.sync_binlog
41 4294967295
42 SET @@global.sync_binlog = 10000.01;
43 ERROR 42000: Incorrect argument type to variable 'sync_binlog'
44 SELECT @@global.sync_binlog;
45 @@global.sync_binlog
46 4294967295
47 SET @@global.sync_binlog = -1024;
48 Warnings:
49 Warning 1292 Truncated incorrect sync_binlog value: '-1024'
50 SELECT @@global.sync_binlog;
51 @@global.sync_binlog
52 0
53 SET @@global.sync_binlog = 42949672950;
54 Warnings:
55 Warning 1292 Truncated incorrect sync_binlog value: '42949672950'
56 SELECT @@global.sync_binlog;
57 @@global.sync_binlog
58 4294967295
59 SET @@global.sync_binlog = ON;
60 ERROR 42000: Incorrect argument type to variable 'sync_binlog'
61 SELECT @@global.sync_binlog;
62 @@global.sync_binlog
63 4294967295
64 SET @@global.sync_binlog = 'test';
65 ERROR 42000: Incorrect argument type to variable 'sync_binlog'
66 SELECT @@global.sync_binlog;
67 @@global.sync_binlog
68 4294967295
69 '#-------------------FN_DYNVARS_168_05----------------------------#'
70 SET @@session.sync_binlog = 0;
71 ERROR HY000: Variable 'sync_binlog' is a GLOBAL variable and should be set with SET GLOBAL
72 SELECT @@sync_binlog;
73 @@sync_binlog
74 4294967295
75 '#----------------------FN_DYNVARS_168_06------------------------#'
76 SELECT @@global.sync_binlog = VARIABLE_VALUE
77 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
78 WHERE VARIABLE_NAME='sync_binlog';
79 @@global.sync_binlog = VARIABLE_VALUE
80 1
81 '#---------------------FN_DYNVARS_168_07----------------------#'
82 SET sync_binlog = 1;
83 ERROR HY000: Variable 'sync_binlog' is a GLOBAL variable and should be set with SET GLOBAL
84 SELECT @@sync_binlog;
85 @@sync_binlog
86 4294967295
87 SELECT local.sync_binlog;
88 ERROR 42S02: Unknown table 'local' in SELECT
89 SELECT global.sync_binlog;
90 ERROR 42S02: Unknown table 'global' in SELECT
91 SELECT sync_binlog = @@session.sync_binlog;
92 ERROR 42S22: Unknown column 'sync_binlog' in 'SELECT'
93 SET @@global.sync_binlog = @start_value;