2 # Tests that require transactions
4 -- source include/not_embedded.inc
5 -- source include/have_innodb.inc
7 drop database if exists events_test;
8 drop database if exists mysqltest_db2;
10 create database events_test;
16 grant create, insert, select, delete on mysqltest_db2.*
17 to mysqltest_user1@localhost;
18 create database mysqltest_db2;
19 connect (conn1,localhost,mysqltest_user1,,mysqltest_db2);
23 create table t1 (a varchar(255)) engine=innodb;
24 # Not enough privileges to CREATE EVENT
26 insert into t1 (a) values ("OK: create event: insufficient privileges");
27 --error ER_DBACCESS_DENIED_ERROR
28 create event e1 on schedule every 1 day do select 1;
33 # Not enough privileges to ALTER EVENT
35 insert into t1 (a) values ("OK: alter event: insufficient privileges");
36 --error ER_DBACCESS_DENIED_ERROR
37 alter event e1 on schedule every 1 day do select 1;
42 # Not enough privileges to DROP EVENT
44 insert into t1 (a) values ("OK: drop event: insufficient privileges");
45 --error ER_DBACCESS_DENIED_ERROR
53 --source include/wait_until_disconnected.inc
55 drop user mysqltest_user1@localhost;
56 drop database mysqltest_db2;
62 select count(*) = 0 from information_schema.processlist
63 where db='events_test' and command = 'Connect' and user=current_user();
64 --source include/wait_condition.inc
66 drop database events_test;