MySQL Bugs: #26431: Impossible to re-create an event from backup if its STARTS clause is in the past

Bug #26431	Impossible to re-create an event from backup if its STARTS clause is in the past
Submitted:	15 Feb 2007 22:36	Modified:	16 Mar 2007 15:22
Reporter:	Konstantin Osipov (OCA)	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: Stored Routines	Severity:	S3 (Non-critical)
Version:		OS:
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
I am forced to use an artificial example in this bug report because of 
Bug#26429 "SHoW CREATE EVENT is incorrect for an event that STARTS NOW()".

Here is an example showing this artificial limitation:

mysql> create event foo on schedule every 123 minute starts "2007-02-16 01:25:00" do select 1; select now();
ERROR 1513 (HY000): Incorrect STARTS value: '2007-02-16 01:25:00'
+---------------------+
| now()               |
+---------------------+
| 2007-02-16 01:31:01 | 
+---------------------+
1 row in set (0.00 sec)

Imagine there is an event that was created with explicit STARTS clause a while ago. This event will not be possible to restore from a backup.

How to repeat:
create event foo on schedule every 123 minute starts "2007-02-16 01:25:00" do select 1;

Thank you for the bug report. Verified as described.

This bug will be fix together with bug#16420.

Bug#16420 was queued to 5.1-runtime.  Marking this one as duplicate, as it is fixed by the queued patch, and requires no additional attention.