← Back to branch summary

~jlukas79/+junk/mysql-server

« back to all changes in this revision

Viewing changes to mysql-test/r/event_scheduler_func.result

manual merge 6.0-main --> 6.0-bka-review

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/event_scheduler_func.result
 
1
drop table if exists t1;
 
2
## Creating new table ##
 
3
CREATE TABLE t1
 
4
(
 
5
id INT NOT NULL auto_increment,
 
6
PRIMARY KEY (id),
 
7
name VARCHAR(30)
 
8
);
 
9
'#--------------------FN_DYNVARS_018_01-------------------------#'
 
10
## Setting initial value of variable to ON ##
 
11
SET @@global.event_scheduler = ON;
 
12
SELECT @@event_scheduler;
 
13
@@event_scheduler
 
14
ON
 
15
## Creating new event ##
 
16
CREATE EVENT test_event_1
 
17
ON SCHEDULE EVERY 3 SECOND
 
18
DO 
 
19
INSERT into t1(name) values('Record_1');
 
20
SELECT * from t1;
 
21
id      name
 
22
1       Record_1
 
23
2       Record_1
 
24
DROP EVENT test_event_1;
 
25
DELETE from t1;
 
26
select * from t1;
 
27
id      name
 
28
'#--------------------FN_DYNVARS_018_02-------------------------#'
 
29
## Setting value of variable to OFF ##
 
30
SET @@global.event_scheduler = OFF;
 
31
SELECT @@event_scheduler;
 
32
@@event_scheduler
 
33
OFF
 
34
## Creating new event ##
 
35
CREATE EVENT test_event_1
 
36
ON SCHEDULE EVERY 3 SECOND
 
37
DO 
 
38
INSERT into t1(name) values('Record_2');
 
39
## Table should be empty ##
 
40
SELECT * from t1;
 
41
id      name
 
42
DROP EVENT test_event_1;
 
43
## Dropping table ##
 
44
DROP table t1;