mirror of
https://github.com/MariaDB/server.git
synced 2025-02-05 13:22:17 +01:00
dc681953cf
when the execution is very slow, under valgrind, the event might manage to fire more than once, making the test to fail
54 lines
1.3 KiB
SQL
54 lines
1.3 KiB
SQL
#
|
|
# Execute the stored programs created in
|
|
# suite/perfschema/include/program_setup.inc
|
|
#
|
|
|
|
--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");
|
|
|
|
--echo # Event
|
|
|
|
SET GLOBAL event_scheduler=ON;
|
|
|
|
CREATE TABLE table_t(a INT);
|
|
DELIMITER |;
|
|
CREATE EVENT e1 ON SCHEDULE EVERY 2 SECOND ON COMPLETION NOT PRESERVE 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
|
|
|