Bug #81994 | ALTER EVENT errors on definer change | ||
---|---|---|---|
Submitted: | 24 Jun 2016 3:39 | Modified: | 24 Jun 2016 9:34 |
Reporter: | Trey Raymond | Email Updates: | |
Status: | Duplicate | Impact on me: | |
Category: | MySQL Server: DDL | Severity: | S4 (Feature request) |
Version: | 5.6+ | OS: | Any |
Assigned to: | CPU Architecture: | Any | |
Tags: | Definer, Event |
[24 Jun 2016 3:39]
Trey Raymond
[24 Jun 2016 9:34]
MySQL Verification Team
Hello Trey, Thank you for the feature request. This reminds me of Bug #73894. As hartmut pointed, ALTER EVENT can change the DEFINER, but only if at least one other attribute is changed at the same time. -- 5.6.31 mysql> CREATE DEFINER=`root`@`localhost` EVENT `test_event` ON SCHEDULE EVERY 10 SECOND STARTS '2000-01-01 00:00:00' ON COMPLETION PRESERVE ENABLE DO select 1; Query OK, 0 rows affected (0.00 sec) mysql> alter definer=`root`@`127.0.0.1` event test_event; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 mysql> mysql> mysql> alter definer='root'@'127.0.0.1' event test_event COMMENT ''; Query OK, 0 rows affected (0.00 sec) Thanks, Umesh