Bug #16423 Events: SHOW CREATE EVENT doesn't work
Submitted: 12 Jan 2006 4:16 Modified: 15 Feb 2006 20:39
Reporter: Peter Gulutzan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Stored Routines Severity:S3 (Non-critical)
Version:5.1.6-alpha-debug OS:Linux (SUSE 10.0)
Assigned to: Andrey Hristov CPU Architecture:Any

[12 Jan 2006 4:16] Peter Gulutzan
Description:
SHOW CREATE EVENT should work like SHOW CREATE TABLE, etc.
That is, it should show a CREATE statement for the event.
Instead, it shows nothing.

How to repeat:

mysql> create event e_31 on schedule every 1 second do insert into t values (0);
Query OK, 1 row affected (0.00 sec)

mysql> show create event e_31;
Query OK, 1 row affected (0.00 sec)
[1 Feb 2006 21:38] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/2028
[1 Feb 2006 21:53] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/2029
[9 Feb 2006 0:21] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/2344
[9 Feb 2006 10:55] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/2356
[14 Feb 2006 15:23] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/2601
[14 Feb 2006 21:56] Andrey Hristov
Fixed in 5.1.7 . See CS comments for details
[15 Feb 2006 20:39] Paul Dubois
Noted in 5.1.7 changelog.