| 1 |
# Testing mysql_upgrade with EVENT performance_schema.user_event |
| 2 |
create event test.user_event on schedule every 1 day do |
| 3 |
select "not supposed to be here"; |
| 4 |
Warnings: |
| 5 |
Warning 1105 Event scheduler is switched off, use SET GLOBAL event_scheduler=ON to enable it. |
| 6 |
update mysql.event set db='performance_schema' where name='user_event'; |
| 7 |
select name from mysql.event where db='performance_schema'; |
| 8 |
name |
| 9 |
user_event |
| 10 |
update mysql.event set db='test' where name='user_event'; |
| 11 |
drop event test.user_event; |