1CREATE DATABASE IF NOT EXISTS events_test; 2CREATE DATABASE events_conn1_test2; 3CREATE TABLE events_test.fill_it1(test_name varchar(20), occur datetime); 4CREATE TABLE events_test.fill_it2(test_name varchar(20), occur datetime); 5CREATE TABLE events_test.fill_it3(test_name varchar(20), occur datetime); 6CREATE USER event_user2@localhost; 7CREATE DATABASE events_conn2_db; 8GRANT ALL ON *.* TO event_user2@localhost; 9CREATE USER event_user3@localhost; 10CREATE DATABASE events_conn3_db; 11GRANT ALL ON *.* TO event_user3@localhost; 12connect conn2,localhost,event_user2,,events_conn2_db; 13"In the second connection we create some events which won't be dropped till the end" 14connect conn3,localhost,event_user3,,events_conn3_db; 15"In the second connection we create some events which won't be dropped till the end" 16connection default; 17USE events_conn1_test2; 18CREATE EVENT ev_drop1 ON SCHEDULE EVERY 10 MINUTE DISABLE DO SELECT 1; 19CREATE EVENT ev_drop2 ON SCHEDULE EVERY 10 MINUTE DISABLE DO SELECT 1; 20CREATE EVENT ev_drop3 ON SCHEDULE EVERY 10 MINUTE DISABLE DO SELECT 1; 21USE events_test; 22SELECT COUNT(*) FROM INFORMATION_SCHEMA.EVENTS; 23COUNT(*) 24103 25SELECT COUNT(*) FROM INFORMATION_SCHEMA.EVENTS WHERE EVENT_SCHEMA='events_conn1_test2'; 26COUNT(*) 273 28DROP DATABASE events_conn1_test2; 29SELECT COUNT(*) FROM INFORMATION_SCHEMA.EVENTS WHERE EVENT_SCHEMA='events_conn1_test2'; 30COUNT(*) 310 32"Now testing stability - dropping db -> events while they are running" 33CREATE DATABASE events_conn1_test2; 34USE events_conn1_test2; 35SELECT COUNT(*) FROM INFORMATION_SCHEMA.EVENTS WHERE EVENT_SCHEMA='events_conn1_test2'; 36COUNT(*) 3750 38SET @old_event_scheduler=@@event_scheduler; 39SET GLOBAL event_scheduler=on; 40DROP DATABASE events_conn1_test2; 41SET GLOBAL event_scheduler=off; 42SELECT COUNT(*) FROM INFORMATION_SCHEMA.EVENTS WHERE EVENT_SCHEMA='events_conn1_test2'; 43COUNT(*) 440 45CREATE DATABASE events_conn1_test3; 46USE events_conn1_test3; 47SET GLOBAL event_scheduler=on; 48SELECT COUNT(*) FROM INFORMATION_SCHEMA.EVENTS WHERE EVENT_SCHEMA='events_conn1_test3'; 49COUNT(*) 5050 51CREATE DATABASE events_conn1_test4; 52USE events_conn1_test4; 53CREATE DATABASE events_conn1_test2; 54USE events_conn1_test2; 55SELECT COUNT(*) FROM INFORMATION_SCHEMA.EVENTS WHERE EVENT_SCHEMA='events_conn1_test2'; 56COUNT(*) 5750 58connection conn2; 59DROP DATABASE events_conn2_db; 60connection conn3; 61DROP DATABASE events_conn3_db; 62connection default; 63DROP DATABASE events_conn1_test2; 64DROP DATABASE events_conn1_test3; 65SET GLOBAL event_scheduler=off; 66DROP DATABASE events_conn1_test4; 67SET GLOBAL event_scheduler=on; 68connection conn2; 69disconnect conn2; 70connection conn3; 71disconnect conn3; 72connection default; 73USE events_test; 74DROP TABLE fill_it1; 75DROP TABLE fill_it2; 76DROP TABLE fill_it3; 77DROP DATABASE events_test; 78SET GLOBAL event_scheduler=@old_event_scheduler; 79