Debian Codegraph @

mysql-test/suite/events/events_trans.test

raw
1 #
2 # Tests that require transactions
3 #
4 -- source include/have_innodb.inc
5 -- source include/not_embedded.inc
6 -- source include/no_view_protocol.inc
7
8 set sql_mode="";
9
10 --disable_warnings
11 drop database if exists events_test;
12 drop database if exists mysqltest_no_such_database;
13 --enable_warnings
14 create database events_test;
15 use events_test;
16
17 --echo
18 --echo Test that Events DDL issue an implicit COMMIT
19 --echo
20 --echo
21 set autocommit=off;
22 # Sanity check
23 select @@autocommit;
24 create table t1 (a varchar(255)) engine=innodb;
25 # Basic: check that successful Events DDL commits pending transaction
26 begin work;
27 insert into t1 (a) values ("OK: create event");
28 create event e1 on schedule every 1 day do select 1;
29 rollback work;
30 select * from t1;
31 delete from t1;
32 commit work;
33 #
34 begin work;
35 insert into t1 (a) values ("OK: alter event");
36 alter event e1 on schedule every 2 day do select 2;
37 rollback work;
38 select * from t1;
39 delete from t1;
40 commit work;
41 #
42 begin work;
43 insert into t1 (a) values ("OK: alter event rename");
44 alter event e1 rename to e2;
45 rollback work;
46 select * from t1;
47 delete from t1;
48 commit work;
49 #
50 begin work;
51 insert into t1 (a) values ("OK: drop event");
52 drop event e2;
53 rollback work;
54 select * from t1;
55 delete from t1;
56 commit work;
57 #
58 begin work;
59 insert into t1 (a) values ("OK: drop event if exists");
60 drop event if exists e2;
61 rollback work;
62 select * from t1;
63 delete from t1;
64 commit work;
65 #
66 create event e1 on schedule every 1 day do select 1;
67 begin work;
68 insert into t1 (a) values ("OK: create event if not exists");
69 create event if not exists e1 on schedule every 2 day do select 2;
70 rollback work;
71 select * from t1;
72 delete from t1;
73 commit work;
74 --echo
75 --echo Now check various error conditions: make sure we issue an
76 --echo implicit commit anyway
77 --echo
78 #
79 begin work;
80 insert into t1 (a) values ("OK: create event: event already exists");
81 --error ER_EVENT_ALREADY_EXISTS
82 create event e1 on schedule every 2 day do select 2;
83 rollback work;
84 select * from t1;
85 delete from t1;
86 commit work;
87 #
88 begin work;
89 insert into t1 (a) values ("OK: alter event rename: rename to same name");
90 --error ER_EVENT_SAME_NAME
91 alter event e1 rename to e1;
92 rollback work;
93 select * from t1;
94 delete from t1;
95 commit work;
96 #
97 create event e2 on schedule every 3 day do select 3;
98 begin work;
99 insert into t1 (a) values ("OK: alter event rename: destination exists");
100 --error ER_EVENT_ALREADY_EXISTS
101 alter event e2 rename to e1;
102 rollback work;
103 select * from t1;
104 delete from t1;
105 commit work;
106 #
107 begin work;
108 insert into t1 (a) values ("OK: create event: database does not exist");
109 --error ER_BAD_DB_ERROR
110 create event mysqltest_no_such_database.e1 on schedule every 1 day do select 1;
111 rollback work;
112 select * from t1;
113 delete from t1;
114 commit work;
115
116 #
117 # Cleanup
118 #
119
120 let $wait_condition=
121 select count(*) = 0 from information_schema.processlist
122 where db='events_test' and command = 'Connect' and user=current_user();
123 --source include/wait_condition.inc
124
125 drop database events_test;
126
127
128 --echo #
129 --echo # Bug#54105 assert in MDL_context::release_locks_stored_before
130 --echo #
131
132 USE test;
133
134 --disable_warnings
135 DROP TABLE IF EXISTS t1, t2;
136 DROP EVENT IF EXISTS e1;
137 --enable_warnings
138
139 CREATE TABLE t1 (a INT) ENGINE=InnoDB;
140 CREATE TABLE t2 (a INT);
141 CREATE EVENT e1 ON SCHEDULE EVERY 1 DAY DO SELECT 1;
142
143 START TRANSACTION;
144 INSERT INTO t1 VALUES (1);
145 SAVEPOINT A;
146 --replace_regex /STARTS '[^']+'/STARTS '#'/
147 SHOW CREATE EVENT e1;
148 SELECT * FROM t2;
149 ROLLBACK WORK TO SAVEPOINT A;
150
151 DROP TABLE t1, t2;
152 DROP EVENT e1;