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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.057 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.