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
• Status: Duplicate
• Category: MySQL Server: Stored Routines
• Severity: S3 (Non-critical)
• Version: 5.1.6/5.1.7
• OS: Linux (Linux)
• CPU Architecture: Any

[16 Feb 2006 16:12] Giuseppe Maxia

Description:
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'