Debian Codegraph @

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

raw
1 SET @start_value = @@global.expire_logs_days;
2 Warnings:
3 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
4 SELECT @start_value;
5 @start_value
6 0
7 SET @@global.expire_logs_days = 0;
8 Warnings:
9 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
10 SET @start_value_sec = @@global.binlog_expire_logs_seconds;
11 SELECT @start_value_sec;
12 @start_value_sec
13 2592000
14 SET @@global.binlog_expire_logs_seconds = 8734635;
15 SET @@global.binlog_expire_logs_seconds = DEFAULT;
16 SELECT @@global.binlog_expire_logs_seconds;
17 @@global.binlog_expire_logs_seconds
18 2592000
19 SET @@global.binlog_expire_logs_seconds = @start_value_sec;
20 SELECT @@global.binlog_expire_logs_seconds = 2592000;
21 @@global.binlog_expire_logs_seconds = 2592000
22 1
23 SET @@global.binlog_expire_logs_seconds = 0;
24 SELECT @@global.binlog_expire_logs_seconds;
25 @@global.binlog_expire_logs_seconds
26 0
27 SET @@global.binlog_expire_logs_seconds = 99;
28 SELECT @@global.binlog_expire_logs_seconds;
29 @@global.binlog_expire_logs_seconds
30 99
31 SET @@global.binlog_expire_logs_seconds = 10;
32 SELECT @@global.binlog_expire_logs_seconds;
33 @@global.binlog_expire_logs_seconds
34 10
35 SET @@global.binlog_expire_logs_seconds = 21;
36 SELECT @@global.binlog_expire_logs_seconds;
37 @@global.binlog_expire_logs_seconds
38 21
39 SET @@global.binlog_expire_logs_seconds = -1;
40 Warnings:
41 Warning 1292 Truncated incorrect binlog_expire_logs_seconds value: '-1'
42 SELECT @@global.binlog_expire_logs_seconds;
43 @@global.binlog_expire_logs_seconds
44 0
45 SET @@global.binlog_expire_logs_seconds = 10000.01;
46 ERROR 42000: Incorrect argument type to variable 'binlog_expire_logs_seconds'
47 SELECT @@global.binlog_expire_logs_seconds;
48 @@global.binlog_expire_logs_seconds
49 0
50 SET @@global.binlog_expire_logs_seconds = -1024;
51 Warnings:
52 Warning 1292 Truncated incorrect binlog_expire_logs_seconds value: '-1024'
53 SELECT @@global.binlog_expire_logs_seconds;
54 @@global.binlog_expire_logs_seconds
55 0
56 SET @@global.binlog_expire_logs_seconds = 42949672950;
57 Warnings:
58 Warning 1292 Truncated incorrect binlog_expire_logs_seconds value: '42949672950'
59 SELECT @@global.binlog_expire_logs_seconds;
60 @@global.binlog_expire_logs_seconds
61 4294967295
62 SET @@global.binlog_expire_logs_seconds = ON;
63 ERROR 42000: Incorrect argument type to variable 'binlog_expire_logs_seconds'
64 SELECT @@global.binlog_expire_logs_seconds;
65 @@global.binlog_expire_logs_seconds
66 4294967295
67 SET @@global.binlog_expire_logs_seconds = 'test';
68 ERROR 42000: Incorrect argument type to variable 'binlog_expire_logs_seconds'
69 SELECT @@global.binlog_expire_logs_seconds;
70 @@global.binlog_expire_logs_seconds
71 4294967295
72 SET @@session.binlog_expire_logs_seconds = 0;
73 ERROR HY000: Variable 'binlog_expire_logs_seconds' is a GLOBAL variable and should be set with SET GLOBAL
74 SELECT @@binlog_expire_logs_seconds;
75 @@binlog_expire_logs_seconds
76 4294967295
77 SELECT @@global.binlog_expire_logs_seconds = VARIABLE_VALUE
78 FROM performance_schema.global_variables
79 WHERE VARIABLE_NAME='binlog_expire_logs_seconds';
80 @@global.binlog_expire_logs_seconds = VARIABLE_VALUE
81 1
82 SELECT @@binlog_expire_logs_seconds = VARIABLE_VALUE
83 FROM performance_schema.session_variables
84 WHERE VARIABLE_NAME='binlog_expire_logs_seconds';
85 @@binlog_expire_logs_seconds = VARIABLE_VALUE
86 1
87 SET @@global.binlog_expire_logs_seconds = TRUE;
88 SELECT @@global.binlog_expire_logs_seconds;
89 @@global.binlog_expire_logs_seconds
90 1
91 SET @@global.binlog_expire_logs_seconds = FALSE;
92 SELECT @@global.binlog_expire_logs_seconds;
93 @@global.binlog_expire_logs_seconds
94 0
95 SET @@global.binlog_expire_logs_seconds = 1;
96 SELECT @@binlog_expire_logs_seconds = @@global.binlog_expire_logs_seconds;
97 @@binlog_expire_logs_seconds = @@global.binlog_expire_logs_seconds
98 1
99 SET binlog_expire_logs_seconds = 1;
100 ERROR HY000: Variable 'binlog_expire_logs_seconds' is a GLOBAL variable and should be set with SET GLOBAL
101 SELECT @@binlog_expire_logs_seconds;
102 @@binlog_expire_logs_seconds
103 1
104 SET local.binlog_expire_logs_seconds = 1;
105 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.binlog_expire_logs_seconds = 1' at line 1
106 SELECT local.binlog_expire_logs_seconds;
107 ERROR 42S02: Unknown table 'local' in field list
108 SET global.binlog_expire_logs_seconds = 1;
109 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.binlog_expire_logs_seconds = 1' at line 1
110 SELECT global.binlog_expire_logs_seconds;
111 ERROR 42S02: Unknown table 'global' in field list
112 SELECT binlog_expire_logs_seconds;
113 ERROR 42S22: Unknown column 'binlog_expire_logs_seconds' in 'field list'
114 SELECT @@session.binlog_expire_logs_seconds;
115 ERROR HY000: Variable 'binlog_expire_logs_seconds' is a GLOBAL variable
116 SET @@global.binlog_expire_logs_seconds = @start_value_sec;
117 SELECT @@global.binlog_expire_logs_seconds;
118 @@global.binlog_expire_logs_seconds
119 2592000
120 SET @@global.expire_logs_days = @start_value;
121 Warnings:
122 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
123 SELECT @@global.expire_logs_days;
124 @@global.expire_logs_days
125 0
126 Warnings:
127 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.