| Bug #17398 | SHOW CREATE EVENT returns OK message, but no output | ||
|---|---|---|---|
| Submitted: | 14 Feb 2006 20:33 | Modified: | 14 Feb 2006 22:11 |
| Reporter: | Markus Popp | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Server | Severity: | S3 (Non-critical) |
| Version: | 5.1.6 | OS: | Linux (SuSE Linux) |
| Assigned to: | CPU Architecture: | Any | |
[14 Feb 2006 21:25]
Andrey Hristov
Dupe of bug#16423. Will be working in 5.1.7 Please search whether the bug was already submitted before reporting :)
[14 Feb 2006 21:27]
Andrey Hristov
http://bugs.mysql.com/bugstats.php is your friend. You can see there all verified, in progress, etc. bugs.
[14 Feb 2006 22:11]
Markus Popp
I have searched for all bugs in Event scheduler, which resulted in this link: http://bugs.mysql.com/search.php?search_for=&limit=10&order_by=&direction=ASC&cmd=display&... Here, this bug doesn't show up.
[14 Feb 2006 23:15]
Andrey Hristov
I used this one, from advanced search and found it http://bugs.mysql.com/search.php?search_for=&limit=All&order_by=&direction=ASC&cmd=display...
[14 Feb 2006 23:28]
Markus Popp
Where?
Attachment: screenshot.jpg (image/jpeg, text), 184.72 KiB.
Description: I don't know, if the SHOW CREATE EVENT command is currently implemented (this command would of course be desireable), however - it returns a "Query OK" message, but without the CREATE statement of the EVENT. How to repeat: mysql> show events \G *************************** 1. row *************************** Db: mysql Name: cleanGeneralLog Definer: mpopp_root@% Type: RECURRING Execute at: NULL Interval value: 1 Interval field: INTERVAL_DAY Starts: 2006-02-15 00:00:00 Ends: 0000-00-00 00:00:00 Status: ENABLED *************************** 2. row *************************** Db: mysql Name: cleanSlowLog Definer: mpopp_root@% Type: RECURRING Execute at: NULL Interval value: 1 Interval field: INTERVAL_DAY Starts: 2006-02-15 00:00:00 Ends: 0000-00-00 00:00:00 Status: ENABLED 2 rows in set (3.94 sec) mysql> show create event cleanSlowLog \G Query OK, 1 row affected (0.08 sec) Suggested fix: SHOW CREATE EVENT should show the command how an event was created.