Bug #16521 Events: mysql.event.on_completion value is 'DROP'

Submitted: 15 Jan 2006 22:15 Modified: 14 Feb 2006 19:41
Reporter: Peter Gulutzan Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.1.6-alpha-debug OS:Linux (SUSE 10.0)
Assigned to: Andrey Hristov CPU Architecture:Any

[15 Jan 2006 22:15] Peter Gulutzan
Description:
I create an event using the clause ON COMPLETION NOT PRESERVE.
In mysql.event, the on_completion value for this event says
"DROP" instead of "NOT PRESERVE".

How to repeat:
mysql> create event e_63 on schedule every 1 second on completion not preserve do set @a=5;
Query OK, 1 row affected (0.00 sec)

mysql> select on_completion from mysql.event where name = 'e_63';
+---------------+
| on_completion |
+---------------+
| DROP          |
+---------------+
1 row in set (0.00 sec)
[16 Jan 2006 11:14] MySQL Verification Team
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.1.6-alpha-debug

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create event e_63 on schedule every 1 second on completion not preserve
    -> do set @a=5;
Query OK, 1 row affected (0.03 sec)

mysql> select on_completion from mysql.event where name = 'e_63';
+---------------+
| on_completion |
+---------------+
| DROP          |
+---------------+
1 row in set (0.01 sec)
[18 Jan 2006 16:06] 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/1276
[19 Jan 2006 16:15] Sergei Golubchik
I don't think it's a bug - nowhere in the manual we promise that the content of the mysql.* tables will match exactly what you've typed. E.g. you write GRANT ... TO user@host but there's no '@' character in mysql.user table.

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

Page generated in 0.050 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.