diff options
Diffstat (limited to 'mysql-test/main/variables.result')
| -rw-r--r-- | mysql-test/main/variables.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/main/variables.result b/mysql-test/main/variables.result index 5a5247cf05e..2d7d13ce30b 100644 --- a/mysql-test/main/variables.result +++ b/mysql-test/main/variables.result @@ -1383,15 +1383,20 @@ SET @@session.thread_stack= 7; ERROR HY000: Variable 'thread_stack' is a read only variable SET @@global.thread_stack= 7; ERROR HY000: Variable 'thread_stack' is a read only variable +SELECT @@global.binlog_expire_logs_seconds INTO @old_seconds; +SET @@global.binlog_expire_logs_seconds = 0; SELECT @@global.expire_logs_days INTO @old_eld; SET GLOBAL expire_logs_days = -1; Warnings: +Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use '@@binlog_expire_logs_seconds' instead Warning 1292 Truncated incorrect expire_logs_days value: '-1' needs to've been adjusted (0) SELECT @@global.expire_logs_days; @@global.expire_logs_days 0 SET GLOBAL expire_logs_days = 11; +Warnings: +Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use '@@binlog_expire_logs_seconds' instead SET @old_mode=@@sql_mode; SET SESSION sql_mode = 'TRADITIONAL'; SET GLOBAL expire_logs_days = 100; @@ -1403,18 +1408,26 @@ SELECT @@global.expire_logs_days; SET SESSION sql_mode = @old_mode; SET GLOBAL expire_logs_days = 100; Warnings: +Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use '@@binlog_expire_logs_seconds' instead Warning 1292 Truncated incorrect expire_logs_days value: '100' needs to've been adjusted (99) SELECT @@global.expire_logs_days; @@global.expire_logs_days 99 SET GLOBAL expire_logs_days = 11; +Warnings: +Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use '@@binlog_expire_logs_seconds' instead SET GLOBAL expire_logs_days = 99; +Warnings: +Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use '@@binlog_expire_logs_seconds' instead needs to pass with no warnings (99) SELECT @@global.expire_logs_days; @@global.expire_logs_days 99 SET GLOBAL expire_logs_days = @old_eld; +Warnings: +Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use '@@binlog_expire_logs_seconds' instead +SET GLOBAL binlog_expire_logs_seconds= @old_seconds; SET GLOBAL auto_increment_offset=-1; Warnings: Warning 1292 Truncated incorrect auto_increment_offset value: '-1' |