summaryrefslogtreecommitdiff
path: root/mysql-test/main/variables.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/variables.test')
-rw-r--r--mysql-test/main/variables.test6
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/main/variables.test b/mysql-test/main/variables.test
index 495ab101352..6a7dff6a10f 100644
--- a/mysql-test/main/variables.test
+++ b/mysql-test/main/variables.test
@@ -1127,6 +1127,11 @@ SET @@global.thread_stack= 7;
# Bug #40657 - assertion with out of range variables and traditional sql_mode
#
+SELECT @@global.binlog_expire_logs_seconds INTO @old_seconds;
+
+# Set binlog_expire_logs_seconds to 0 in order to test expire_logs_days
+# or we will get error while setting expire_logs_days
+SET @@global.binlog_expire_logs_seconds = 0;
SELECT @@global.expire_logs_days INTO @old_eld;
SET GLOBAL expire_logs_days = -1;
@@ -1153,6 +1158,7 @@ SELECT @@global.expire_logs_days;
# cleanup
SET GLOBAL expire_logs_days = @old_eld;
+SET GLOBAL binlog_expire_logs_seconds= @old_seconds;
# show that warning uses underscore (sysvar-name), not hyphens (option-name)
SET GLOBAL auto_increment_offset=-1;