diff options
| author | unknown <andrey@lmy004.> | 2006-03-03 01:39:11 +0100 |
|---|---|---|
| committer | unknown <andrey@lmy004.> | 2006-03-03 01:39:11 +0100 |
| commit | bcc6821b25aee9380add5d0478689b5eb2ef677e (patch) | |
| tree | e75398ff24a5cc48fbea0d44251b1f3254432765 /mysql-test/r/events_bugs.result | |
| parent | 8d7f44388bbd1d5197447c578979d31f0253f32d (diff) | |
| download | mariadb-git-bcc6821b25aee9380add5d0478689b5eb2ef677e.tar.gz | |
fix for bug #16396: Events: Distant-future dates become past dates
WL#1034 (Internal CRON)
timestamps does not support > y2038
mysql-test/r/events_bugs.result:
update results
mysql-test/t/events_bugs.test:
add tests
sql/event_timed.cc:
fix for bug #16396: Events: Distant-future dates become past dates.
Diffstat (limited to 'mysql-test/r/events_bugs.result')
| -rw-r--r-- | mysql-test/r/events_bugs.result | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/events_bugs.result b/mysql-test/r/events_bugs.result index 0b554f97b9a..c59adcd7447 100644 --- a/mysql-test/r/events_bugs.result +++ b/mysql-test/r/events_bugs.result @@ -1,5 +1,11 @@ create database if not exists events_test; use events_test; +create event e_55 on schedule at 99990101000000 do drop table t; +ERROR HY000: Incorrect AT value: '99990101000000' +create event e_55 on schedule every 10 hour starts 99990101000000 do drop table t; +ERROR HY000: Incorrect STARTS value: '99990101000000' +create event e_55 on schedule every 10 minute ends 99990101000000 do drop table t; +ERROR HY000: ENDS is either invalid or before STARTS set global event_scheduler=0; "Wait a bit to settle down" delete from mysql.event; |