Bug #17482 SHOW CREATE EVENT is parsed but does not return the expected text
Submitted: 16 Feb 2006 16:12 Modified: 16 Feb 2006 16:20
Reporter: Giuseppe Maxia Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Server: Stored Routines Severity:S3 (Non-critical)
Version:5.1.6/5.1.7 OS:Linux (Linux)
Assigned to: CPU Architecture:Any

[16 Feb 2006 16:12] Giuseppe Maxia
SHOW CREATE EVENT is parsed correctly by the server, but it does not return anything.
The event details are in information_schema.events, but the above mentioned command
does not return any text.
Moreover, there is no check for the event existence, unlike what happen for other objects, such as tables, stored procedures, functions, and triggers.

How to repeat:
show create event does_not_exist\G
Query OK, 1 row affected (0.00 sec)

Suggested fix:
SHOW CREATE EVENT should either return an error or give the requested information.
[16 Feb 2006 16:20] Andrey Hristov
Dupe of bug #16423

Fixed in the upcoming 5.1.7. Already in BK.
mysql> select version();
| version()            |
| 5.1.7-beta-debug-log |
1 row in set (0.01 sec)

mysql> show create event does_not_exist\G
ERROR 1517 (HY000): Unknown event 'does_not_exist'