diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2013-07-17 18:51:12 +0200 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2013-07-17 18:51:12 +0200 |
| commit | c1d6a2d7e194225ccc19a68ea5d0f368632620d0 (patch) | |
| tree | bd13736fa139caac8c6e21484d2f03f6f0d30d57 /mysql-test/r/events_restart.result | |
| parent | 1b82512914db8d5779395017e2ed4a66a48b561c (diff) | |
| download | mariadb-git-c1d6a2d7e194225ccc19a68ea5d0f368632620d0.tar.gz | |
merge few bug fixes from 5.6
Diffstat (limited to 'mysql-test/r/events_restart.result')
| -rw-r--r-- | mysql-test/r/events_restart.result | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/mysql-test/r/events_restart.result b/mysql-test/r/events_restart.result index 6a751fa29f8..ba3aa503b63 100644 --- a/mysql-test/r/events_restart.result +++ b/mysql-test/r/events_restart.result @@ -65,3 +65,26 @@ select @@event_scheduler; ON drop table execution_log; drop database events_test; +# +# Test for bug#11748899 -- EVENT SET TO DISABLED AND ON COMPLETION +# NOT PRESERVE IS DELETED AT SERVER +# +SELECT @@event_scheduler; +@@event_scheduler +ON +USE test; +DROP EVENT IF EXISTS e1; +CREATE EVENT e1 ON SCHEDULE EVERY 1 SECOND DISABLE DO SELECT 1; +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" +USE test; +SELECT @@event_scheduler; +@@event_scheduler +ON +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 +DROP EVENT e1; +# end test for bug#11748899 |