Debian Codegraph @

mysql-test/suite/events/events_trans_notembedded.test

raw
1 #
2 # Tests that require transactions
3 #
4 -- source include/not_embedded.inc
5 -- source include/have_innodb.inc
6 --disable_warnings
7 drop database if exists events_test;
8 drop database if exists mysqltest_db2;
9 --enable_warnings
10 create database events_test;
11 use events_test;
12
13 #
14 # Privilege checks
15 #
16 create user mysqltest_user1@localhost;
17 grant create, insert, select, delete on mysqltest_db2.*
18 to mysqltest_user1@localhost;
19 create database mysqltest_db2;
20 connect (conn1,localhost,mysqltest_user1,,mysqltest_db2);
21 set autocommit=off;
22 # Sanity check
23 select @@autocommit;
24 create table t1 (a varchar(255)) engine=innodb;
25 # Not enough privileges to CREATE EVENT
26 begin work;
27 insert into t1 (a) values ("OK: create event: insufficient privileges");
28 --error ER_DBACCESS_DENIED_ERROR
29 create event e1 on schedule every 1 day do select 1;
30 rollback work;
31 select * from t1;
32 delete from t1;
33 commit work;
34 # Not enough privileges to ALTER EVENT
35 begin work;
36 insert into t1 (a) values ("OK: alter event: insufficient privileges");
37 --error ER_DBACCESS_DENIED_ERROR
38 alter event e1 on schedule every 1 day do select 1;
39 rollback work;
40 select * from t1;
41 delete from t1;
42 commit work;
43 # Not enough privileges to DROP EVENT
44 begin work;
45 insert into t1 (a) values ("OK: drop event: insufficient privileges");
46 --error ER_DBACCESS_DENIED_ERROR
47 drop event e1;
48 rollback work;
49 select * from t1;
50 delete from t1;
51 commit work;
52 # Cleanup
53 disconnect conn1;
54 --source include/wait_until_disconnected.inc
55 connection default;
56 drop user mysqltest_user1@localhost;
57 drop database mysqltest_db2;
58
59 #
60 # Cleanup
61 #
62 let $wait_condition=
63 select count(*) = 0 from information_schema.processlist
64 where db='events_test' and command = 'Connect' and user=current_user();
65 --source include/wait_condition.inc
66
67 drop database events_test;
68