Debian Codegraph @

mysql-test/suite/events/events_stress.result

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