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:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.1.6 OS:Linux (SuSE Linux)
Assigned to: CPU Architecture:Any

[14 Feb 2006 20:33] Markus Popp
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.
[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.