############## mysql-test\t\event_scheduler_func.test ##########################
#                                                                              #
# Variable Name: event_scheduler                                               #
# Scope: GLOBAL                                                                #
# Access Type: Dynamic                                                         #
# Data Type: Boolean                                                           #
# Default Value: OFF                                                           #
# Valid Values: ON, OFF & DISABLED                                             #
#                                                                              #
#                                                                              #
# Creation Date: 2008-03-17                                                    #
# Author:  Salman Rawala                                                       #
#                                                                              #
# Description: Test Cases of Dynamic System Variable "event_scheduler"         #
#              that checks functionality of this variable                      #
#                                                                              #
# Reference: http://dev.mysql.com/doc/refman/5.1/en/                           #
#    server-system-variables.html#option_mysqld_event_scheduler                #
#                                                                              #
################################################################################

-- source include/not_embedded.inc

--disable_warnings
drop table if exists t1;
--enable_warnings

#########################
#   Creating new table  #
#########################

--echo ## Creating new table ##
CREATE TABLE t1
(
id INT NOT NULL auto_increment,
PRIMARY KEY (id),
name VARCHAR(30)
);

--echo '#--------------------FN_DYNVARS_018_01-------------------------#'
####################################################################
#    Setting initial value of event_scheduler to ON and verifying
#    its behavior
####################################################################

--echo ## Setting initial value of variable to ON ##
SET @@global.event_scheduler = ON;
SELECT @@event_scheduler;

--echo ## Creating new event ##
CREATE EVENT test_event_1
ON SCHEDULE EVERY 3 SECOND
DO 
  INSERT into t1(name) values('Record_1');

--sleep 4

SELECT * from t1;

DROP EVENT test_event_1;

--sleep 1
DELETE from t1;
select * from t1;


--echo '#--------------------FN_DYNVARS_018_02-------------------------#'
####################################################################
#    Setting initial value of event_scheduler to OFF and verifying
#    its behavior
####################################################################

--echo ## Setting value of variable to OFF ##
SET @@global.event_scheduler = OFF;
SELECT @@event_scheduler;

--echo ## Creating new event ##
CREATE EVENT test_event_1
ON SCHEDULE EVERY 3 SECOND
DO 
  INSERT into t1(name) values('Record_2');

--sleep 4

--echo ## Table should be empty ##
SELECT * from t1;

DROP EVENT test_event_1;
--echo ## Dropping table ##
DROP table t1;