diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2019-03-26 14:13:46 +0200 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2019-03-26 14:13:46 +0200 |
| commit | 1933cf98e842f97e11f69afc631638618ec16068 (patch) | |
| tree | 446b8ff1ac09234b99d71ff06b75961c43247083 /mysql-test/r/events_1.result | |
| parent | 137812c88a418479c7d637f4075712d9f6c6c82f (diff) | |
| parent | e8907112790475772b3e5135b58ef95b3fd8ea68 (diff) | |
| download | mariadb-git-bb-10.0-merge.tar.gz | |
Merge 5.5 into 10.0bb-10.0-merge
Diffstat (limited to 'mysql-test/r/events_1.result')
| -rw-r--r-- | mysql-test/r/events_1.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/events_1.result b/mysql-test/r/events_1.result index 4e7ff526eca..93703109e10 100644 --- a/mysql-test/r/events_1.result +++ b/mysql-test/r/events_1.result @@ -49,7 +49,7 @@ SECOND 10 SELECT 1 SELECT execute_at IS NULL, starts IS NULL, ends IS NULL, comment FROM mysql.event WHERE db='events_test' AND name='event_starts_test'; execute_at IS NULL starts IS NULL ends IS NULL comment 1 0 1 -ALTER EVENT event_starts_test ON SCHEDULE AT '2020-02-02 20:00:02'; +ALTER EVENT event_starts_test ON SCHEDULE AT '1970-01-02 00:00:00' ON COMPLETION PRESERVE DISABLE; SELECT execute_at IS NULL, starts IS NULL, ends IS NULL, comment FROM mysql.event WHERE db='events_test' AND name='event_starts_test'; execute_at IS NULL starts IS NULL ends IS NULL comment 0 1 1 @@ -62,7 +62,7 @@ SELECT execute_at IS NULL, starts IS NULL, ends IS NULL, comment FROM mysql.even execute_at IS NULL starts IS NULL ends IS NULL comment 0 1 1 DROP EVENT event_starts_test; -CREATE EVENT event_starts_test ON SCHEDULE EVERY 20 SECOND STARTS '2020-02-02 20:00:02' ENDS '2022-02-02 20:00:02' DO SELECT 2; +CREATE EVENT event_starts_test ON SCHEDULE EVERY 20 SECOND STARTS '1970-01-02 00:00:00' ENDS '1970-01-03 00:00:00' ON COMPLETION PRESERVE DISABLE DO SELECT 2; SELECT execute_at IS NULL, starts IS NULL, ends IS NULL, comment FROM mysql.event WHERE db='events_test' AND name='event_starts_test'; execute_at IS NULL starts IS NULL ends IS NULL comment 1 0 0 |