Bug #26429 SHOW CREATE EVENT is incorrect for an event that STARTS NOW()
Submitted: 15 Feb 2007 23:14 Modified: 24 Mar 2007 7:12
Reporter: Konstantin Osipov
Status: Closed
Category:Server: SP Severity:S3 (Non-critical)
Version:5.1BK OS:Linux (Linux)
Assigned to: Bugs System Target Version:

[15 Feb 2007 23:14] Konstantin Osipov 
Description:
SHOW CREATE EVENT returns an incorrect event definition if the event is defined with
STARTS NOW():

mysql> drop event foo\G
Query OK, 0 rows affected (0.00 sec)

mysql> create event foo on schedule every 123 minute starts now() ends now() + interval 1
month do select 1;
Query OK, 0 rows affected (0.00 sec)

mysql> show create event foo\G
*************************** 1. row ***************************
       Event: foo
    sql_mode: 
Create Event: CREATE EVENT `foo` ON SCHEDULE EVERY 123 MINUTE ON COMPLETION NOT PRESERVE
ENABLE DO select 1
1 row in set (0.00 sec)

How to repeat:
drop event if exists foo;
create event foo on schedule every 123 minute starts now() ends now() + interval 1 month
do select 1;
show create event foo;
[18 Feb 2007 18:22] Miguel Solorzano 
Thank you for the bug report. Verified as described.
[22 Mar 2007 22:23] Konstantin Osipov 
Fixed in 5.1.17
[23 Mar 2007 0:25] Konstantin Osipov 
Fixed in 5.1.17
[24 Mar 2007 7:12] Jon Stephens 
Thank you for your bug report. This issue has been committed to our source repository of
that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available
version, including the bug fix. More information about accessing the source trees is
available at

    http://dev.mysql.com/doc/en/installing-source.html

Documented fix in 5.1.17 changelog.