Debian Codegraph @

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

raw
1 SET @start_value_sec = @@global.binlog_expire_logs_seconds;
2 SELECT @start_value_sec;
3 @start_value_sec
4 0
5 SET @@global.binlog_expire_logs_seconds = DEFAULT;
6 SELECT @@global.binlog_expire_logs_seconds;
7 @@global.binlog_expire_logs_seconds
8 0
9 SET @@global.binlog_expire_logs_seconds = @start_value_sec;
10 SELECT @@global.binlog_expire_logs_seconds = 0;
11 @@global.binlog_expire_logs_seconds = 0
12 1
13 SET @@global.binlog_expire_logs_seconds = 0;
14 SELECT @@global.binlog_expire_logs_seconds;
15 @@global.binlog_expire_logs_seconds
16 0
17 SET @@global.binlog_expire_logs_seconds = 99;
18 SELECT @@global.binlog_expire_logs_seconds;
19 @@global.binlog_expire_logs_seconds
20 99
21 SET @@global.binlog_expire_logs_seconds = 10;
22 SELECT @@global.binlog_expire_logs_seconds;
23 @@global.binlog_expire_logs_seconds
24 10
25 SET @@global.binlog_expire_logs_seconds = 21;
26 SELECT @@global.binlog_expire_logs_seconds;
27 @@global.binlog_expire_logs_seconds
28 21
29 SET @@global.binlog_expire_logs_seconds = -1;
30 Warnings:
31 Warning 1292 Truncated incorrect binlog_expire_logs_seconds value: '-1'
32 SELECT @@global.binlog_expire_logs_seconds;
33 @@global.binlog_expire_logs_seconds
34 0
35 SET @@global.binlog_expire_logs_seconds = 10000.01;
36 ERROR 42000: Incorrect argument type to variable 'binlog_expire_logs_seconds'
37 SELECT @@global.binlog_expire_logs_seconds;
38 @@global.binlog_expire_logs_seconds
39 0
40 SET @@global.binlog_expire_logs_seconds = -1024;
41 Warnings:
42 Warning 1292 Truncated incorrect binlog_expire_logs_seconds value: '-1024'
43 SELECT @@global.binlog_expire_logs_seconds;
44 @@global.binlog_expire_logs_seconds
45 0
46 SET @@global.binlog_expire_logs_seconds = 42949672950;
47 Warnings:
48 Warning 1292 Truncated incorrect binlog_expire_logs_seconds value: '42949672950'
49 SELECT @@global.binlog_expire_logs_seconds;
50 @@global.binlog_expire_logs_seconds
51 8553600
52 SET @@global.binlog_expire_logs_seconds = 8734635;
53 Warnings:
54 Warning 1292 Truncated incorrect binlog_expire_logs_seconds value: '8734635'
55 SELECT @@global.binlog_expire_logs_seconds;
56 @@global.binlog_expire_logs_seconds
57 8553600
58 SET @@global.binlog_expire_logs_seconds = ON;
59 ERROR 42000: Incorrect argument type to variable 'binlog_expire_logs_seconds'
60 SELECT @@global.binlog_expire_logs_seconds;
61 @@global.binlog_expire_logs_seconds
62 8553600
63 SET @@global.binlog_expire_logs_seconds = 'test';
64 ERROR 42000: Incorrect argument type to variable 'binlog_expire_logs_seconds'
65 SELECT @@global.binlog_expire_logs_seconds;
66 @@global.binlog_expire_logs_seconds
67 8553600
68 SET @@session.binlog_expire_logs_seconds = 0;
69 ERROR HY000: Variable 'binlog_expire_logs_seconds' is a GLOBAL variable and should be set with SET GLOBAL
70 SELECT @@binlog_expire_logs_seconds;
71 @@binlog_expire_logs_seconds
72 8553600
73 SELECT @@global.binlog_expire_logs_seconds = VARIABLE_VALUE
74 FROM information_schema.global_variables
75 WHERE VARIABLE_NAME='binlog_expire_logs_seconds';
76 @@global.binlog_expire_logs_seconds = VARIABLE_VALUE
77 1
78 SELECT @@binlog_expire_logs_seconds = VARIABLE_VALUE
79 FROM information_schema.session_variables
80 WHERE VARIABLE_NAME='binlog_expire_logs_seconds';
81 @@binlog_expire_logs_seconds = VARIABLE_VALUE
82 1
83 SET @@global.binlog_expire_logs_seconds = TRUE;
84 SELECT @@global.binlog_expire_logs_seconds;
85 @@global.binlog_expire_logs_seconds
86 1
87 SET @@global.binlog_expire_logs_seconds = FALSE;
88 SELECT @@global.binlog_expire_logs_seconds;
89 @@global.binlog_expire_logs_seconds
90 0
91 SET @@global.binlog_expire_logs_seconds = 1;
92 SELECT @@binlog_expire_logs_seconds = @@global.binlog_expire_logs_seconds;
93 @@binlog_expire_logs_seconds = @@global.binlog_expire_logs_seconds
94 1
95 SET binlog_expire_logs_seconds = 1;
96 ERROR HY000: Variable 'binlog_expire_logs_seconds' is a GLOBAL variable and should be set with SET GLOBAL
97 SELECT @@binlog_expire_logs_seconds;
98 @@binlog_expire_logs_seconds
99 1
100 SELECT local.binlog_expire_logs_seconds;
101 ERROR 42S02: Unknown table 'local' in SELECT
102 SELECT global.binlog_expire_logs_seconds;
103 ERROR 42S02: Unknown table 'global' in SELECT
104 SELECT binlog_expire_logs_seconds = @@session.binlog_expire_logs_seconds;
105 ERROR 42S22: Unknown column 'binlog_expire_logs_seconds' in 'SELECT'
106 SET @@global.binlog_expire_logs_seconds = @start_value_sec;
107 SELECT @@global.binlog_expire_logs_seconds;
108 @@global.binlog_expire_logs_seconds
109 0