Bug #26431 Impossible to re-create an event from backup if its STARTS clause is in the past
Submitted: 15 Feb 2007 23:36 Modified: 16 Mar 2007 16:22
Reporter: Konstantin Osipov
Status: Duplicate
Category:Server: SP Severity:S3 (Non-critical)
Version: OS:
Assigned to: Bugs System Target Version:

[15 Feb 2007 23: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 15:47] Miguel Solorzano 
Thank you for the bug report. Verified as described.
[15 Mar 2007 19:30] Tomash Brechko 
This bug will be fix together with bug#16420.
[16 Mar 2007 16: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.