1 files changed, 44 insertions, 0 deletions
diff --git a/mysql-test/r/event_scheduler_func.result b/mysql-test/r/event_scheduler_func.result
new file mode 100644
index 00000000000..8da942e919c
--- /dev/null
+++ b/mysql-test/r/event_scheduler_func.result
@@ -0,0 +1,44 @@
+drop table if exists t1;
+## Creating new table ##
+CREATE TABLE t1
+(
+id INT NOT NULL auto_increment,
+PRIMARY KEY (id),
+name VARCHAR(30)
+);
+'#--------------------FN_DYNVARS_018_01-------------------------#'
+## Setting initial value of variable to ON ##
+SET @@global.event_scheduler = ON;
+SELECT @@event_scheduler;
+@@event_scheduler
+ON
+## Creating new event ##
+CREATE EVENT test_event_1
+ON SCHEDULE EVERY 3 SECOND
+DO 
+INSERT into t1(name) values('Record_1');
+SELECT * from t1;
+id	name
+1	Record_1
+2	Record_1
+DROP EVENT test_event_1;
+DELETE from t1;
+select * from t1;
+id	name
+'#--------------------FN_DYNVARS_018_02-------------------------#'
+## Setting value of variable to OFF ##
+SET @@global.event_scheduler = OFF;
+SELECT @@event_scheduler;
+@@event_scheduler
+OFF
+## Creating new event ##
+CREATE EVENT test_event_1
+ON SCHEDULE EVERY 3 SECOND
+DO 
+INSERT into t1(name) values('Record_2');
+## Table should be empty ##
+SELECT * from t1;
+id	name
+DROP EVENT test_event_1;
+## Dropping table ##
+DROP table t1;