61 lines
1.5 KiB
SQL
61 lines
1.5 KiB
SQL
#
|
|
# Execute the stored programs created in
|
|
# suite/perfschema/include/program_setup.inc
|
|
#
|
|
--disable_query_log
|
|
SET DEFAULT_STORAGE_ENGINE=XENGINE;
|
|
--enable_query_log
|
|
|
|
--echo #####################
|
|
--echo # Executing queries #
|
|
--echo #####################
|
|
INSERT INTO t1 VALUES (10,20);
|
|
CALL SampleProc1(30,40,50);
|
|
SET @a=1;
|
|
SELECT @a;
|
|
CALL SampleProc2("Jwalamukhi",34);
|
|
SELECT @a;
|
|
CALL SampleProc3();
|
|
CALL SampleProc4();
|
|
SET @change=1;
|
|
SELECT @change;
|
|
UPDATE t2 SET id=22 WHERE name="Jwalamukhi";
|
|
SELECT @change;
|
|
SET @del=1;
|
|
SELECT @del;
|
|
DELETE FROM t1 WHERE i=76;
|
|
SELECT @del;
|
|
SELECT wt_avg(1, 12, 1990, 1121990);
|
|
SELECT fac(5);
|
|
SELECT append("Bolly", "wood");
|
|
|
|
# Clear entries before starting test
|
|
TRUNCATE TABLE performance_schema.events_statements_history_long;
|
|
|
|
--echo # Event
|
|
# Make Sure Event scheduler is ON (by default)
|
|
SELECT COUNT(*) = 1 FROM information_schema.processlist
|
|
WHERE user = 'event_scheduler' AND command = 'Daemon';
|
|
|
|
|
|
CREATE TABLE table_t(a INT);
|
|
DELIMITER |;
|
|
CREATE EVENT e1 ON SCHEDULE EVERY 2 SECOND DO
|
|
BEGIN
|
|
INSERT INTO table_t VALUES(1);
|
|
END|
|
|
DELIMITER ;|
|
|
|
|
# Let e1 insert 1 record into the table table_t
|
|
|
|
--let $wait_condition= select count(*) = 1 from table_t
|
|
--source include/wait_condition.inc
|
|
SELECT * FROM table_t;
|
|
|
|
# Wait till the above one execution of event is instrumented.
|
|
--let $wait_condition= select count(*) = 1 from performance_schema.events_statements_history_long where object_type='EVENT'
|
|
--source include/wait_condition.inc
|
|
|
|
SET GLOBAL event_scheduler=OFF;
|
|
--source include/no_running_event_scheduler.inc
|