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

[15 Feb 2007 22:36] Konstantin Osipov
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;
[19 Feb 2007 14:47] MySQL Verification Team
Thank you for the bug report. Verified as described.
[15 Mar 2007 18:30] Tomash Brechko
This bug will be fix together with bug#16420.
[16 Mar 2007 15:22] Tomash Brechko
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.