Debian Codegraph @

mysql-test/suite/events/events_trans.result

raw
1 set sql_mode="";
2 drop database if exists events_test;
3 drop database if exists mysqltest_no_such_database;
4 create database events_test;
5 use events_test;
6
7 Test that Events DDL issue an implicit COMMIT
8
9
10 set autocommit=off;
11 select @@autocommit;
12 @@autocommit
13 0
14 create table t1 (a varchar(255)) engine=innodb;
15 begin work;
16 insert into t1 (a) values ("OK: create event");
17 create event e1 on schedule every 1 day do select 1;
18 Warnings:
19 Warning 1105 Event scheduler is switched off, use SET GLOBAL event_scheduler=ON to enable it.
20 rollback work;
21 select * from t1;
22 a
23 OK: create event
24 delete from t1;
25 commit work;
26 begin work;
27 insert into t1 (a) values ("OK: alter event");
28 alter event e1 on schedule every 2 day do select 2;
29 rollback work;
30 select * from t1;
31 a
32 OK: alter event
33 delete from t1;
34 commit work;
35 begin work;
36 insert into t1 (a) values ("OK: alter event rename");
37 alter event e1 rename to e2;
38 rollback work;
39 select * from t1;
40 a
41 OK: alter event rename
42 delete from t1;
43 commit work;
44 begin work;
45 insert into t1 (a) values ("OK: drop event");
46 drop event e2;
47 rollback work;
48 select * from t1;
49 a
50 OK: drop event
51 delete from t1;
52 commit work;
53 begin work;
54 insert into t1 (a) values ("OK: drop event if exists");
55 drop event if exists e2;
56 Warnings:
57 Note 1305 Event e2 does not exist
58 rollback work;
59 select * from t1;
60 a
61 OK: drop event if exists
62 delete from t1;
63 commit work;
64 create event e1 on schedule every 1 day do select 1;
65 Warnings:
66 Warning 1105 Event scheduler is switched off, use SET GLOBAL event_scheduler=ON to enable it.
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 Warnings:
71 Note 1537 Event 'e1' already exists
72 Warning 1105 Event scheduler is switched off, use SET GLOBAL event_scheduler=ON to enable it.
73 rollback work;
74 select * from t1;
75 a
76 OK: create event if not exists
77 delete from t1;
78 commit work;
79
80 Now check various error conditions: make sure we issue an
81 implicit commit anyway
82
83 begin work;
84 insert into t1 (a) values ("OK: create event: event already exists");
85 create event e1 on schedule every 2 day do select 2;
86 ERROR HY000: Event 'e1' already exists
87 rollback work;
88 select * from t1;
89 a
90 OK: create event: event already exists
91 delete from t1;
92 commit work;
93 begin work;
94 insert into t1 (a) values ("OK: alter event rename: rename to same name");
95 alter event e1 rename to e1;
96 ERROR HY000: Same old and new event name
97 rollback work;
98 select * from t1;
99 a
100 OK: alter event rename: rename to same name
101 delete from t1;
102 commit work;
103 create event e2 on schedule every 3 day do select 3;
104 Warnings:
105 Warning 1105 Event scheduler is switched off, use SET GLOBAL event_scheduler=ON to enable it.
106 begin work;
107 insert into t1 (a) values ("OK: alter event rename: destination exists");
108 alter event e2 rename to e1;
109 ERROR HY000: Event 'e1' already exists
110 rollback work;
111 select * from t1;
112 a
113 OK: alter event rename: destination exists
114 delete from t1;
115 commit work;
116 begin work;
117 insert into t1 (a) values ("OK: create event: database does not exist");
118 create event mysqltest_no_such_database.e1 on schedule every 1 day do select 1;
119 ERROR 42000: Unknown database 'mysqltest_no_such_database'
120 rollback work;
121 select * from t1;
122 a
123 OK: create event: database does not exist
124 delete from t1;
125 commit work;
126 drop database events_test;
127 #
128 # Bug#54105 assert in MDL_context::release_locks_stored_before
129 #
130 USE test;
131 DROP TABLE IF EXISTS t1, t2;
132 DROP EVENT IF EXISTS e1;
133 CREATE TABLE t1 (a INT) ENGINE=InnoDB;
134 CREATE TABLE t2 (a INT);
135 CREATE EVENT e1 ON SCHEDULE EVERY 1 DAY DO SELECT 1;
136 Warnings:
137 Warning 1105 Event scheduler is switched off, use SET GLOBAL event_scheduler=ON to enable it.
138 START TRANSACTION;
139 INSERT INTO t1 VALUES (1);
140 SAVEPOINT A;
141 SHOW CREATE EVENT e1;
142 Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation
143 e1 SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `e1` ON SCHEDULE EVERY 1 DAY STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO SELECT 1 latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
144 SELECT * FROM t2;
145 a
146 ROLLBACK WORK TO SAVEPOINT A;
147 DROP TABLE t1, t2;
148 DROP EVENT e1;