Debian Codegraph @

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

raw
1 include/assert.inc [Initial value for binlog_expire_logs_auto_purge is TRUE]
2 SET @@GLOBAL.binlog_expire_logs_auto_purge = FALSE;
3 include/assert.inc [Value for binlog_expire_logs_auto_purge was set to FALSE]
4 SET @@GLOBAL.binlog_expire_logs_auto_purge = DEFAULT;
5 include/assert.inc [Value for binlog_expire_logs_auto_purge was set to DEFAULT (TRUE)]
6 SET @@GLOBAL.binlog_expire_logs_auto_purge = 1;
7 include/assert.inc [Value for binlog_expire_logs_auto_purge was set to TRUE (1)]
8 SET @@GLOBAL.binlog_expire_logs_auto_purge = ON;
9 include/assert.inc [Value for binlog_expire_logs_auto_purge was set to TRUE (ON)]
10 SET @@GLOBAL.binlog_expire_logs_auto_purge = 0;
11 include/assert.inc [Value for binlog_expire_logs_auto_purge was set to FALSE (0)]
12 SET @@GLOBAL.binlog_expire_logs_auto_purge = OFF;
13 include/assert.inc [Value for binlog_expire_logs_auto_purge was set to FALSE (OFF)]
14 SET @@global.binlog_expire_logs_auto_purge = -1;
15 ERROR 42000: Variable 'binlog_expire_logs_auto_purge' can't be set to the value of '-1'
16 SELECT @@global.binlog_expire_logs_auto_purge;
17 @@global.binlog_expire_logs_auto_purge
18 0
19 SET @@global.binlog_expire_logs_auto_purge = "AAAA";
20 ERROR 42000: Variable 'binlog_expire_logs_auto_purge' can't be set to the value of 'AAAA'
21 SELECT @@global.binlog_expire_logs_auto_purge;
22 @@global.binlog_expire_logs_auto_purge
23 0
24 SET @@global.binlog_expire_logs_auto_purge = NULL;
25 ERROR 42000: Variable 'binlog_expire_logs_auto_purge' can't be set to the value of 'NULL'
26 SELECT @@global.binlog_expire_logs_auto_purge;
27 @@global.binlog_expire_logs_auto_purge
28 0
29 SET @@global.binlog_expire_logs_auto_purge = 42949672950;
30 ERROR 42000: Variable 'binlog_expire_logs_auto_purge' can't be set to the value of '42949672950'
31 SELECT @@global.binlog_expire_logs_auto_purge;
32 @@global.binlog_expire_logs_auto_purge
33 0
34 SET @@session.binlog_expire_logs_auto_purge = 0;
35 ERROR HY000: Variable 'binlog_expire_logs_auto_purge' is a GLOBAL variable and should be set with SET GLOBAL
36 SELECT @@session.binlog_expire_logs_auto_purge;
37 ERROR HY000: Variable 'binlog_expire_logs_auto_purge' is a GLOBAL variable
38 SELECT @@global.binlog_expire_logs_auto_purge = VARIABLE_VALUE
39 FROM performance_schema.global_variables
40 WHERE VARIABLE_NAME='binlog_expire_logs_auto_purge';
41 @@global.binlog_expire_logs_auto_purge = VARIABLE_VALUE
42 1
43 SELECT @@binlog_expire_logs_auto_purge = VARIABLE_VALUE
44 FROM performance_schema.session_variables
45 WHERE VARIABLE_NAME='binlog_expire_logs_auto_purge';
46 @@binlog_expire_logs_auto_purge = VARIABLE_VALUE
47 1
48 SET @@global.binlog_expire_logs_auto_purge = 1;
49 SELECT @@binlog_expire_logs_auto_purge = @@global.binlog_expire_logs_auto_purge;
50 @@binlog_expire_logs_auto_purge = @@global.binlog_expire_logs_auto_purge
51 1
52 SET binlog_expire_logs_auto_purge = 1;
53 ERROR HY000: Variable 'binlog_expire_logs_auto_purge' is a GLOBAL variable and should be set with SET GLOBAL
54 SELECT @@binlog_expire_logs_auto_purge;
55 @@binlog_expire_logs_auto_purge
56 1
57 SET local.binlog_expire_logs_auto_purge = 1;
58 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_auto_purge = 1' at line 1
59 SELECT local.binlog_expire_logs_auto_purge;
60 ERROR 42S02: Unknown table 'local' in field list
61 SET global.binlog_expire_logs_auto_purge = 1;
62 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_auto_purge = 1' at line 1
63 SELECT global.binlog_expire_logs_auto_purge;
64 ERROR 42S02: Unknown table 'global' in field list
65 SELECT binlog_expire_logs_auto_purge = @@global.binlog_expire_logs_auto_purge;
66 ERROR 42S22: Unknown column 'binlog_expire_logs_auto_purge' in 'field list'
67 SET @@global.binlog_expire_logs_auto_purge = 1;;
68 SELECT @@global.binlog_expire_logs_auto_purge;
69 @@global.binlog_expire_logs_auto_purge
70 1