1 drop database if exists events_test;
2 drop database if exists mysqltest_no_such_database;
3 create database events_test;
6 Test that Events DDL issue an implicit COMMIT
13 create table t1 (a varchar(255)) engine=innodb;
15 insert into t1 (a) values ("OK: create event");
16 create event e1 on schedule every 1 day do select 1;
24 insert into t1 (a) values ("OK: alter event");
25 alter event e1 on schedule every 2 day do select 2;
33 insert into t1 (a) values ("OK: alter event rename");
34 alter event e1 rename to e2;
38 OK: alter event rename
42 insert into t1 (a) values ("OK: drop event");
51 insert into t1 (a) values ("OK: drop event if exists");
52 drop event if exists e2;
54 Note 1305 Event e2 does not exist
58 OK: drop event if exists
61 create event e1 on schedule every 1 day do select 1;
63 insert into t1 (a) values ("OK: create event if not exists");
64 create event if not exists e1 on schedule every 2 day do select 2;
66 Note 1537 Event 'e1' already exists
70 OK: create event if not exists
74 Now check various error conditions: make sure we issue an
75 implicit commit anyway
78 insert into t1 (a) values ("OK: create event: event already exists");
79 create event e1 on schedule every 2 day do select 2;
80 ERROR HY000: Event 'e1' already exists
84 OK: create event: event already exists
88 insert into t1 (a) values ("OK: alter event rename: rename to same name");
89 alter event e1 rename to e1;
90 ERROR HY000: Same old and new event name
94 OK: alter event rename: rename to same name
97 create event e2 on schedule every 3 day do select 3;
99 insert into t1 (a) values ("OK: alter event rename: destination exists");
100 alter event e2 rename to e1;
101 ERROR HY000: Event 'e1' already exists
105 OK: alter event rename: destination exists
109 insert into t1 (a) values ("OK: create event: database does not exist");
110 create event mysqltest_no_such_database.e1 on schedule every 1 day do select 1;
111 ERROR 42000: Unknown database 'mysqltest_no_such_database'
115 OK: create event: database does not exist
118 drop database events_test;