diff options
| author | Michael Widenius <monty@mariadb.org> | 2019-03-25 08:02:22 +0200 |
|---|---|---|
| committer | Monty <monty@mariadb.org> | 2019-04-01 19:47:24 +0300 |
| commit | b5615eff0d00cfb4c60b9d1bf67094da7c2258a6 (patch) | |
| tree | b4ebb1f0dc98463b98eb5cfb9fc633597f37c8f2 /mysql-test/main/events_restart.result | |
| parent | 6fd7a4b60124bb7bcca2d90211e5113d37458875 (diff) | |
| download | mariadb-git-b5615eff0d00cfb4c60b9d1bf67094da7c2258a6.tar.gz | |
Write information about restart in .result
Idea comes from MySQL which does something similar
Diffstat (limited to 'mysql-test/main/events_restart.result')
| -rw-r--r-- | mysql-test/main/events_restart.result | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/mysql-test/main/events_restart.result b/mysql-test/main/events_restart.result index 0caac907f64..8c9c252018a 100644 --- a/mysql-test/main/events_restart.result +++ b/mysql-test/main/events_restart.result @@ -15,6 +15,7 @@ insert into event_like select * from mysql.event; alter table mysql.event change column body body longtext character set utf8 collate utf8_bin; "Now we restart the server" +# restart use events_test; select @@event_scheduler; @@event_scheduler @@ -75,6 +76,7 @@ events_test abc1 root@localhost SYSTEM RECURRING # 1 SECOND # # ENABLED 1 latin1 events_test abc2 root@localhost SYSTEM RECURRING # 1 SECOND # # ENABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci events_test abc3 root@localhost SYSTEM RECURRING # 1 SECOND # # ENABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci Now let's restart the server again +# restart use events_test; select @@event_scheduler; @@event_scheduler @@ -95,6 +97,7 @@ SHOW EVENTS; Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation test e1 root@localhost SYSTEM RECURRING # 1 SECOND # # DISABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci "Now we restart the server" +# restart USE test; SELECT @@event_scheduler; @@event_scheduler |