diff options
Diffstat (limited to 'mysql-test/suite/binlog/r/binlog_expire_warnings.result')
| -rw-r--r-- | mysql-test/suite/binlog/r/binlog_expire_warnings.result | 134 |
1 files changed, 134 insertions, 0 deletions
diff --git a/mysql-test/suite/binlog/r/binlog_expire_warnings.result b/mysql-test/suite/binlog/r/binlog_expire_warnings.result new file mode 100644 index 00000000000..728fe6efacc --- /dev/null +++ b/mysql-test/suite/binlog/r/binlog_expire_warnings.result @@ -0,0 +1,134 @@ +#### Binary log ENABLED #### +==== Don't set any option ==== +# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err +include/assert_grep.inc [There shall be no binlog_off+seconds warning] +include/assert.inc [binlog_expire_logs_seconds shall be 0] +include/assert.inc [expire_logs_days shall be 0] +==== Set one option to zero ==== +---- days=0 ---- +# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --expire_logs_days=0 +include/assert_grep.inc [There shall be no binlog_off+seconds warning] +include/assert.inc [binlog_expire_logs_seconds shall be 0] +include/assert.inc [expire_logs_days shall be 0] +---- seconds=0 ---- +# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --binlog-expire-logs-seconds=0 +include/assert_grep.inc [There shall be no binlog_off+seconds warning] +include/assert.inc [binlog_expire_logs_seconds shall be 0] +include/assert.inc [expire_logs_days shall be 0] +==== Set one option to non-zero ==== +---- days=2 ---- +# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --expire_logs_days=2 +include/assert_grep.inc [There shall be no binlog_off+seconds warning] +include/assert.inc [binlog_expire_logs_seconds shall be 172800] +include/assert.inc [expire_logs_days shall be 2] +---- seconds=86400 ---- +# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --binlog-expire-logs-seconds=86400 +include/assert_grep.inc [There shall be no binlog_off+seconds warning] +include/assert.inc [binlog_expire_logs_seconds shall be 86400] +include/assert.inc [expire_logs_days shall be 1] +==== Set both options to zero ==== +# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --expire_logs_days=0 --binlog-expire-logs-seconds=0 +include/assert_grep.inc [There shall be no binlog_off+seconds warning] +include/assert.inc [binlog_expire_logs_seconds shall be 0] +include/assert.inc [expire_logs_days shall be 0] +==== Set both options: one to zero and one to non-zero ==== +---- days=1 seconds=0 ---- +---- The later seconds=0 will override days. +# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --expire_logs_days=1 --binlog-expire-logs-seconds=0 +include/assert_grep.inc [There shall be no binlog_off+seconds warning] +include/assert.inc [binlog_expire_logs_seconds shall be 0] +include/assert.inc [expire_logs_days shall be 0] +---- seconds=0 days=1 ---- +---- The later days=1 will override seconds. +# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --binlog-expire-logs-seconds=0 --expire_logs_days=1 +include/assert_grep.inc [There shall be no binlog_off+seconds warning] +include/assert.inc [binlog_expire_logs_seconds shall be 86400] +include/assert.inc [expire_logs_days shall be 1] +---- days=0 seconds=86400 ---- +---- The later seconds=86400 will override days. +# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --expire_logs_days=0 --binlog-expire-logs-seconds=86400 +include/assert_grep.inc [There shall be no binlog_off+seconds warning] +include/assert.inc [binlog_expire_logs_seconds shall be 86400] +include/assert.inc [expire_logs_days shall be 1] +==== Set both options to non-zero ==== +---- days=1 and seconds=172800 ---- +---- Since binlog_expire_logs_seconds is set later expire_log_days +---- becomes 2 +# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --expire_logs_days=1 --binlog-expire-logs-seconds=172800 +include/assert_grep.inc [There shall be no binlog_off+seconds warning] +include/assert.inc [binlog_expire_logs_seconds shall be 172800] +include/assert.inc [expire_logs_days shall be 2] +---- days=1 and seconds=172800 ---- +---- Since expire_logs_days is set later binlog_expire_logs_seconds +---- becomes 86400 +# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --binlog-expire-logs-seconds=172800 --expire_logs_days=1 +include/assert_grep.inc [There shall be no binlog_off+seconds warning] +include/assert.inc [binlog_expire_logs_seconds shall be 86400] +include/assert.inc [expire_logs_days shall be 1] +#### Binary log DISABLED #### +==== Don't set any option ==== +# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin +include/assert_grep.inc [There shall be no binlog_off+seconds warning] +include/assert.inc [binlog_expire_logs_seconds shall be 0] +include/assert.inc [expire_logs_days shall be 0] +==== Set one option to zero ==== +---- days=0 ---- +# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --expire_logs_days=0 +include/assert_grep.inc [There shall be no binlog_off+seconds warning] +include/assert.inc [binlog_expire_logs_seconds shall be 0] +include/assert.inc [expire_logs_days shall be 0] +---- seconds=0 ---- +# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --binlog-expire-logs-seconds=0 +include/assert_grep.inc [There shall be no binlog_off+seconds warning] +include/assert.inc [binlog_expire_logs_seconds shall be 0] +include/assert.inc [expire_logs_days shall be 0] +==== Set one option to non-zero ==== +---- days=2 ---- +# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --expire_logs_days=2 +include/assert_grep.inc [There shall be a binlog_off+seconds warning] +include/assert.inc [binlog_expire_logs_seconds shall be 172800] +include/assert.inc [expire_logs_days shall be 2] +---- seconds=86400 ---- +# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --binlog-expire-logs-seconds=86400 +include/assert_grep.inc [There shall be a binlog_off+seconds warning] +include/assert.inc [binlog_expire_logs_seconds shall be 86400] +include/assert.inc [expire_logs_days shall be 1] +==== Set both options to zero ==== +# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --expire_logs_days=0 --binlog-expire-logs-seconds=0 +include/assert_grep.inc [There shall be no binlog_off+seconds warning] +include/assert.inc [binlog_expire_logs_seconds shall be 0] +include/assert.inc [expire_logs_days shall be 0] +==== Set both options: one to zero and one to non-zero ==== +---- days=1 seconds=0 ---- +---- The later seconds=0 will override days. +# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --expire_logs_days=1 --binlog-expire-logs-seconds=0 +include/assert_grep.inc [There shall be no binlog_off+seconds warning] +include/assert.inc [binlog_expire_logs_seconds shall be 0] +include/assert.inc [expire_logs_days shall be 0] +---- seconds=0 days=1 ---- +---- The later days=1 will override seconds. +# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --binlog-expire-logs-seconds=0 --expire_logs_days=1 +include/assert_grep.inc [There shall be a binlog_off+seconds warning] +include/assert.inc [binlog_expire_logs_seconds shall be 86400] +include/assert.inc [expire_logs_days shall be 1] +---- days=0 seconds=86400 ---- +---- The later seconds=86400 will override days. +# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --expire_logs_days=0 --binlog-expire-logs-seconds=86400 +include/assert_grep.inc [There shall be a binlog_off+seconds warning] +include/assert.inc [binlog_expire_logs_seconds shall be 86400] +include/assert.inc [expire_logs_days shall be 1] +==== Set both options to non-zero ==== +---- days=1 and seconds=172800 ---- +---- Since binlog_expire_logs_seconds is set later expire_log_days +---- becomes 2 +# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --expire_logs_days=1 --binlog-expire-logs-seconds=172800 +include/assert_grep.inc [There shall be a binlog_off+seconds warning] +include/assert.inc [binlog_expire_logs_seconds shall be 172800] +include/assert.inc [expire_logs_days shall be 2] +---- days=1 and seconds=172800 ---- +---- Since expire_logs_days is set later binlog_expire_logs_seconds +---- becomes 86400 +# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --binlog-expire-logs-seconds=172800 --expire_logs_days=1 +include/assert_grep.inc [There shall be a binlog_off+seconds warning] +include/assert.inc [binlog_expire_logs_seconds shall be 86400] +include/assert.inc [expire_logs_days shall be 1] |