Debian Codegraph @

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

raw
1 SET @start_value = @@global.sync_binlog;
2 SELECT @start_value;
3 @start_value
4 1
5 '#--------------------FN_DYNVARS_168_01------------------------#'
6 SET @@global.sync_binlog = 99;
7 SET @@global.sync_binlog = DEFAULT;
8 SELECT @@global.sync_binlog;
9 @@global.sync_binlog
10 1
11 '#---------------------FN_DYNVARS_168_02-------------------------#'
12 SET @@global.sync_binlog = @start_value;
13 SELECT @@global.sync_binlog = 1;
14 @@global.sync_binlog = 1
15 1
16 '#--------------------FN_DYNVARS_168_03------------------------#'
17 SET @@global.sync_binlog = 0;
18 SELECT @@global.sync_binlog;
19 @@global.sync_binlog
20 0
21 SET @@global.sync_binlog = 1;
22 SELECT @@global.sync_binlog;
23 @@global.sync_binlog
24 1
25 SET @@global.sync_binlog = 4294967295;
26 SELECT @@global.sync_binlog;
27 @@global.sync_binlog
28 4294967295
29 SET @@global.sync_binlog = 4294967294;
30 SELECT @@global.sync_binlog;
31 @@global.sync_binlog
32 4294967294
33 SET @@global.sync_binlog = 65536;
34 SELECT @@global.sync_binlog;
35 @@global.sync_binlog
36 65536
37 '#--------------------FN_DYNVARS_168_04-------------------------#'
38 SET @@global.sync_binlog = -1;
39 Warnings:
40 Warning 1292 Truncated incorrect sync_binlog value: '-1'
41 SELECT @@global.sync_binlog;
42 @@global.sync_binlog
43 0
44 SET @@global.sync_binlog = 4294967296;
45 Warnings:
46 Warning 1292 Truncated incorrect sync_binlog value: '4294967296'
47 SELECT @@global.sync_binlog;
48 @@global.sync_binlog
49 4294967295
50 SET @@global.sync_binlog = 10240022115;
51 Warnings:
52 Warning 1292 Truncated incorrect sync_binlog value: '10240022115'
53 SELECT @@global.sync_binlog;
54 @@global.sync_binlog
55 4294967295
56 SET @@global.sync_binlog = 10000.01;
57 ERROR 42000: Incorrect argument type to variable 'sync_binlog'
58 SELECT @@global.sync_binlog;
59 @@global.sync_binlog
60 4294967295
61 SET @@global.sync_binlog = -1024;
62 Warnings:
63 Warning 1292 Truncated incorrect sync_binlog value: '-1024'
64 SELECT @@global.sync_binlog;
65 @@global.sync_binlog
66 0
67 SET @@global.sync_binlog = 42949672950;
68 Warnings:
69 Warning 1292 Truncated incorrect sync_binlog value: '42949672950'
70 SELECT @@global.sync_binlog;
71 @@global.sync_binlog
72 4294967295
73 SET @@global.sync_binlog = ON;
74 ERROR 42000: Incorrect argument type to variable 'sync_binlog'
75 SELECT @@global.sync_binlog;
76 @@global.sync_binlog
77 4294967295
78 SET @@global.sync_binlog = 'test';
79 ERROR 42000: Incorrect argument type to variable 'sync_binlog'
80 SELECT @@global.sync_binlog;
81 @@global.sync_binlog
82 4294967295
83 '#-------------------FN_DYNVARS_168_05----------------------------#'
84 SET @@session.sync_binlog = 0;
85 ERROR HY000: Variable 'sync_binlog' is a GLOBAL variable and should be set with SET GLOBAL
86 SELECT @@sync_binlog;
87 @@sync_binlog
88 4294967295
89 '#----------------------FN_DYNVARS_168_06------------------------#'
90 SELECT @@global.sync_binlog = VARIABLE_VALUE
91 FROM performance_schema.global_variables
92 WHERE VARIABLE_NAME='sync_binlog';
93 @@global.sync_binlog = VARIABLE_VALUE
94 1
95 '#---------------------FN_DYNVARS_168_07----------------------#'
96 SET sync_binlog = 1;
97 ERROR HY000: Variable 'sync_binlog' is a GLOBAL variable and should be set with SET GLOBAL
98 SELECT @@sync_binlog;
99 @@sync_binlog
100 4294967295
101 SET local.sync_binlog = 1;
102 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'local.sync_binlog = 1' at line 1
103 SELECT local.sync_binlog;
104 ERROR 42S02: Unknown table 'local' in field list
105 SET global.sync_binlog = 1;
106 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'global.sync_binlog = 1' at line 1
107 SELECT global.sync_binlog;
108 ERROR 42S02: Unknown table 'global' in field list
109 SELECT sync_binlog;
110 ERROR 42S22: Unknown column 'sync_binlog' in 'field list'
111 SELECT @@session.sync_binlog;
112 ERROR HY000: Variable 'sync_binlog' is a GLOBAL variable
113 SET @@global.sync_binlog = @start_value;
114 SELECT @@global.sync_binlog;
115 @@global.sync_binlog
116 1