| Bug #26429 | SHOW CREATE EVENT is incorrect for an event that STARTS NOW() | ||
|---|---|---|---|
| Submitted: | 15 Feb 2007 22:14 | Modified: | 24 Mar 2007 6:12 |
| Reporter: | Konstantin Osipov (OCA) | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Stored Routines | Severity: | S3 (Non-critical) |
| Version: | 5.1BK | OS: | Linux (Linux) |
| Assigned to: | Tomash Brechko | CPU Architecture: | Any |
[18 Feb 2007 17:22]
MySQL Verification Team
Thank you for the bug report. Verified as described.
[22 Mar 2007 21:23]
Konstantin Osipov
Fixed in 5.1.17
[22 Mar 2007 23:25]
Konstantin Osipov
Fixed in 5.1.17
[24 Mar 2007 6: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.
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;