From 3c67b8039ed0c286ae444e619a85eba27c4f354f Mon Sep 17 00:00:00 2001 From: "andrey@lmy004." <> Date: Fri, 3 Mar 2006 01:39:11 +0100 Subject: 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 | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'mysql-test/r/events_bugs.result') 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; -- cgit v1.2.1